Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Summary

We opened the chapter with a discussion of the preliminary table list. This list constitutes the initial table structures for the new database. You learned how to develop this list using the preliminary field list, the list of subjects, and the mission objectives, all of which you compiled during the analysis phase of the database-design process.

Next we discussed the procedure for transforming the preliminary table list into a final table list, which contains the name, type, and description of each table in the database. You learned a set of guidelines for creating table names, and another set of guidelines for composing table descriptions. We then worked on creating table names that are unambiguous, descriptive, and meaningful ...