- Paperback: 300 pages
- Publisher: APress; 1st Corrected ed., Corr. 3rd printing edition (15 January 2007)
- Language: English
- ISBN-10: 1590597699
- ISBN-13: 978-1590597699
- Product Dimensions: 19.1 x 1.6 x 23.5 cm
- Average Customer Review: Be the first to review this item
Amazon Bestsellers Rank:
#9,14,284 in Books (See Top 100 in Books)
- #2194 in Books > Textbooks & Study Guides > Higher Education Textbooks > Computer Science > Database Storage & Design
- #3508 in Books > Textbooks & Study Guides > Higher Education Textbooks > Computer Science > Software Design & Engineering
- #3597 in Books > Computing, Internet & Digital Media > Programming & Software Development > Software Design, Testing & Engineering > Software Architecture
Beginning Database Design: From Novice to Professional Paperback – 15 Jan 2007
There is a newer edition of this item:
Customers who viewed this item also viewed
Customers who bought this item also bought
Description for Beginning Database Design: From Novice to Professional
About the Author
Clare Churcher is currently a senior lecturer in the Department of Applied Computing at Lincoln University, New Zealand. She holds a degree in physics with first class honors and completed a Ph.D in physics at the University of Canterbury, New Zealand. She has done postdoctoral research in the Cavendish Laboratory at the University of Cambridge, England. Clare s research interests are in the management and visualization of data especially for scientific research. She has a background in database design, and has taught programming, analysis and design of information systems, and database management at undergraduate level, as well as software engineering and scientific visualization at post graduate level.
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter mobile phone number.
|5 star (0%)|
|4 star (0%)|
|3 star (0%)|
|2 star (0%)|
|1 star (0%)|
Most helpful customer reviews on Amazon.com
What it is not: Don't expect to learn much about any specific Database software. It won't teach you much SQL, Microsoft Access, or any other Database software. (There are some section that bring up certain areas of these topics and basic Database Querying is discussed, but it's far from being in depth.)
The majority of the book explains how a database can be designed so that it match the needs of most clients, and how to anticipate the future needs of a client. It discussions the relationships between data and how to maintain those relationships. It highlights common mistakes in database design that can add unintended limitations and shows alternate ways of designing the same databases to allow the data freedom to grow.
I purchased this book for two reasons. One is that I'm a firm believer in learning and mastering fundamentals. In my case, I do a lot of computer programming. I've learned that the most important part of any software is it's data. Another reason is that I was assigned a project at work that involved updating a database to meet a new requirement. (I don't find the fundamentals as terribly interesting to study (like most people), but their value is priceless).
Each chapter includes review questions at the end to put into practice what you learned. There is not any solutions given to help you know if you answered the questions correctly, but it helps to you go back and review some of the topics for better learning.
I detracted one star for the sake of the Kindle version of the book not being correctly formatted. The Kindle version identifies the Topic Headers as "Chapters" rather than having the Chapters as "Chapters". Kindle readers estimate how much time till I've completed reading a chapter, but throughout the entire book, it was estimating how much time until the next section. Rather annoying. (Not sure if this is the fault of Amazon or Apress).
Despite that, I can give my recommendation of the content of this book on this topic. Mastering these fundamentals will truly make you a "Professional" database designer.
** WARNING ** BUY THE KINDLE VERSION!
Unfortunately, there's 1 major problem with this book: The publisher skimped on printing. The font is WAY too small (~8 point text), AND it's printed at a low-quality resolution using ink that is far too light (~80% grey ink, not solid black). The letters are too small and light to comfortably read without holding the book fairly close to your face, and the text looks like it was printed on a dot-matrix printer circa 1992. It's that bad. It really is a pity, because otherwise it's a great book. I was able to read it and learn a lot, but it was a big headache. If you have great eyes it might not bother you, but all buyers would be better off with the kindle version than this terrible print quality. I would give it 5 stars, but for that I ding it to 3 stars. It's a pity.
The author takes a step by step approach to understanding database design, starting out with a "BAD" model and showing how to improve it along the way. I have found by sampling other books that the biggest problems she avoids is becoming too application specific (she does some of it, but makes a real effort to only do so when necessary to illustrate), and using "standard" examples. She does use some standard examples, but also gets out of the "company X" box, and uses scientific experiments education-related and "sports club" examples as well. I would have liked her (or ANYONE) to address the hobbyist perspective (collectibles), but of the ones I've sampled, her book definitely used the broadest set of possible "use cases".
A first chapter, named "What Can Go Wrong", somewhat short, is all about the shortcomings that will ensue from a poorly modeled database.
A summary of the development process, from problem statement to design then to implementation follows. Requirements and use cases are addressed right after.
Data Modeling is addressed in the next 6 chapters, with the support of sound and sensibly chosen practical examples. Usual database design topics such as Relationship Cardinalities, Specialization, Generalization, Normalization, Constraints, etc. are well explained in a very practical way. There is not much theory in there.
The Queries chapter is MS Access-oriented and, as such, does not give much insight on SQL constructs, although some are provided as examples. If your project requires serious SQL querying, you'll definitely need additional SQL book(s).
This book is clearly aimed at beginners and mainly intended for small and "simple" database designs, standalone MS Access applications. If you are new to database design, this is a very good book to start with, but if your database project requires more complex design, you'll definitely need to get additional reading digging deeper into Data Modeling and SQL.
The book is accessible, easily understandable and well illustrated. I've noticed no typing errors.
To get the most out of this book, I would recommend putting it into application in a small standalone MS Access database design of your own, and then only moving on to further reading.