Exercise 5

Due date: 10 December 2008

Normalization Exercise:

Consider "Super Computer Shop" environment. The shop has three main suppliers.

• TTM is the first supplier. The supplier ID is "Sup_01" and the telephone number is 084-333456. TTM is supplying processor and RAM to the Super Computer Shop. It supplies both Pentium 4 processor (Part_ID: Pro_01) and AMD Processor (Pard_ID: Pro_02). Besides, TTM also supplies 512 DDRAM (Part_ID: Ram_05). All the parts have one year full warranty.

• PC World is the second supplier. The supplier ID is "Sup_02" and the telephone number is 084-334526. PC World is supplying printer to the Super Computer Shop. It supplies Canon iP1800 (Part_ID: Pri_03). All the new printers have three years full warranty.

• Intranet is the third supplier. The supplier ID is "Sup_03" and the the telephone number is 084-389763. Intranet is supplying motherboard to the Super Computer Shop. It supplies both Asus motherboard (Part_ID: Mot_08) and Intel motherboard (Part_ID: Mot_09). All the motherboards have one year full warranty.

Convert the data above into First Normal Form, Second Normal Form and Third Normal Form.