|
 |
|
 |
 |
Relational Database Design Clearly Explained, Second Edition (The Morgan Kaufmann Series...
|
by Jan L. Harrington
Sales Rank: 432056
|
Discount: 36 %
List Price: $54.95
$37.37
At Amazon
|
|
Paperback: 416 pages
Publisher: Morgan Kaufmann; 2 edition April 16, 2002
Language: English
ISBN-10: 1558608206
ISBN-13: 978-1558608207
Product Dimensions:
9.2 x 7.2 x 1.1 inches
Shipping Weight: 1.8 pounds
Book Description
Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you'll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.
Supporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.
* Concepts you need to master to put the book's practical instruction to work.
* Methods for tailoring your design to the environment in which the database will run and the uses to which it will be put.
* Design approaches that ensure data accuracy and consistency.
* Examples of how design can inhibit or boost database application performance.
* Object-relational design techniques, benefits, and examples.
* Instructions on how to choose and use a normalization technique.
* Guidelines for understanding and applying Codd's rules.
* Tools to implement a relational design using SQL.
* Techniques for using CASE tools for database design.
Book Info
Teaches database practitioners the principles of good relational database design. Discusses tradeoffs between theory and practice. Shows readers how to construct the SQL statements needed to install well-designed relational databases and design. Previous edition c1998. Softcover.
Customer Reviews & Comments
This review is from: Relational Database Design Clearly Explained (Paperback)
I've been programming for quite a while, but up until a couple of years ago, I had never done anything with databases. When I switched jobs and needed to learn, I asked a few friends where to begin. At the time they recommended "SQL For Dummies" and "Oracle8: The Complete Reference" -- starting with the first and then diving in to the second. This didn't work so well for me. SQL For Dummies is actually a reasonable review of constructing basic SQL statements, but it didn't provide me with any conceptual framework for thinking about databases. The complete Oracle8 reference book certainly seemed to have a lot of material in it, but it was a bit too daunting (1300 pages) for a tutorial. I learned the basics that I needed to learn and have gradually assimilated things since then. Recently I came across this book at Amazon and found that it had pretty good customer reviews, so I thought I'd check it out. It is excellent. This is the book I wish I had had from day one. The book begins by reviewing basic concepts of databases and database design, plus by going over the various documents and diagrams that typically go along with databases. Then it briefly reviews the SQL one would use to create databases. And it ends with three detailed database design examples. These examples are pretty substantial -- in each case I read the description and thought "this is too complex a database to cover here" but the author broke the problem in comprehensible pieces, drew entity-relationship diagrams, and worked through the design. I highly recommend this book to people just starting out with databases. You will probably need to follow it with something that teaches you more SQL, but that should follow, not preceed, an introduction like this.
Comment | Permalink |
(Report this)
|
Relational Database Design Clearly Explained, Second Edition (The Morgan Kaufmann Series...
List Price: $54.95
Discount: 36 %
Available from Amazon
Price: $37.37
| |
|
|
|
|
