- Q3 1 (20.14 KiB) Viewed 31 times
Q3:
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Q3:
Q3:
Section B: Question 3 - Normalization [20 marks] Based on the following schema: Invoice (InvoicelD, ItemNum, InvoiceDate, ItemLabel, ItemPrice, SupplierlD, SupplierName, QuantitySold) a) Identify the partial dependencies and transitive dependencies in the schema. [5 marks] b) Draw Dependency Diagram that is in First Normal Form (1NF). [5 marks] c) Write the Relational Schema that conform to Second Normal Form (2NF) or Third Normal Form (3NF). Identify normal form for each relation you have created. [8 marks] d) Draw a basic Entity Relationship Diagram based on your schema in Question 3(c). [2 marks]
Section B: Question 3 - Normalization [20 marks] Based on the following schema: Invoice (InvoicelD, ItemNum, InvoiceDate, ItemLabel, ItemPrice, SupplierlD, SupplierName, QuantitySold) a) Identify the partial dependencies and transitive dependencies in the schema. [5 marks] b) Draw Dependency Diagram that is in First Normal Form (1NF). [5 marks] c) Write the Relational Schema that conform to Second Normal Form (2NF) or Third Normal Form (3NF). Identify normal form for each relation you have created. [8 marks] d) Draw a basic Entity Relationship Diagram based on your schema in Question 3(c). [2 marks]
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!