1. sing the following statements for a relation and its functional dependencies, analyze the table and use he required s

[answerhappygod]

1 Sing The Following Statements For A Relation And Its Functional Dependencies Analyze The Table And Use He Required S 1 (50.22 KiB) Viewed 34 times

1. sing the following statements for a relation and its functional dependencies, analyze the table and use he required statements to put the below relation into the BCNF. (CLO) (3 marks) Invoice_Items (InvoiceNumber, InvoiceDate, TotalAmount, Item, Quantity, UnitPrice) InvoiceNumber → InvoiceDate, Total Amount, Item, Quantity, UnitPrice) InvoiceNumber → (InvoiceDate, TotalAmount) invoiceNumber InvolcDate TotalAmount Item Quantity UnitPrice 2018001 04-Oct-18 AED158.50 Dress Shirt 5 AED2.50 2018001 04-Oct-18 AED158 50 Formal Gown 2 AED10.00 2018001 04-Oct-18 AED158.50 Slacks-Mens 10 AED5.00 2018001 04-Oct-18 AED158.50 Slacks-Womens 10 AED6.00 2018001 04-Oct-18 AED158.SO Blouse 2 AED3.50 2018001 04-Oct-18 AED158.50 Suit-Mens 1 AED9.00 2018002 04-Oct-18 AED25.00 Dress Shirt 10 AED2.50 2018003 06-Oct-18 AED49.00 Slacks-Mens 5 AEDS.00 2018003 06-Oct-18 AED49.00 Slacks-Womens 4 AED6.00 2018004 06-Oct-18 AED17.50 Dress Shirt 7 AED2.50 2018009 07-Oct-18 AED12.00 Dress Shirt 2 AED2.50 2018009 07-Oct-18 AED12.00 Blouse 2 AED3.50 2018006 11-Oct-18 AED152.50 Dress Shirt 10 AED2.50 2018006 11-Oct-18 AED152 50 Slacks Mens 10 AED5.00 2018006 11-Oct-18 AED152.50 Stacks-Womens 10 AED6.00 2018006 11-Oct-18 AED152.50 Blouse 5 AED3.50 2018007 11-Oct-18 AED7.00 Blouse 2 AED3.50 2018008 12-Oct-18 12 AED2.50 AED140.50 Dress Shirt