ERD diagrama nd Normalization

profilePJE123
Home>Homework Answsers>Information Systems homework help

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

    • 12 years ago
    • 20
    Report issue
    Answer(2)
    profile
    jordanblink
    5.0 (68)
    5.0 (4)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      erdveterinaryclinic.jpeg
    • attachment
      erdveterinaryclinic3nf.jpeg
    profile
    mmokros
    5.0 (6)
    5.0 (2)
    Chat

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      erd_diagram_and_normalization.docx
    Bids(1)