ITC556 Database Systems: ERD for Organic Pastures Clinic

Desklib provides past papers and solved assignments for students. This report details the database design for Organic Pastures Clinic.

ITC556 - DATABASE SYSTEMS

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

Business Rules
 In the entity Record, every record is uniquely identified by record id.
 For every record, there is an appoint id which is assigned.
 Every therapist has different specialization so unique ID of therapist will help to
differentiate every therapist.
 Appointments for every customer are unique so ID of the appointment will help in
identifying different appointments of the clients.
 There is a many-to-many relationship between the treatment and the appointment entities
so in order to remove that Treatment_bookings entity is created which is connected to the
appointment and treatment with one-to-many relationship individually.
 For every booking, there is an ID which is assigned and similarly, for the treatment
entity, a unique code is created.
 There is a one-to-one relationship between the record entity and the appointment entity
shown in the diagram.
 For every payment of the client, there is a unique ID that is created.
 In the entity appointment, there are two foreign keys named as TB_ID and TH_ID which
are taking reference from other tables named as Treatment_Booking and Therapist.
 Another foreign key is TB_ID which is present in payments and taking reference from
the treatment_bookings table also a T_CODE foreign key in treatment_booking taking
reference from treatments table.
3

ERD
Figure 1: Crow's Foot Notation
4

Conclusion
The conclusion of the report contains an overall view of the scenario which is given that is of a
clinic named OPC (Organic Pastures Clinic) that provides different offers to the client related to
the beauty treatments for the different age group customers (Churchill, et al,. (2019)). this clinic
provides treatment of the skins that provide relaxation and comfort to the clients for their
satisfaction. This particular assessment needs a Crow Foot Notation in order to provide an
overall scenario including different entities and attributes of the clinic. For every table, there are
different constraints that are added in the table which include the primary key and the foreign
keys. Every entity is interconnected with different relationships and in this particular diagram,
two relationships are shown, one is a one-to-many relationship and another is a one-to-many
relationship. All these are created and explained with the help of diagram (García, et al,.(2016)).
5

References
Churchill, C. D., Winter, P., Tuszynski, J. A., & Levin, M. (2019). EDEn–Electroceutical Design
Environment: Ion Channel Tissue Expression Database with Small Molecule Modulators. iScience, 11,
42-56.
García, M. M., Denno, B. D., Miller, D. R., Miller, G. L., Ben-Dov, Y., & Hardy, N. B. (2016). ScaleNet:
a literature-based model of scale insect biology and systematics. Database: the journal of biological
databases and curation, 2016.
6