Create an initial erd for the new system

Assignment Help Database Management System

Reference no: EM13761979

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 and the object models that you created.

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, or 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.

4. 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: EM13761979

Questions Cloud

Explain the reasons for probability and impact assessments : The rationale should explain the reasons for your probability and impact assessments and There should be one risk information sheet for each risk identified

Write an essay on big game hunting : Write an essay on Big Game Hunting. The body of this essay should be between 900 and 1000 words, excluding the required annotated bibliography.

Function count down : Function CountDown(count) { If (count

Energy related problems : Strategies are available to reduce global warming.

Create an initial erd for the new system : 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

Convert fahrenheit to celsius : a program that will convert Fahrenheit to Celsius. The user will enter the degrees in Fahrenheit and the program will give the results in Celsius. This is to be done in Pseudo Code Only. good programming techniques. Must also use modular programmi..

Explain strategic goals for ted business : List 3 strategic goals for Ted's business and provide an explanation of each. Identify 5 specific types or categories of information that Ted needs to run his business and explain why they are important to him

What does the twine that bud ties around his suitcase : What does the twine that bud ties around his suitcase?

Write an essay on sophocles oedipus rex and cherry orchard : Write an essay on the Sophocles Oedipus Rex 1957, The Cherry Orchard 1999, Death of a Salesman (1984) and Tartuffe 1983.

User Account

All Pages