Question: Create an ER diagram based on the given requirements for a Zoo Management System shown below. Make sure to show the following information on the
Create an ER diagram based on the given requirements for a
Zoo Management System shown below. Make sure to show the
following information on the diagram: Entities, Attributes,
Relationships, Cardinality ratios, TotalPartial participations,
Keys.
State any assumptions you make.
Requirements:
The zoo has multiple animals, and each animal has a
unique ID name, species, age, and enclosure ID
Each enclosure can house multiple animals, and each
enclosure has a unique ID type eg Aquatic, Terrestrial,
Aviary and capacity.
The zoo has multiple visitors, each with a unique visitor ID
name, age, and ticket type eg Adult, Child, Senior
Visitors can purchase tickets to enter the zoo, and each
ticket has a unique ticket ID purchase date, and is linked to
a specific visitor.
The zoo offers educational programs and events, each with
a unique program ID name, date, and description. Each
program can have multiple visitors participating.
The zoo has staff members who care for the animals. Each
staff member has a unique staff ID name, role, and
assigned enclosure.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
