The minimum elements it should contain follow:
- Create at least 3 tables, 2 master (primary) tables and a detail (related) table
o Consider using a concatenated key for the primary key in the detail table
- Impose appropriate field types and lengths on all fields
- Ensure the database is in 2NF (second normal form)
- Insert the 3 data integrity (data validation) checks / controls listed below:
o Require that a field that is not a primary key be populated (Access automatically requires primary keys be populated.)
o Impose limits on the value that can be entered into a number or currency field
o Establish a list of valid values that can be used in a field
- Force referential integrity between your tables
- Add 1 index on a field other than a primary key (Again, Access automatically indexes primary keys.)
- Create 2 queries that include this functionality, work and make sense:
o Data from multiple tables
o An aggregate total in the datasheet view
o A sort
o Complex selection criteria (uses And or Or logic)
- Create 1 report
- Create 1 form with a subform
In addition to uploading the database, you should upload a Word file where you:
1. Describe your database and what is being tracked in it.
2. Note which are master and which are detail tables.
3. 4. Note the field you indexed and describe the reason for indexing the field you chose.
6. List the fields that are primary and foreign keys in each table.
7. Explain the type of relationship (one-to-one, one-to-many, many-to-many) that exists between your tables.
It should go without saying, but this database needs to be original - one you created on your own, for this class, at this time, and for this assignment. You cannot use the database model created during the Database Down & Dirty day. Submitting a database created by someone else, or for another class, will not be accepted.