Summary

This discussion began with a brief summary of the rules for designing a database in Third Normal Form. It is a great way to design the Tables.

 

We created two Tables that have both Primary and Foreign Keys.

 

Once the Tables are in Third Normal Form, the Queries, Forms and Reports should work, too.