you are welcome fsmith,
just keep in mind some basic rules always
- avoid duplicate information i.e information should not be repeated while designing your tables
- every table should have primary key (even its not necessary, but good for relationship)
- keep primary and foreign key concept in mind during normalization.
- data integration is important, no orphan record should exist in related table.
- cascade update in related tables are important, cascade update, update the related key value in the primary table.
- normalize your tables upto 2NF (second normal form)
- good database design structure enhance data retrieval and processing in queries and forms.