Appendix F. Sample Designs

  Previous section   Next section

Appendix F. Sample Designs

I've provided these sample designs 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. Remember that there is no right or wrong way to design a given database, but you do have to ensure that the tables, fields, relationships, and views all conform to the guidelines you've learned from this book.

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, you should have a database that suits your needs.








Part II: The Design Process