ERD diagrama and Normalization

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:

• Click here for more on this paper.......
  Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted.....

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

• Click here for more on this paper.......
  Click here to have a similar A+ quality paper done for you by one of our writers within the set deadline at a discounted.....