GOAL:

1. 1. In what normal form is the table that was presented to us?
2. 2. Is there a full dependency here? If so, what is the full dependency?
3. 3. Are there 1 or more partial dependencies? If so, what are they?
4. 4. Is there any transitive dependency? What is/are they?
   5. Draw the corresponding logical model for this veterinary in 3^rd normal form (3NF).

VISIT Visit_Client Client_Client_A Pet_ID PetName Pet ID Date _ID Name ddress Species PetRace Diagnosis Ilness_N Ordered_Visit_ ID ame Treatment Cost V1 01/15 c1 John 123, CA P1 Paco Dog Ulcer Pill1 $20 V2 02/02 C2 Perla Dog Broken Surgery2 $800 Lhasa_A D1 phso Dalmati D2 an Mix D3 Guacam D4 ayo Leg V3 Jennifer 14 ST, P3 CA John 123, CA P2 Tian 23 ST, P4 NY 02/03 C1 02/15 C3 Pill3 Lucky Luna Cat Parrot Allergy Hip injury $250 $950 14 Surgery1 Our veterinary client has noted that for each client's visit, they aim to record information on the client, which pet is being brought for treatment, the diagnosis, and the treatment ordered and cost for a given visit and a for a given diagnosis. Key notes: Based on this, we have identified the combination of the Visit ID and the Treatment ID as being the key that uniquely identifies each row of data in the table presented. The ordered treatment and its corresponding costs were also explained to be for a given visit and a given diagnosis as implied above. "Illness.name" represents the diagnosis name as suggested by the diagnosis ID. A particular visit is for only one client, though each client can have more than one pet as shown by John having both a Dog and a Cat. VISIT Visit_Client Client_Client_A Pet_ID PetName Pet ID Date _ID Name ddress Species PetRace Diagnosis Ilness_N Ordered_Visit_ ID ame Treatment Cost V1 01/15 c1 John 123, CA P1 Paco Dog Ulcer Pill1 $20 V2 02/02 C2 Perla Dog Broken Surgery2 $800 Lhasa_A D1 phso Dalmati D2 an Mix D3 Guacam D4 ayo Leg V3 Jennifer 14 ST, P3 CA John 123, CA P2 Tian 23 ST, P4 NY 02/03 C1 02/15 C3 Pill3 Lucky Luna Cat Parrot Allergy Hip injury $250 $950 14 Surgery1 Our veterinary client has noted that for each client's visit, they aim to record information on the client, which pet is being brought for treatment, the diagnosis, and the treatment ordered and cost for a given visit and a for a given diagnosis. Key notes: Based on this, we have identified the combination of the Visit ID and the Treatment ID as being the key that uniquely identifies each row of data in the table presented. The ordered treatment and its corresponding costs were also explained to be for a given visit and a given diagnosis as implied above. "Illness.name" represents the diagnosis name as suggested by the diagnosis ID. A particular visit is for only one client, though each client can have more than one pet as shown by John having both a Dog and a Cat