Q3:
Posted: Thu Jul 14, 2022 2:28 pm
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]
- Q3 1 (20.14 KiB) Viewed 32 times