Case Study #1

1. Create an initial entity-relationship diagram for the New Century Health Clinic system

ANS:

2.Normalize your table designs.

ANS:

PATIENT (PATIENT NUMBER, PATIENT FIRST NAME, PATIENT LAST NAME, DATE OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE) 
APPOINTMENT LIST (APPT NUMBER, PATIENT NUMBER, APPOINTMENT DATE, APPOINTMENT TIME, PROVIDER NUMBER)


3.If you identified any new entities during normalization, create a final entity-relationship 
diagram for the system.

ANS:
        This is my final entity-relationship, the same with  number 1.
      

        

4.Write a memo for your documentation file that contains your recommendation about whether a file processing or a database environment should be used. Attach copies of your ERD(s) and normalized designs.

ANS:
         

In investigating the segment material, including the SWL relevant examination, most understudies will recommend that New Century use a database approach in the arrangement of the new structure. In reacting, understudies should observe the characteristics of a record getting ready condition and balance them with the database condition. As the substance points out, the example is toward social database designs that give an all the more successful, versatile, and adaptable condition for customers all through an affiliation. Understudies moreover should observe that a database approach incorporates certain downsides, including an abnormal state of security and wide support/recovery features.