Page 1 of 1
Invoice (InvoicelD, ItemNum, InvoiceDate, ItemLabel, ItemPrice, SupplierID, SupplierName, QuantitySold) a) Identify the
Posted: Thu Jul 14, 2022 2:28 pm
by answerhappygod
- Invoice Invoiceld Itemnum Invoicedate Itemlabel Itemprice Supplierid Suppliername Quantitysold A Identify The 1 (18.19 KiB) Viewed 39 times
Invoice (InvoicelD, ItemNum, InvoiceDate, ItemLabel, ItemPrice, SupplierID, 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]