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 (32.99 KiB) Viewed 38 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)