Homework three

Draw the relational schema for each of the following.

1.

2. Notice: The double circle represents a multivalued attribute.

2

three.

NOT Multivalued!!!! It’s a COMPOSIT Key solely!

four. Normalize and draw the relational schema for the following. Notice: The dotted attribute is a derived attribute.

5. The next desk accommodates pattern knowledge for PART SUPPLIERS.

Part_No

Description

Vendor Identify

Deal with

Unit_Cost

1234

Logic Chip

Quick Chips

Cupertino

10.00

Sensible Chips

Phoenix

eight.00

5678

Reminiscence Chip

Quick Chips

Cupertino

three.00

High quality Chips

Austin

2.00

Sensible Chips

Phoenix

5.00

6. Normalize the following relationship – draw the relational schema.

7. The next determine offers a pattern report card from OU. Convert this consumer view to a set of 3NF relations. Assume the following: An teacher has a novel location, a pupil can have a couple of main, and a course has a novel title.

EXTRA CREDIT

Published by
Medical
View all posts