i am a 1st yr student studying busines info systems, this pass paper is giving me probs, would appreciate it if i cud get a response as it wud help me attemp oda questions. thank you!
The questions are Normalize the tabes below until 3NF
1) PROJECT(Prjct_no, Prjct_name, Staff_no, Job_classification, Hourly_rate, Working_hours)
the tables above shows Staff_no, Job_classification, Hourly_rate, Working_hours are the fields that contain repetition value.
2) Normalize the table until 3NF
INVOICE(Cust_No, Cust_Name, Address, Item_code, Item_desc, Item_qty, Item_price, Supp_name, Supp_add)
table above shows Item_code, Item_desc, Item_qty, Item_price, Supp_name, Supp_add are the fields that contain repetition value.
Please help me?