30 Points, Due Tuesday, November 16
You will create an Access database in 2003 format that is normalized - i.e. it has at least one breakout table. You will create a table based on an entity of your choice.
- 3 Points - "Main" table based on an entity.
- 3 Points - Autonumber Primary Key has been created for the main table.
- 3 Points - At least 4 other attributes are represented (other than primary key) with appropriate data types.
- 3 Points - You have created a second table to hold the "broken out" (decomposed) value.
- 3 Points - You have forign key column in the main table, and have create a relationship with the database diagram tool that enforces referential integrity.
- 3 Points - You have a saved insert query for your main table.
- 3 Points - You have a saved update query for your main table.
- 3 Points - You have a saved delete query for your main table.
- 6 Points - You have a saved select query with an inner join and an order by clause for your main table.
Bring this database to class on 11/16.