New Century Health Clinic 1. Create an initial entity-relationship diagram for the New Century Health Clinic system Answers will vary depending on the logical design that students prepared during thes ystems analysis phase of the SDLC. Students should understand and apply the guidelines on ERDs and cardinality described in this chapter. The form of the diagram is not important — systems analysts use various styles, and each CASE tool has its own way of displaying the information. The main objective is to represent the entities and the relationships among them. A sample diagram follows: 2. Normalize your table designs PATIENT ( PATIENT_NUMBER , PATIENT FIRST NAME, PATIENT LAST NAME, DATE OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE) APPOIN TMENT ( APPT NUMBER , PATIENT NUMBER, APPOINTMENT DATE, APPOIN TMENT TIME, PROVIDER NUMBER) APPT_SERVICE ( APPT_SERVICE_NUMBER , APPT NUMBER, CPT CODE, STATUS, FEE, EXPLANATION)...
