SECTION D: CASE STUDY

The following figure represents the appointment card of Azure's Pet Veterinary Clinic. Each

pet is required to have a specific card, and owners must bring the card for treatment. Due to the

high number of appointments, each visit is limited to only one pet and procedure at a time. As

a Database Analyst, your task is to design a database system for the clinic. Identify all the

possible functional dependencies $($FDs$)$ and normalize the table to the third normal form.

Finally, illustrate the final normalized table as an Entity$-$Relationship Diagram $($ERD$).$

Phone: $0102567890$

A$2$UES PET

GLNIG

Phone: $0135244678$

Answer: