week2 individual

Using Microsoft Access, create and link the tables for the inventory model from your previous class.

What will be looked for in the assignment

* Referential integrity should be turned on for all parent to child relationships (no orphan records in database)

* I would prefer you set the default join type to an outer join (all parent records show even if there is not a corresponding child record)

* Make sure to include all tables from your ERD model (I have to see the entire database table structure)

* I will be looking at your table constraints, particularly at required fields (Null/Not Null), however, I except to see some other used

* I will be looking at your table and attribute naming convention (looking for consistancy as well as a good naming scheme)

* I will be looking at your primary keys

* I will be looking at your primary keys/foreign key relationships

* I will be reviewing the overall structure of your table and relationships

## Deliverables

A Microsoft Access (Office XP version) file(s) that follows the instructions above. The ERD model for this database is attached in the zip file

## Platform

I use Windows 2000 w/ Office XP.

Engineering Microsoft Access MySQL PHP Software Architecture Software Testing

Project ID: #3113521

About the project