2. Normalize the following dependency diagram into second normal form (2NF) and third normal form (3NF). Provide reasoning and show all your work. Draw the global relation diagram for the 3NF only. Material Material_Unit_Of_Standard_Vendor Vendor_Unit_ Terms_ Terms ID Name Measure Cost ID Name Price Code
Added by Carlos A.
Close
Step 1
Step 1: Identify the Functional Dependencies From the diagram, we can identify the following functional dependencies: - Material_ID → Material_Name, Unit_Of_Measure, Standard_Cost - Vendor_ID → Vendor_Name - Terms_Code → Terms - (Material_ID, Vendor_ID) → Show more…
Show all steps
Your feedback will help us improve your experience
Vaibhav Jain and 95 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
For the following table, draw a dependency diagram. Indicate any partial or transitive dependencies on your diagram. Then, decompose this table into tables in third normal form. The primary key is underlined. Invoice No | Product No. | Sale Date | Prod Desc | Vend Code | Vend Name | Qty Sold | Prod Price 211347 | AAE33 | 3/25/98 | Drill Bit | 211 | Black&Decker | 3 | 2.95 211347 | AR456 | 3/25/98 | Drill | 211 | Black&Decker | 1 | 29.99 211348 | AR444 | 4/5/99 | Screw | 133 | Acme | 55 | .17
Akash M.
The following figure shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. NOTE: In the EMPLOYEE entity, you can assume an additional attribute EmpType that serves as a subtype discriminator. Transform the EER diagram into a 3NF relation schema and show all the dependencies.
Aarya B.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD