A veterinary clinic manages the medicalcare needed for pets. A pet owner may have several pets (dogs, cats, rabbits,etc.), with the following restrictions:
I. Each pet belongs to aparticular owner.
2. Eachpet is fussy and eats only particular types of pet food.
3. Morethan one pet may eat each type of pet food.
4. Eachpet may take several medications.The dosage will vary for each pet.
Use the information provided above, supplemented with your knowledgeofveterinary clinics and pets to create:
1)an ERD and 2) a set of third normalform relations to represent the pet clinic database. Use only the following attributes:
OwneriD
PetFoodName
#OfPetsOwned
OwnerName
PetType
FoodCostPerPound
PetiD
PetAge
MediD
PetName
OwnerPhone#
MedDosage
Do not includeforeign keys on the ERD. Underline the primary key of each relation. It may be
helpful to create your own sample data. Document any additional assumptions you make
0 comments