Relational Database Design Clearly Explained - Softcover

Harrington, Jan L.

Softcover

ISBN 10: 0123264251 ISBN 13: 9780123264251

Publisher: Morgan Kaufmann, 1998

Synopsis

The majority of database systems being installed today are based on the relational database model. Unfortunately, relational database design is one of the most misunderstood aspects of computing. Part of the problem comes from popular literature that describes a relational database as anything that has "relationships between files." And those who do understand that a relational database is really nothing more than a collection of two-dimensional tables are caught between good design and the performance of the database. They are often unaware of the side-effects of many of their poor design decisions.

* Approaches relational database design with a balance of theory and practice; and the theory is targeted towards real-world practice
* Presents an entity-relationship approach and a relational theory approach; explains how they are related and how they cross check each other to validate the design
* Includes in-depth database design case studies

About this title

About the Author

Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture.

From the Back Cover

Relational Database Design Clearly Explained teaches database practitioners the principles of good relational database design. It discusses tradeoffs between theory and practice (i.e. when it's ok to violate a principle of good design in order to improve performance). The book 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.

Features:

• Approaches relational database design with a balance of theory and practice; and the theory is targeted towards real-world practice
  
• Presents an entity-relationship approach and a relational theory approach; explains how they are related and how they cross check each other to validate the design
  
• Includes in-depth database design case studies
  

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 1998
• Language: English
• ISBN 10: 0123264251
• ISBN 13: 9780123264251
• Binding: Paperback
• Edition number: 1
• Number of pages: 286