Assignment

Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e., I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).

Deliverables for This Task

1. Task 0 proposal (with any revisions or updates)
2. A completed Data Model to include the following.

o An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. The ERD should be formatted to allow printing on a single 8x10 page. It should be submitted as a Word file (copy and paste from Visio).

o A Data Dictionary (or meta data chart) showing a minimum of the table name, columns, data types, length, and constraints. It should be submitted as an Excel file. Follow the format of the Data Dictionary supplied for Lab 3.