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
Get step-by-step solutions from verified subject matter experts
