Pre-Owned Relational Database Design Clearly Explained (Paperback) 1558608206 9781558608207

This revised textbook teaches database practitioners the principles of good relational database design, approaching the subject with a balance of theory and practice. It presents an entity-relationship approach and a relational theory approach, explaining how they are related and how they cross check each other to validate the design. The book looks at tradeoffs between theory and practice (that is, when it is acceptable to violate a principle of good design in order to improve performance). It also shows readers how to construct the SQL statements needed to install well-designed relational databases, and discusses other performance-related database design issues, such as indexes and clustering. This second edition includes a chapter on integrating object-relational and object-oriented database design, and adds object-relational design examples to all three in-depth case studies. Contributor: Jan L. Harrington