Create an initial erd for the new system

Assignment Help Database Management System

Reference no: EM132082651

New Century Wellness Group offers a holistic approach to healthcare with an emphasis on preventive medicine as well as 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 the DBMS that will support the system. Begin by reviewing the DFDs that you prepared in Chapter 5 and the object models that you created in Chapter 6.

Tasks

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

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

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.

Review the Data Dictionary you created in Chapter 5 and double-check all data dictionary entries. Make sure that the entries for data stores, records, and data elements are documented completely and correctly. Determine what codes, if any, will be used and be sure they are documented in the data dictionary.

Reference no: EM132082651

Questions Cloud

Develop a web-server that allows the database : Develop a web-server that allows the database to be queried using any web-browser.

Design a user interface to review the case studies : New Century Wellness Group offers a holistic approach to healthcare with an emphasis on preventive medicine as well as traditional medical care.

Democratic decay and keep canada in study : If the researcher keeps states as the unit of analysis, how could she proceed to study democratic decay and keep Canada in her study?

What retirement plan are contributions to a simple ira made : His employer establishes a SIMPLE IRA for each employee's retirement. What retirement plan are contributions to a SIMPLE IRA made

Create an initial erd for the new system : New Century Wellness Group offers a holistic approach to healthcare with an emphasis on preventive medicine as well as traditional medical care.

Republican representative democracy form of government : The Constitution Article 4, Section 4 guarantees "to every state in the union" a republican representative democracy form of government.

Define an interest group : Define an interest group. Explain the ways that interest groups attract members. Why do interest groups have to incentivize membership in these ways?

How much of steve disability payments should be reported : Steve received $1,350 per month from disability (for 12 months). How much of Steve's disability payments should be reported as taxable income

The application of malware for cyber warfare : Is it acceptable to create malware to stop activities that threaten national security? Why?

User Account

All Pages