Question
Create a Entity-Relationship Diagram (ERD) using standard ERD notation for cardinalities for the following information: A pet has a name, an owner, a species, a
Create a Entity-Relationship Diagram (ERD) using standard ERD notation for cardinalities for the following information:
A pet has a name, an owner, a species, a sex, a birth date, and a death date:
name | owner | species | sex | birth | death |
---|---|---|---|---|---|
Fluffy | Harold | cat | f | 1993-02-04 | |
Claws | Gwen | cat | m | 1994-03-17 | |
Buffy | Harold | dog | f | 1989-05-13 | |
Fang | Benny | dog | m | 1990-08-27 | |
Bowser | Diane | dog | m | 1979-08-31 | 1995-07-29 |
Chirpy | Gwen | bird | f | 1998-09-11 | |
Whistler | Gwen | bird | 1997-12-09 | ||
Slim | Benny | snake | m | 1996-04-29 |
An event in the pets life is something that happens to the pet. An event has the pet to which it happened, a date, a type, and a remark:
name | date | type | remark |
Fluffy | 5/15/1995 | litter | 4 kittens, 3 female, 1 male |
Buffy | 6/23/1993 | litter | 5 puppies, 2 female, 3 male |
Buffy | 6/19/1994 | litter | 3 puppies, 3 female |
Chirpy | 3/21/1999 | vet | needed beak straightened |
Slim | 8/3/1997 | vet | broken rib |
Bowser | 10/12/1991 | kennel | |
Fang | 10/12/1991 | kennel | |
Fang | 8/28/1998 | birthday | Gave him a new chew toy |
Claws | 3/17/1998 | birthday | Gave him a new flea collar |
Whistler | 12/9/1998 | birthday | First birthday |
A vet is a person, and has a name, an address, and a phone number. For the purposes of this exercise, assume all vets work as sole practitioners; we dont have partnerships here. Its possible a pet will have no veterinarian (it may be very young). Its also possible a pet will have more than one veterinarian.
Assume that the vet is not related to an event. A vet may only (possibly) be related to a pet in that the pet could be the client of a particular vet. Events are completely independent of veterinarians.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started