Data Analysis for Database Design, Third Edition (Paperback)

~ David Howe (Author) "A database is a collection of non-redundant data shareable between different application systems..." (more)
Key Phrases: conceptual schema record, posted identifier, level index block, Rows of Eats, Rows of Room, Department Employs Employee (more...)

Editorial Reviews

Review

"... It has the very specific aim of explaining techniques and concepts. It does so from a very practical standpoint by drawing on reasonably small-scale examples. To allow the reader to measure comprehension at each stage selected exercises are provided. The 'answer pointers' at the end of the chapter readily reveal any lack of comprehension... This book is strongly recommended to serious students... It is able to delve thoroughly into the area of data analysis and model design. " The Computer Journal. (Of the first edition).

"... It has the very specific aim of explaining techniques and concepts. It does so from a very practical standpoint by drawing on reasonably small-scale examples. To allow the reader to measure comprehension at each stage selected exercises are provided. The 'answer pointers' at the end of the chapter readily reveal any lack of comprehension... This book is strongly recommended to serious students..... It is able to delve thoroughly into the area of data analysis and model design. " The Computer Journal. (Of the first edition). -- Review

Review

"... It has the very specific aim of explaining techniques and concepts. It does so from a very practical standpoint by drawing on reasonably small-scale examples. To allow the reader to measure comprehension at each stage selected exercises are provided. The 'answer pointers' at the end of the chapter readily reveal any lack of comprehension... This book is strongly recommended to serious students..... It is able to delve thoroughly into the area of data analysis and model design. " The Computer Journal. (Of the first edition).

See all Editorial Reviews

Product Details

• Paperback: 336 pages
• Publisher: Butterworth-Heinemann; 3 edition (June 26, 2001)
• Language: English
• ISBN-10: 0750650869
• ISBN-13: 978-0750650861
• Product Dimensions: 9.4 x 6.7 x 0.7 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #1,159,171 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

4.0 out of 5 stars Easy to use, but be wary of MySQL, May 13, 2004

By	W Boudville (Terra, Sol 3) - See all my reviews (TOP 10 REVIEWER)    (REAL NAME)

A nice way to learn SQL99. The book is heavily into using examples to motivate this learning. The discussion is at the level of abstract database design, instantiated by examples. But, it also gets into the syntax of SQL.

The narrative is easy to understand; requiring nothing in prior knowledge of SQL. The book is all about designing relational tables to handle your data needs.

As an aside: If you are tempted to use the popular and free MySQL, in applying what you have learnt hear, please be aware that since MySQL doesn't allow foreign keys, a lot of the table designs may have to be totally redone.

0 of 1 people found the following review helpful:

4.0 out of 5 stars Foreign Keys ..., December 23, 2005

By	MrWhooHoo "WhooHoo" (Berkeley, CA United States) - See all my reviews

I read the 1st edition 20 years ago and it was a very thorough and rigorous text with excellent questions and exercises. The abstract theory is very clearly explained. Unfortunately, that edition did not cover Relational DB, so I can't comment on that treatment.

MySQL *does* support foreign keys. However, its SQL implementation does not support the *SQL FOREIGN KEY constraint* capability without some reconfiguration. This means that foreign key integrity generally has to be enforced outside of SQL. You can still use foreign keys.