ITC556 Database Design Report: Organic Pasture Clinic

Access past papers and solved assignments. This report details the database design for Organic Pasture Clinic.

ITC556
ASSESSMENT ITEM 2

Table of Contents
Business Rules.................................................................................................................................2
Crow’s Foot Diagram......................................................................................................................3
Conclusion......................................................................................................................................4
References.......................................................................................................................................5
Figures
Figure 1: Crow's Foot Diagram.......................................................................................................3
2

Business Rules
 For every Client who takes the appointment for the treatment, there is a unique id which
will identify with C_id for every different client.
 As every client will take an appointment so there will be unique id for appointment as
well which is Appnt_id.
 Every record will be uniquely identified with the help of rec_id.
 As every therapist has expertise in a different field so there is Th_id also for unique
identification.
 For every customer, there is a different treatment provided by the therapist so the T_code
named attribute will define this.
 A booking of treatments entity is created because the entities treatments, as well as
appointments, are making many to many relationship between them so to remove it this
another entity is created.
 There are few foreign key constraints are also added in this diagram like B_id and Th_id
for appointments table which is taking reference from booking and therapist tables.
 Similarly, in payment and booking_of_treatments entity B_id and T_id are the foreign
keys which are taking reference from other tables namely, Bookings and treatment tables.
 These all entities are interconnected with one-to-many relationships and shown with the
arrows in the diagram (Almola, F., & Hamdan, M. A. E. 2015).
3

Crow’s Foot Diagram
Figure 1: Crow's Foot Diagram
4

Conclusion
The report explains the whole scenario of the clinic i.e. Organic Pasture Clinic. OP Clinic helps
in providing different facilities to its clients. Skin Treatments and many other treatments are
provided to the clients that are to be treated with the help of different (Fachada, N. 2018). The
process of providing facilities to the clients is explained properly through the crow feet diagram.
Seven entities are being defined in the design to showcase the whole scenario. To clearly
represent the clinic’s view of working Primary as well as the foreign keys are also mentioned in
the diagram. The design is made on draw.io.
5

References
Almola, F., & Hamdan, M. A. E. (2015). A Comparative Study Between Paper-Based and
Online-Based Questionnaires A Case Study: Faculty of Mathematical and Computer Sciences,
University of Gezira, Sudan (Doctoral dissertation, University of Gezira).
Fachada, N. (2018). Teaching database concepts to video game design and development
students. Revista Lusófona de Educação, 40(40).
6