Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

Discuss the Rights issue procedure in detail.

Answered: 1 week ago

Question

Discuss the Rights issue procedure in detail.

Answered: 1 week ago

Question

Explain the procedure for valuation of shares.

Answered: 1 week ago

Question

Which months of this year 5 Mondays ?

Answered: 1 week ago

Question

Define Leap year?

Answered: 1 week ago

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago