ERD veterinary clinic ERD and 3NF - 43310

Solution Posted by
jordanblink

jordanblink

Rating : (19)A+
Solution Detail
Price: $20.00
  • From: Computer Science,
  • Posted on: Thu 13 Feb, 2014
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description

ERD diagrama nd 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:

 

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

Solution Description

Attachments
ERDVeterinaryClinic.jpeg
ERDVeterinaryCl...
ERDVeterinaryClinic3NF.jpeg
ERDVeterinaryCl...