Normalization

[philmetz]

I gathered an unnormalized list as follows:
0NF
R1 = (ABN, Garage_Address, Garage_Tel, Garage_Fax, Tax_Invoice_No (Customer_No, Customer_Name, Customer_Address, Contact_Phone, Mobile, Vehicle_Info (Staff_No, Staff_Name, Advisor (Part_ID, Description, QTY, Unit_Price, Amount, Part_Total (Labour_ID, Description, Amount, Labour_Total)))))


Not i was wondering how the 1NF, 2NF and 3NF would look like if someone can help?

thx

[philmetz]

OK iv changed the first one, heres the full thing:

0NF
R1 = (ABN, Garage_Address, Garage_Tel, Garage_Fax, Tax_Invoice_No (Customer_No, Customer_Name, Customer_Address, Contact_Phone, Mobile, Vehicle_Info (Staff_No, Staff_Name, Advisor (Part_ID, Description, QTY, Unit_Price, Amount, Part_Total (Labour_ID, Description, Amount, Labour_Total)))))

1NF
R11 = (Tax_Invoice_No, ABN, Garage_Address, Garage_Tel, Garage_Fax)
R12 = (Customer_No, Customer_Name, Customer_Address, Contact_Phone, Mobile, Vehicle_Info (Staff_No, Staff_Name, Advisor (Part_ID, Description, QTY, Unit_Price, Amount, Part_Total (Labour_ID, Description, Amount, Labour_Total))))

2NF
R11 = (Tax_Invoice_No, ABN, Garage_Address, Garage_Tel, Garage_Fax)
R121 = (Tax_Invoice_No, Customer_No, Customer_Name, Customer_Address, Contact_Phone, Mobile, Vehicle_Info)
R122 = (Tax_Invoice_No, Staff_No, Staff_Name, Advisor)
R123 = (Tax_Invoice_No, Customer_No, Part_ID, Description, QTY, Unit_Price, Amount, Part_Total, Labour_ID, Description, Amount, Labour_Total)

3NF
R11 = (ABN, Garage_Address, Garage_Tel, Garage_Fax, Tax_Invoice_No)
R1211 = (Tax_Invoice_No, Customer_No)
R1212 = (Customer_No, Customer_Name, Customer_Address, Contact_Phone, Mobile, Vehicle_Info)
R1221 = (Tax_Invoice_No, Staff_No)
R1222 = (Staff_No, Staff_Name, Advisor)
R1231 = (Tax_Invoice_No, Customer_No, Part_ID, Labour_ID)
R1232 = (Part_ID, Description, QTY, Unit_Price, Amount, Part_Total)
R1233 = (Labour_ID, Description, Amount, Labour_Total)




How is it?