This third edition of Six-Step Relational Database Design™ bridges the gap between relational database theory and implementation. It offers a simple, structured, and reliable technique for designing relational databases that are easy to understand and suitable for implementation on any relational database management system (RDBMS). Beginning with a clear client problem statement, the process walks through six logical steps that lead to a complete and accurate Crow’s Foot Relational Model, ready for implementation.
 |
The third edition retains the proven six-step approach from the second edition but introduces a key enhancement: the inclusion of basic inline CRUD (Create, Read, Update, Delete) auditing. Readers learn how to embed auditing attributes such as CreatedBy, CreatedOn, LastUpdatedBy, LastUpdatedOn, IsDeleted, DeletedBy, and DeletedOn into key tables. This supports greater accountability, transparency, and compliance with industry standards, and equips developers to meet modern demands for traceable and secure data systems.
Topics covered include ACID compliance, normalization, cascade updates and deletes, indexes, and data types, each with a focus on key implementation considerations. Three real-world case studies are used throughout the book to demonstrate every step of the technique in practice. These examples guide readers in mastering the process of discovering entities, defining relationships, creating entity-relationship diagrams, and designing relational schemas. Exercises further encourage the use of AI-assisted design tools alongside the six-step method to validate, refine, and optimize database structures for correctness and completeness.
Explore the online courses for a comprehensive eLearning experience.
Browse the video lecture series that can be used by both lecturers and students as teaching and learning aids, respectively.
Examine the case studies used in the book that include the outputs of the six step database design process.
Purchase your copy
| Purchase the Book (Kindle Version available at Amazon) | |
|---|---|
| Amazon.com | Purchase on Amazon.com (paperback - US$34.99 and Kindle - US$9.99) |
| Amazon (Canada) | Purchase on Amazon.ca (paperback - CAN$48.52 and Kindle - CAN$9.99) |
| Amazon (UK) | Purchase on Amazon.co.uk (paperback - £25.95 and Kindle - £7.41) |
See Inside
Details and Specifications
| Book Details | |
|---|---|
| Binding | Paperback (Kindle version also available) |
| Page Count |
318 pages |
| Price | $34.99 (Paperback) and $9.99 (Kindle) |
| Black & White on White paper (9.25 x 7.5 x 0.72 inches) | |
| Publisher | Independently published |
| Language | English |
| ISBN-13 | 979-8289858009 |
Follow