Summary

Teaches relational database design as a process to follow step by step, independent of any database product. Hernandez starts with terminology and design objectives, then works through the stages in order: writing a mission statement, interviewing users and management, analyzing the current database, establishing tables, keys and field specifications, defining table relationships, recording business rules, and designing views. Data integrity is reviewed at the field, table and relationship level along the way. Closing chapters show what bad design looks like and when bending the rules is justified. Normalization gets a short section early on and an appendix of its own. Every chapter ends with review questions, answered in an appendix.

Target Readers

• People who have never designed a database and need a method that runs from requirements to tables
• People running an existing database that needs improvement

Colophon

Publisher

Addison-Wesley Professional

ISBN

978-0-13-678804-1

Published

Dec 2020