QUESTION 5 VET_TREATMENT (Pet_Num, Pet_Name, Owner_Num, Owner_Name, a) b) c) d) Owner_PhoneNum, {Med_ID, Med_Name, Med_D

[answerhappygod]

Question 5 Vet Treatment Pet Num Pet Name Owner Num Owner Name A B C D Owner Phonenum Med Id Med Name Med D 1 (29.61 KiB) Viewed 35 times

QUESTION 5 VET_TREATMENT (Pet_Num, Pet_Name, Owner_Num, Owner_Name, a) b) c) d) Owner_PhoneNum, {Med_ID, Med_Name, Med_Description}, Dosage) State the stage of normalization for the above relational schema. Give TWO (2) reasons for your answer. (3 marks) Identify and list TWO (2) primary keys. Identify and list the partial and transitive dependencies. Normalize the table into 3NF. Show all works for each normalization stage. (2 marks) (3 marks) (7 marks)