Page 1 of 1
Q4. The table given below holds information about sales of a hardware store. In this case only the Orderld column is par
Posted: Tue Jul 05, 2022 10:19 am
by answerhappygod
- Q4 The Table Given Below Holds Information About Sales Of A Hardware Store In This Case Only The Orderld Column Is Par 1 (510.56 KiB) Viewed 8 times
Q4. The table given below holds information about sales of a hardware store. In this case only the Orderld column is part of the primary key. [05+05 = 10] a. Rewrite the given table to achieve First Normal Form. b. Decompose the resultant table from part (a) and achieve Second Normal Form. OrderId 12234 CustomerId 1 1 2 3 Order Date 2006.10.22 2006.10.24 2006.09.15 2006.10.22 Items Nt Nuts q-5.Bo Bolts q-10 Sc Screw q=12 Nt Nuts q-5, Sc Screw q-3 Bo Bolts q5