Data Analysis for Database Design, Third Edition [Paperback]

David Howe (Author)

Book Description

Publication Date: June 26, 2001 | ISBN-10: 0750650869 | ISBN-13: 978-0750650861 | Edition: 3

Data analysis for database design is a subject of great practical value to systems analysts and designers. This classic text has been updated to include chapters on distributed database systems, query optimisation and object-orientation.The SQL content now includes features of SQL92 and SQL 99.

With new databases coming online all the time and the general expansion of the information age, it is increasingly important to ensure that the analysis and model of a database design is accurate and robust. This is an ideal book for helping you to ensure that your database is well designed and therefore user friendly.



Increased material on SQL including the latest developments
Practical approach to explaining techniques and concepts
Contains many questions and answer pointers

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).

About the Author

Formerly Professor at the Department of Information Systems, De Montfort University, UK

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.5 x 6.6 x 0.8 inches
• Shipping Weight: 1.3 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #2,247,258 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

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
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: Data Analysis for Database Design, Third Edition (Paperback)

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

This review is from: Data Analysis for Database Design, Third Edition (Paperback)

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.