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.
Assignment Deliverable
After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document.