Database Systems Assessment: ERD Model for Occupational Therapy Clinic

Desklib provides past papers and solved assignments for students. This project details an ERD for an OT clinic database.

ITC556
DATABASE SYSTEMS ASSESSMENT
ITEM 2

Table of Contents
Business Rules...........................................................................................................................3
ERD...........................................................................................................................................4
Conclusion.................................................................................................................................5
References.................................................................................................................................6
2

Business Rules
 Each Client uniquely identified by the client_number.
 Each Appointment is identified uniquely with app_id.
 Each treatment is identified by code_of_treatment. Cannot contain duplicate codes.
 Each therapist is identified by therapist_id. Cannot contain duplicate codes.
 History_ID is identified in History entity as a Primary key.
 Visit payment entity contains pay_id.
 Also, one to many relationship is mentioned between treatment and treatment booking
which actually caused many to many relationship before appointments and treatment.
 One to many relationship is also shown between clinic_Client and treatment_booking,
treatment_booking and visit_payment, etc.
 Foreign keys are also defined in almost every entity. Foreign keys defined are
code_of_treatment, client_nember and many more.
3

ERD
4

Conclusion
The conclusion of the report contains a summary of the work done in the report. The report
explains the scenario of the OT clinic that provides different facilities to their clients. Skin
treatment is one of them that actually provides many benefits to the clients and also various
therapists are made available for different treatments provided to the clients. A Crow foot
diagram is made available that explains the whole scenario of the clinic. The relational model
is made on this scenario and drawn on draw.io.
5

References
Memari, M., Link, S., & Dobbie, G. (2015, October). SQL data profiling of foreign keys.
In International Conference on Conceptual Modeling (pp. 229-243). Springer, Cham.
Kruse, S. L. K., & Wells, M. G. (2016). Optionality of ERD Relationships: Project for the
Introduction to Database Course. In Proceedings of the EDSIG Conference ISSN (Vol. 2473, p.
3857).
6