Homework 3
Draw the relational schema for each of the following.
1.
2. Note: The double circle represents a multivalued attribute.
2
3.
NOT Multivalued!!!! It is a COMPOSIT Key only!
4. Normalize and draw the relational schema for the following. Note: The dotted attribute is a derived attribute.
5. The following table contains sample data for PART SUPPLIERS.
Part_No
Description
Vendor Name
Address
Unit_Cost
1234
Logic Chip
Fast Chips
Cupertino
10.00
Smart Chips
Phoenix
8.00
5678
Memory Chip
Fast Chips
Cupertino
3.00
Quality Chips
Austin
2.00
Smart Chips
Phoenix
5.00
6. Normalize the following relationship – draw the relational schema.
7. The following figure provides a sample report card from OU. Convert this user view to a set of 3NF relations. Assume the following: An instructor has a unique location, a student can have more than one major, and a course has a unique title.
EXTRA CREDIT
