Database Design for Mere Mortals®: A Hands-On Guide to by Michael J. Hernandez

By Michael J. Hernandez

“This publication takes the a little daunting strategy of database layout and breaks it into thoroughly viable and comprehensible elements. Mike’s technique when uncomplicated is totally expert, and that i can suggest this ebook to any amateur database designer.”
     –Sandra Barker, Lecturer, college of South Australia, Australia

“Databases are a serious infrastructure expertise for info structures and today’s company. Mike Hernandez has written a literate rationalization of database technology–a subject that's elaborate and sometimes imprecise. in case you layout databases your self, this publication will train you approximately pitfalls and express you what to do. if you are going to buy items that use a database, the ebook explains the expertise for you to comprehend what the seller is doing and verify their items better.”
     –Michael Blaha, advisor and coach, writer of A Manager’s advisor to Database know-how

“If you informed me that Mike Hernandez may possibly increase at the first version of Database layout for Mere Mortals I wouldn’t have believed you, yet he did! the second one variation is full of extra real-world examples, distinctive factors, or even contains database-design instruments at the CD-ROM! it is a must-read for a person who's even remotely drawn to relational database layout, from the person who's known as upon sometimes to create a useful gizmo at paintings, to the professional expert who desires to brush up at the basics. easily positioned, that will do it correct, learn this book!”
     –Matt Greer, procedure regulate improvement, The Dow Chemical Company

“Mike’s method of database layout is completely commonsense dependent, but he’s adhered to the entire principles of excellent relational database layout. i take advantage of Mike’s books in my starter database-design type, and that i suggest his books to somebody who’s drawn to studying the way to layout databases or tips to write SQL queries.”
     –Michelle Poolet, President, MVDS, Inc.

“Slapping jointly subtle purposes with poorly designed info will damage you simply as a lot now as whilst Mike wrote his first variation, even perhaps extra. even if you’re simply getting begun constructing with information or are a pro seasoned; no matter if you've learn Mike’s prior booklet or this is often your first; no matter if you're happier letting another person layout your facts otherwise you love doing it yourself–this is the publication for you. Mike’s skill to give an explanation for those options in a manner that’s not just transparent, yet enjoyable, maintains to amaze me.”
     –From the Foreword through Ken Getz, MCW applied sciences, coauthor ASP.NET Developer's JumpStart

“The first variation of Mike Hernandez’s e-book Database layout for Mere Mortals was once one of many few books that survived the minimize while I moved my workplace to smaller quarters. the second one variation expands and improves at the unique in such a lot of methods. it's not just a strong, transparent learn, yet incorporates a striking volume of transparent, concise considering on a truly advanced topic. It’s a needs to for a person attracted to the topic of database design.”
     –Malcolm C. Rubel, functionality Dynamics Associates

“Mike’s very good consultant to relational database layout merits a moment version. His e-book is a necessary instrument for fledgling Microsoft entry and different laptop database builders, in addition to for client/server professionals. i like to recommend it hugely to all my readers.”
     –Roger Jennings, writer of Special variation utilizing entry 2002

“There are not any silver bullets! Database expertise has complex dramatically, the latest crop of database servers practice operations swifter than somebody may have imagined six years in the past, yet none of those technological advances may also help repair a nasty database layout, or seize information that you simply forgot to incorporate! Database layout for Mere Mortals™, moment Edition, is helping you layout your database correct within the first place!”
     –Matt Nunn, Product supervisor, SQL Server, Microsoft Corporation

“When my brother begun his expert profession as a developer, I gave him Mike’s publication to aid him comprehend database suggestions and make real-world program of database know-how. while i would like a refresher at the finer issues of database layout, this can be the ebook I choose up. i don't imagine that there's a higher testimony to the worth of a e-book than that it will get used. accordingly i've got wholeheartedly urged to my friends and scholars that they make the most of this e-book of their day by day improvement tasks.”
     –Chris Kunicki, Senior advisor, OfficeZealot.com

“Mike has regularly had a major knack for taking the main advanced issues, breaking them down, and explaining them in order that somebody can ‘get it.’ He has honed and polished his first very, excellent version and made it even higher. If you're simply beginning out development database functions, this e-book is a must-read hide to hide. specialist designers will locate Mike’s technique clean and enlightening and a resource of significant fabric for education others.”
     –John Viescas, President, Viescas Consulting, Inc., writer of Running Microsoft entry 2000 and coauthor of SQL Queries for Mere Mortals

Sound database layout can keep hours of improvement time and make sure performance and reliability. Database layout for Mere Mortals™, moment Edition, is a simple, platform-independent educational at the easy ideas of relational database layout. It offers a common-sense layout technique for constructing databases that work.
Database layout professional Michael J. Hernandez has increased his best-selling first version, conserving its hands-on procedure and accessibility whereas updating its insurance and together with much more examples and illustrations.
This booklet provide you with the data and instruments you must create effective and powerful relational databases.

Show description

Read Online or Download Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design (2nd Edition) PDF

Best databases books

Oracle Workflow Guide

Welcome to the Oracle Workflow advisor. This consultant assumes you will have a operating wisdom of the following:• the rules and common practices of your online business region. • Oracle Workflow. when you've got by no means used Oracle Workflow, we propose you attend a number of of the Oracle Workflow education periods to be had via Oracle college.

Learn Filemaker Pro 9

Research FileMaker® seasoned nine presents a logical, hands-on method of realizing the gains of FileMaker seasoned, either for newbies and people who have adventure with earlier models of the software program. From defining database phrases and changing documents created in prior FileMaker professional types to generating stories and utilizing records on the internet, this ebook covers the basics in addition to the most recent gains that significantly increase FileMaker Pro’s database administration functions.

Additional resources for Database Design for Mere Mortals®: A Hands-On Guide to Relational Database Design (2nd Edition)

Example text

Another advantage is that referential integrity is built in and automatically enforced. This ensures that a record in a child table must be linked to an existing record in a parent table, and that a record deleted in the parent table will cause all associated records in the child table to be deleted as well. A problem occurs in a hierarchical database when a user needs to store a record in a child table that is currently unrelated to any record in a parent table. 1. A user cannot enter a new entertainer in the ENTERTAINERS table until the entertainer is assigned to an agent in the AGENTS table.

Chapter 14, Bad Design—What Not to Do, covers the types of designs you should avoid, such as a flat-file design and a spreadsheet design. Chapter 15, Bending or Breaking the Rules, discusses those rare instances in which it may be necessary to stray from the techniques and concepts of the design process. This chapter tells you when you should consider bending the rules, as well as how it should be done. Part IV: Appendixes Appendix A, Answers to Review Questions, contains the answers to all of the review questions in Chapters 1 through 12.

1. Diagram of a typical hierarchical database. 1, an agent books several entertainers, and each entertainer has his own schedule. An agent also maintains a number of clients whose entertainment needs are met by the agent. A client books engagements through the agent and makes payments to the agent for his services. A relationship in a hierarchical database is represented by the term parent/child. In this type of relationship, a parent table can be associated with one or more child tables, but a single child table can be associated with only one parent table.

Download PDF sample

Rated 4.10 of 5 – based on 48 votes