To create the ERD for the SIM system, the Entity - Relationship Diagram, which helps to describe the database for a computer system, go back to the information system DFD you created for Assignment 4 and just label the data flow arrows using the cardinality notation. That will show the relationship between the entities on your ERD. 2. To design sample data tables from the ERD you created in #1, you need to think of the objects that will be part each process. These objects will become the column headers for your table. So for example, the Customers table will have fields like name and address, and their household should have an ID #. Do this for all the objects in your ERD. Carlie asked that the database be a 3NF or Third Normal Form, all that means is that you will have a simple, one field, primary key for each of your data tables. No data repeats in any table and all of the fields in a table are dependent on its primary key. So you should create 6 data tables, one for each of the objects in your DFD and include a table for Appliances and one for Service Calls. Be sure to identify which field is the primary key for each table. 3. Finally, just invent some values for the variables in your table - create 3 full records for each data table. For example, make up 3 customer records. In her last email for this assignment, Carlie says you can use data from the AW data library - really the only files that are useful here is the AW Service Records Sample and the list of AW employees that I have attached.
1. To create the ERD for the SIM system, the Entity - Relationship Diagram, which helps to describe the
2. To design sample data tables from the ERD you created in #1, you need to think of the objects that will be part each process. These objects will become the column headers for your table. So for example, the Customers table will have fields like name and address, and their household should have an ID #. Do this for all the objects in your ERD. Carlie asked that the database be a 3NF or Third Normal Form, all that means is that you will have a simple, one field, primary key for each of your data tables. No data repeats in any table and all of the fields in a table are dependent on its primary key. So you should create 6 data tables, one for each of the objects in your DFD and include a table for Appliances and one for Service Calls. Be sure to identify which field is the primary key for each table.
3. Finally, just invent some values for the variables in your table - create 3 full records for each data table. For example, make up 3 customer records. In her last email for this assignment, Carlie says you can use data from the AW data library - really the only files that are useful here is the AW Service Records Sample and the list of AW employees that I have attached.
Step by step
Solved in 4 steps
