Beginning Database Design: From Novice to Professional

by Clare Churcher

The problem of how to design a database is commonly encountered by those not specifically trained and practiced in the art. This book, therefore, is written with the lay person in mind. In simple language, the author uses examples from her real-life experience to highlight the types of problems that can result from poor design, to motivate readers to do good design. She then goes on to provide a sound method that readers can follow in order to produce a good design. While focus is on implementing designs in relational databases, the author does not forget those readers who will choose to implement their database in a spreadsheet such as Microsoft Excel.

Genres: Technical, Technology, Computer Science, Programming, Computers

300 pages, Paperback

First published January 1, 2007

Reviews

[Jeremiah · Rating 4 out of 5]

As boring as this topic/book can be to get through at times, the content and delivery is well thought out and greatly helped me establish a stronger understanding of relational databases and SQL. This book has been very useful, not only in projects I am currently working on in my professional and personal lives, but for projects I plan to undertake in the future. I feel confident that this material will help me dissect future problems to establish a well-balanced data model as well as a thorough understanding of the problem and its nuances.

Before starting this book I had actually completed a portion of Mrs. Churcher's Beginning SQL Queries, which I will very likely go back and complete now. I highly recommend either book. The only reason I can't give 5 stars is that it is not completely enthralling. Additionally, the distinctions between the ways different relationships can be implemented in a relational data model were not at first clear; it took some re-reading and additional reflection for it to sink in.

[Mountqi · Rating 4 out of 5]

The book focuses on practical relational database design rather than theory. It starts from use case, progresses through data model and finally reaches data table design. The examples are vivid. As a programmer I strongly recommend it to both the junior and the experienced.

[Michael Bennett Cohn · Rating 4 out of 5]

This may be the most important (to me) technical book that I have ever read.

[Fausto Betances · Rating 4 out of 5]

Right on the spot. Good, consistent information. Slightly slow pace due to abundant examples.

[Jeff · Rating 4 out of 5]

Readable, practical and useful. Plenty of examples covering the thought process, trade-offs, and design considerations. Features some Access cruft, but most of the advice is timeless and holds up well.

[Dan Yarmak · Rating 4 out of 5]

Learned lots!

[Cory · Rating 5 out of 5]

I just measured my dead-tree tech shelf -it's ~5 linear feet of programming books, 700-page O'Reilly tomes on Python, Perl, LAMPP stacks. This slim volume is packed with more tech punch than half of them. Its platform-agnostic approach succinctly explains *how* to approach the primary problems you'll encounter when faced with a messy spreadsheet you need to transform into a clean, maintainable database. Personally, it's even better because I work on scientific databases, the author's forte; usually I have to wade through a swamp of business application stuff (not that this book *isn't* applicable to that). Excellent.

[Rodrigo d'Orey · Rating 5 out of 5]

Very good and easy going little book for such a tough subject.

[James · Rating 3 out of 5]

Good solid review of the basics, gave me what I needed.

[Josep]

Libro de Consulta en ingles, muy bien explicado y creo que se quedara muchisimo tiempo en mis estanterias

[Andrew Obrigewitsch · Rating 4 out of 5]

This is a great intro book on DataBase management, it really lays down a good foundation so that one can easily understand higher level concepts.

[Adam Hansen · Rating 5 out of 5]

This is a really great read for newcomers to database design, but also for experienced designers. The book covers all the really important areas and goes into great detail with some very useful examples. What is really great are the repeating examples from beginning to end, which just evolve with more technical perspectives!