New Century Wellness Group Offers a holistic approach to healthcare with an emphasis on preventative medicine as well traditional medical care. In your role as an IT consultant, you will help New Century develop a new information system.

Background

After completing the user interface, input and output design for the new information system, you will now focus on the data design of DBMS that will support the system. Begin by reviewing the DFDs that you prepared in chapter 5 and the object models that you created Chapter 6.

Tasks

1. Create an initial ERD for the new system that contains at least eight entities.

2. Analyze each relationship to determine if it is 1:1, 1:M, M:N

3. normalize your designs for all tables to ensure they are 3NF, and verify that all primary, secondary, and foreign keys are identified properly. Update your ERD to reflect any changes.