Page 1 of 1
QUESTION 5 VET_TREATMENT (Pet_Num, Pet_Name, Owner_Num, Owner_Name, a) b) c) d) Owner_PhoneNum, {Med_ID, Med_Name, Med_D
Posted: Fri Jul 08, 2022 6:37 am
by 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 37 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)