DATABASE SYSTEMS.

Running head: DATABASE SYSTEMS
Database Systems
Name of the Student
Name of the University
Authors’ note:

1DATABASE SYSTEMS
Entity Relationship Diagram:
Figure 1: Entity Relationship Diagram of Singa Animal Hospital
(Source: Created by Author)
Relationship between Entities:
There are various types of staff available in the Singa Animal Hospital. Only the
consulting staff examines a pet. That is why staff has optional relational with the examination.
One staff can examine more than one pet. That is why the cardinality is one-to-many. One pet
can be brought for examination for multiple time. An examination will be done on a pet. Without
pet an examination cannot be done. That is the relationship is one-to-many and optionality is
mandatory. One owner can have many pets. If a person does not have a pet then he is not
registered the same is for a pet. That is the why relationship is one-to-many and optionality is
mandatory. A consulting doctor can prescribe one or more treatment for an examination. As