QUESTION I Value-Plus Electrical Supplies Sds Bhd sells electrical components to housing developers in the Klang Valley.

[answerhappygod]

Question I Value Plus Electrical Supplies Sds Bhd Sells Electrical Components To Housing Developers In The Klang Valley 1 (26.96 KiB) Viewed 31 times

QUESTION I Value-Plus Electrical Supplies Sds Bhd sells electrical components to housing developers in the Klang Valley. The following table is an extract of the logical view of the user from the accounts receivable department regarding the amribute values of the entities involved in the invoicing process. L Toral lavin 5 levore Orde Can Sedate F er code Dan st Canon ST address Fred Qua C Sale pre Y Ny No code Soll (RM) (RM) Balance (070 (KM) SILL 2008 320 3215 pob As 100 50.00 8500 50000 0 S111 2/408 320 3285 Ipoh M008 30 12000 24000 8.500 $ D $112 29/08 331 Pe C212 40 15.00 34000 9,600 D $112 2/9/08 2465 8131 200 Peng 9,600 25.00 50000 0 5113 3908 318 1327 ABC KL MOUS 12,500 30 1200 36000 0 DO $113 3/9/05 318 1327 KL B133 30 25.00 0 20000 。 ADC 90 12,500 $111 3/9/18 318 ABC 1327 KU ADIS 125 50.00 61500 12,500 D The company uses the relational database model for its database design and the above table has not been normalized Required: i) Why are unnormalized tables generally not acceptable for database design? (3 marks) II) State the well-accepted rule(s) for normalization of a relation to: a Second normal form (2NF) b. Third normal form (3NF) (4 marks) Normalize the above table that represents user's logical view to the 3NF Indicate clearly the primary key and the foreign key, if applicable, in each of the relations. 118 marks) (Total: 25 marks) XYZ co XYZ 20 DKP DIP