ER modeling

Part II—Course Project

Course Project Part 3—E-R Modeling

Now that you have defined your E-R model and project description in the project you started and worked on in Weeks 1 and 2, start converting your logical E-R model to a physical model.

In this week, complete the following tasks:

In a Microsoft Excel spreadsheet, define columns with the following headings:
Primary Key
Name of Column
Null (NorY)
Datatype
Description
Foreign Key
Foreign Key Table
Each row will contain your rows for this table.
Fill out the columns row-wise.
Using Microsoft Visio or Microsoft Paint, create an E-R model of the six tables from your spreadsheet for developing the business requirements and constraints that will maintain the business logic for your database.
The E-R model should be readable and should map to the spreadsheet and the project description.
It should have all the cardinality and optionality defined.

Last Completed Projects