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

7. Establishing Table Structures

It is a capital mistake to theorize before one has data.

—SHERLOCK HOLMES, THE ADVENTURES OF SHERLOCK HOLMES

Topics Covered in This Chapter

Defining the Preliminary Table List

Defining the Final Table List

Associating Fields with Each Table

Refining the Fields

Refining the Table Structures

Case Study

Summary

Review Questions

Organizations use databases to keep track of various subjects that are important to them. For example, a medical clinic keeps track of, among other things, its patients, doctors, and appointments; an equipment rental business must maintain data on its customers, equipment, and rental agreements; and a registrar’s office is concerned (at the very least) with students, teaching staff, and courses. ...

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