Reference no: EM133148666

CASE STUDY

You have been preparing the System Requirement report for the partners. From your investigation so far, you are leaning towards a recommendation for either in-house development or outsourcing options for the new system. You are not sure that a commercial software package would meet all the Clinic's needs.

Based on your research, you felt that it would be premature to select a development strategy at this time. Instead, you recommended to the partners that an in-house team should develop a design prototype, using a relational database as a model. You said that the prototype would have two main objectives:
- it would represent a user-approved model of the new system, and
- it would identify all system entities and the relationships between them.

You explained that it would be better to design the basic system first, and then address other issues, including Web enhancements and implementation options. You proposed a three-step plan:
1. data design
2. user interface design, and
3. application architecture.

You explained that systems analysts refer to this as the system design phase of a development project. The partners agreed with your recommendation and asked you to go forward with the plan.

ACTIVITY

1. Review the Good Health Clinic's fact-finding summary and all other information you have about the required system. Be willing to critically analyse this for duplications and inconsistencies.

2. Draw an ERD with crows-foot cardinality notation. Assume that system entities include patients, practitioners (doctors, therapist and nurses), procedures, costs, appointments, dates, times etc....

3. Design tables - making sure each table only refers to one "thing". As you create the database design, identify primary and foreign keys by underlining primary keys, and making foreign keys italic.

4. If you add primary keys which use codes - for example a code for the procedureID, then identify the format of these codes.

5. Create suitable sample data to populate the fields for at least three records in each table.

6. Include the following in your report:
• The ERD you have completed;
• The database design (schemas);
• Formats of codes used;
• Sample data for each table.