Database Design for Mere Mortals

Appendix B. Sample Designs

The sample designs provided here are meant to serve as ideas for databases you may want or need to create. I emphasize the word "ideas" because five people can look at the same design and come up with five distinct variations based on their needs, backgrounds, and personal points of view.

I intentionally omitted all but the Primary and Foreign key fields from each table because I did not want to greatly influence you in any way as to how the tables should be populated. I also omitted a majority of the relationship characteristics for the same reason. Should you see a design that you might be able to use, run it through the entire database design process and treat it like an existing database. At the end of the process, ...