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