book

Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition

by Michael J. Hernandez

February 2013

Intermediate to advanced

672 pages

12h 58m

English

Addison-Wesley Professional

Read now

Unlock full access

To the Third Edition
What’s New in the Third EditionWho Should Read This BookThe Purpose of This BookHow to Read This BookHow This Book Is OrganizedA Word About the Examples and Techniques in This Book

Topics Covered in This ChapterTypes of DatabasesEarly Database ModelsThe Relational Database ModelRelational Database Management SystemsBeyond the Relational ModelWhat the Future HoldsSummaryReview Questions
Topics Covered in This ChapterWhy Should You Be Concerned with Database Design?The Importance of TheoryThe Advantage of Learning a Good Design MethodologyObjectives of Good DesignBenefits of Good DesignDatabase Design MethodsNormalizationSummaryReview Questions
Topics Covered in This ChapterWhy This Terminology Is ImportantValue-Related TermsStructure-Related TermsRelationship-Related TermsIntegrity-Related TermsSummaryReview Questions
Topics Covered in This ChapterThe Importance of Completing the Design ProcessDefining a Mission Statement and Mission ObjectivesAnalyzing the Current DatabaseCreating the Data StructuresDetermining and Establishing Table RelationshipsDetermining and Defining Business RulesDetermining and Defining ViewsReviewing Data IntegritySummaryReview Questions
Topics Covered in This ChapterConducting InterviewsDefining the Mission StatementDefining the Mission ObjectivesSummaryReview Questions
Topics Covered in This ChapterGetting to Know the Current DatabaseConducting the AnalysisLooking at How Data Is CollectedLooking at How Information Is PresentedConducting InterviewsInterviewing UsersInterviewing ManagementCompiling a Complete List of FieldsSummaryReview Questions
Topics Covered in This ChapterDefining the Preliminary Table ListDefining the Final Table ListAssociating Fields with Each TableRefining the FieldsRefining the Table StructuresSummaryReview Questions
Topics Covered in This ChapterWhy Keys Are ImportantEstablishing Keys for Each TableTable-Level IntegrityReviewing the Initial Table StructuresSummaryReview Questions
Topics Covered in This ChapterWhy Field Specifications Are ImportantField-Level IntegrityAnatomy of a Field SpecificationUsing Unique, Generic, and Replica Field SpecificationsDefining Field Specifications for Each Field in the DatabaseSummaryReview Questions
Topics Covered in This ChapterWhy Relationships Are ImportantTypes of RelationshipsIdentifying Existing RelationshipsEstablishing Each RelationshipRefining All Foreign KeysEstablishing Relationship CharacteristicsRelationship-Level IntegritySummaryReview Questions
Topics Covered in This ChapterWhat Are Business Rules?Categories of Business RulesDefining and Establishing Business RulesValidation TablesReviewing the Business Rule Specifications SheetsSummaryReview Questions
Topics Covered in This ChapterWhat Are Views?Anatomy of a ViewDetermining and Defining ViewsSummaryReview Questions
Topics Covered in This ChapterWhy You Should Review Data IntegrityReviewing and Refining Data IntegrityAssembling the Database DocumentationDone at Last!Summary
Topics Covered in This ChapterFlat-File DesignSpreadsheet DesignDatabase Design Based on the Database SoftwareA Final ThoughtSummary
Topics Covered in This ChapterWhen May You Bend or Break the Rules?Documenting Your ActionsSummary
Chapter 1Chapter 2Chapter 3Chapter 4Chapter 5Chapter 6Chapter 7Chapter 8Chapter 9Chapter 10Chapter 11Chapter 12
Defining and Establishing Field-Specific Business RulesDefining and Establishing Relationship-Specific Business RulesElements of a Candidate KeyElements of a Foreign KeyElements of a Primary KeyElements of the Ideal FieldElements of the Ideal TableField-Level IntegrityGuidelines for Composing a Field DescriptionGuidelines for Composing a Table DescriptionGuidelines for Creating Field NamesGuidelines for Creating Table NamesIdentifying RelationshipsIdentifying View RequirementsInterview GuidelinesMission StatementsMission ObjectivesRelationship-Level IntegrityResolving a Multivalued FieldTable-Level Integrity
Please Note . . .A Brief RecapHow Normalization Is Integrated into My Design MethodologyLogical Design versus Physical Design and Implementation

Content preview from Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third Edition

13. Reviewing Data Integrity

When you have eliminated the impossible, whatever remains, however improbable, must be the truth.

—SHERLOCK HOLMES, THE SIGN OF FOUR

Topics Covered in This Chapter

Why You Should Review Data Integrity

Reviewing and Refining Data Integrity

Assembling the Database Documentation

Done at Last!

Case Study—Wrap-Up

Summary

You are now at the final stage of the database design process. You’ve accomplished many things since you started the process. Thus far you have

• Perceived the advantages of the relational database model and how it compares to other database models

• Created a mission statement for a new database

• Defined mission objectives for the new database

• Performed a complete analysis of an old database

• Identified ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Michael J. Hernandez

Database Design and Relational Theory: Normal Forms and All That Jazz

C. J. Date

Database Design for Mere Mortals: 25th Anniversary Edition, 4th Edition

Michael J. Hernandez

Relational Database Design and Implementation, 4th Edition

Jan L. Harrington

Publisher Resources

ISBN: 9780133122282Purchase book