Database Systems (ITC 556) Assessment 2: Clinic Management ERD

Desklib provides past papers and solved assignments for students. This project includes an ER diagram for a clinic database.

ITC 556 DATABASE SYSTEMS
ASSESSMENT 2

Table of Contents
Business Rules...........................................................................................................................3
Entity Relationship Diagram..................................................................................................3
References.................................................................................................................................5
2

Business Rules
CLN_ID is assigned as a Primary Key in Clients entity, BD_ID is assigned as a Primary Key
in BookingsDone similarly TC_Code in TreatmentOfClint, Thrp_ID in TherapistsInClinic,
Apn_ID in AppointmentOfClnt, PP_ID in PricePaid and DD_ID in Data are the Primary
Keys. One to Many relationships is also shown in the ERD made. Between Clients and
BookingDone, one client can make many Bookings. One treatment of client can also make
multiple bookings, also bookings made can have multiple prices. Each Therapist can have
multiple appointments . A Booking can consist of multiple appointments. Only one, one to
one relationship is defined in the ERD that is between Data and AppointmentsOfClnt.
Foreign Keys are also been defined in the ERD as they are referenced from different entities.
The ER diagram below is shown-
Entity Relationship Diagram
3

Figure 1: Entity Relationship Diagram
4

The above made ERD explains the whole scenario of the Clinic that helps the clients or its
customers to get benefits of various treatments provided by the therapists present in the Clinic
(Saifullin et al., 2018). Treatments such as skin treatments etc. are being provided to the
client by the Organic Pasture Clinic.
5

References
 Saifullin, E. R., Nazarychev, S. A., Malahov, A. O., Misoedova, E. Y., & Larionova, I. V.
(2018, July). The algorithm diagram of combustion optimizing of a hydrocarbon fuels
variable composition in thermal power plants. In Journal of Physics: Conference
Series (Vol. 1058, No. 1, p. 012059). IOP Publishing.
 Al-Btoush, A. A. S. (2015). Extracting Entity Relationship Diagram (ERD) from English
Sentences. International Journal of Database Theory and Application, 8(2), 35-244.
6