Use ErdPlus to create Entity Relation Diagram then Convert the diagram into relational-schema and using either word or ppt draw the functional dependencies for each problem
aj-120
Homework.docxHomework 3
Draw the relational schema for each of the following.
1.
2. Note: The double circle represents a multivalued attribute.
2
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
