Description of this paper

Loading

Consider a small veterinarian clinic. The clinic keeps track of-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

Consider a small veterinarian clinic. The clinic keeps track of their pet, their owners, visits, as well as procedures performed for the pets.

An owner may have more than one pet. Pets may be seen more than once in the clinic and may have repeated procedures. Each has their own record.

Provide the 3rd normal form of the following data model:

PetID, Pet_Name, Pet_Age, Pet_TypeID, Pet_Type_Name, Pet Age, Owner_Name, Owner_Phone, Visit_Date, ProcedureID, Procedure_Name

Visit_date, ProcedureID, and Procedure_name are repeated fields.

 

Paper#9209614 | Written in 27-Jul-2016

Price : $19
SiteLock