Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition

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 ...