Op werkdagen voor 23:00 besteld, morgen in huis Gratis verzending vanaf €20
010-4091943
Michael J Hernandez Meer over Michael J Hernandez

Database Design for Mere Mortals

25th Anniversary Edition
Specificaties
Paperback, blz. | Engels
Pearson Education | e druk, 2020
ISBN13: 9780136788041
Rubricering
Pearson Education e druk, 2020 9780136788041
Onderdeel van serie For Mere Mortals
Verwachte levertijd ongeveer 9 werkdagen
60,94
In winkelwagen
 

Samenvatting

Step by step, Database Design for Mere Mortals®, 25th Anniversary, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules. This edition has been updated to reflect the current landscape for databases and their prevalent uses in the world. 

 

Coverage includes

Understanding database types, models, and design terminology Discovering what good database design can do for you–and why bad design can make your life miserable Setting objectives for your database, and transforming those objectives into real designs Analyzing a current database so you can identify ways to improve it Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views Ensuring the appropriate level of data integrity for each application Identifying and establishing business rules

Specificaties

ISBN13:9780136788041
Taal:Engels
Bindwijze:Paperback
Uitgever:Pearson Education
Serie:For Mere Mortals

Inhoudsopgave

<div> Foreword&nbsp; &nbsp; &nbsp;xix </div> <div> <br> </div> <div> Preface&nbsp; &nbsp; &nbsp;xxi </div> <div> <br> </div> <div> Introduction xxix </div> <div> <br> </div> <div> What's New in the Fourth Edition&nbsp; &nbsp; &nbsp;xxxi </div> <div> <br> </div> <div> Who Should Read This Book&nbsp; &nbsp; &nbsp;xxxii </div> <div> <br> </div> <div> The Purpose of This Book&nbsp; &nbsp; &nbsp;xxxiii </div> <div> <br> </div> <div> How to Read This Book&nbsp; &nbsp; &nbsp;xxxvi </div> <div> <br> </div> <div> How This Book Is Organized&nbsp; &nbsp; &nbsp;xxxvii </div> <div> <br> </div> <div> A Word about the Examples and Techniques in This Book&nbsp; &nbsp; &nbsp;xl </div> <div> <br> </div> <div> PART I:&nbsp; RELATIONAL DATA BASE DESIGN&nbsp; &nbsp; &nbsp;1 </div> <div> <br> </div> <div> Chapter 1:&nbsp; The Relational Database&nbsp; &nbsp; &nbsp;3 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;3 </div> <div> <br> </div> <div> What Is a Database?&nbsp; &nbsp; &nbsp;3 </div> <div> <br> </div> <div> The Relational Database&nbsp; &nbsp; &nbsp;5 </div> <div> <br> </div> <div> &nbsp; &nbsp; Retrieving Data&nbsp; &nbsp; &nbsp;7 </div> <div> <br> </div> <div> &nbsp; &nbsp; Advantages of a Relational Database&nbsp; &nbsp; &nbsp;9 </div> <div> <br> </div> <div> &nbsp; &nbsp; Relational Database Management Systems&nbsp; &nbsp; &nbsp;10 </div> <div> <br> </div> <div> What's Next?&nbsp; &nbsp; &nbsp;11 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;13 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;14 </div> <div> <br> </div> <div> Chapter 2:&nbsp; Design Objectives&nbsp; &nbsp; &nbsp;17 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;17 </div> <div> <br> </div> <div> Why Should You Be Concerned with Database Design?&nbsp; &nbsp; &nbsp;17 </div> <div> <br> </div> <div> The Importance of Theory&nbsp; &nbsp; &nbsp;19 </div> <div> <br> </div> <div> The Advantage of Learning a Good Design Methodology&nbsp; &nbsp; &nbsp;21 </div> <div> <br> </div> <div> Objectives of Good Design&nbsp; &nbsp; &nbsp;22 </div> <div> <br> </div> <div> Benefits of Good Design&nbsp; &nbsp; &nbsp;23 </div> <div> <br> </div> <div> Database-Design Methods&nbsp; &nbsp; &nbsp;24 </div> <div> <br> </div> <div> &nbsp; &nbsp; Traditional Design Methods&nbsp; &nbsp; &nbsp;24 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Design Method Presented in This Book&nbsp; &nbsp; &nbsp;26 </div> <div> <br> </div> <div> Normalization&nbsp; &nbsp; &nbsp;27 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;30 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;31 </div> <div> <br> </div> <div> Chapter 3:&nbsp; Terminology&nbsp; &nbsp; &nbsp;33 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;33 </div> <div> <br> </div> <div> Why This Terminology Is Important&nbsp; &nbsp; &nbsp;33 </div> <div> <br> </div> <div> Value-Related Terms&nbsp; &nbsp; &nbsp;35 </div> <div> <br> </div> <div> &nbsp; &nbsp; Data&nbsp; &nbsp; &nbsp;35 </div> <div> <br> </div> <div> &nbsp; &nbsp; Information&nbsp; &nbsp; &nbsp;35 </div> <div> <br> </div> <div> &nbsp; &nbsp; Null&nbsp; &nbsp; &nbsp;37 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Value of Null&nbsp; &nbsp; &nbsp;38 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Problem with Null&nbsp; &nbsp; &nbsp;39 </div> <div> <br> </div> <div> Structure-Related Terms&nbsp; &nbsp; &nbsp;41 </div> <div> <br> </div> <div> &nbsp; &nbsp; Table&nbsp; &nbsp; &nbsp;41 </div> <div> <br> </div> <div> &nbsp; &nbsp; Field&nbsp; &nbsp; &nbsp;44 </div> <div> <br> </div> <div> &nbsp; &nbsp; Record&nbsp; &nbsp; &nbsp;45 </div> <div> <br> </div> <div> &nbsp; &nbsp; View&nbsp; &nbsp; &nbsp;46 </div> <div> <br> </div> <div> &nbsp; &nbsp; Keys&nbsp; &nbsp; &nbsp;48 </div> <div> <br> </div> <div> &nbsp; &nbsp; Index&nbsp; &nbsp; &nbsp;50 </div> <div> <br> </div> <div> Relationship-Related Terms&nbsp; &nbsp; &nbsp;50 </div> <div> <br> </div> <div> &nbsp; &nbsp; Relationships&nbsp; &nbsp; &nbsp;50 </div> <div> <br> </div> <div> &nbsp; &nbsp; Types of Relationships&nbsp; &nbsp; &nbsp;52 </div> <div> <br> </div> <div> &nbsp; &nbsp; Types of Participation&nbsp; &nbsp; &nbsp;57 </div> <div> <br> </div> <div> &nbsp; &nbsp; Degree of Participation&nbsp; &nbsp; &nbsp;57 </div> <div> <br> </div> <div> Integrity-Related Terms&nbsp; &nbsp; &nbsp;59 </div> <div> <br> </div> <div> &nbsp; &nbsp; Field Specification&nbsp; &nbsp; &nbsp;59 </div> <div> <br> </div> <div> &nbsp; &nbsp; Data Integrity&nbsp; &nbsp; &nbsp;59 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;61 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;62 </div> <div> <br> </div> <div> PART II:&nbsp; THE DESIGN PROCESS&nbsp; &nbsp; &nbsp;65 </div> <div> <br> </div> <div> Chapter 4:&nbsp; Conceptual Overview&nbsp; &nbsp; &nbsp;67 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;67 </div> <div> <br> </div> <div> The Importance of Completing the Design Process&nbsp; &nbsp; &nbsp;68 </div> <div> <br> </div> <div> Defining a Mission Statement and Mission Objectives&nbsp; &nbsp; &nbsp;69 </div> <div> <br> </div> <div> Analyzing the Current Database&nbsp; &nbsp; &nbsp;70 </div> <div> <br> </div> <div> Creating the Data Structures&nbsp; &nbsp; &nbsp;72 </div> <div> <br> </div> <div> Determining and Establishing Table Relationships&nbsp; &nbsp; &nbsp;73 </div> <div> <br> </div> <div> Determining and Defining Business Rules&nbsp; &nbsp; &nbsp;74 </div> <div> <br> </div> <div> Determining and Defining Views&nbsp; &nbsp; &nbsp;75 </div> <div> <br> </div> <div> Reviewing Data Integrity&nbsp; &nbsp; &nbsp;75 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;77 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;78 </div> <div> <br> </div> <div> Chapter 5:&nbsp; Starting the Process&nbsp; &nbsp; &nbsp;81 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;81 </div> <div> <br> </div> <div> Conducting Interviews&nbsp; &nbsp; &nbsp;82 </div> <div> <br> </div> <div> &nbsp; &nbsp; Participant Guidelines&nbsp; &nbsp; &nbsp;84 </div> <div> <br> </div> <div> &nbsp; &nbsp; Interviewer Guidelines (These Are for You)&nbsp; &nbsp; &nbsp;86 </div> <div> <br> </div> <div> Defining the Mission Statement&nbsp; &nbsp; &nbsp;91 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Well-Written Mission Statement&nbsp; &nbsp; &nbsp;91 </div> <div> <br> </div> <div> &nbsp; &nbsp; Composing a Mission Statement&nbsp; &nbsp; &nbsp;93 </div> <div> <br> </div> <div> Defining the Mission Objectives&nbsp; &nbsp; &nbsp;96 </div> <div> <br> </div> <div> &nbsp; &nbsp; Well-Written Mission Objectives&nbsp; &nbsp; &nbsp;97 </div> <div> <br> </div> <div> &nbsp; &nbsp; Composing Mission Objectives&nbsp; &nbsp; &nbsp;99 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;103 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;104 </div> <div> <br> </div> <div> Chapter 6:&nbsp; Analyzing the Current Database&nbsp; &nbsp; &nbsp;107 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;107 </div> <div> <br> </div> <div> Getting to Know the Current Database&nbsp; &nbsp; &nbsp;107 </div> <div> <br> </div> <div> &nbsp; &nbsp; Paper-Based Databases&nbsp; &nbsp; &nbsp;111 </div> <div> <br> </div> <div> &nbsp; &nbsp; Legacy Databases&nbsp; &nbsp; &nbsp;111 </div> <div> <br> </div> <div> Conducting the Analysis&nbsp; &nbsp; &nbsp;113 </div> <div> <br> </div> <div> Looking at How Data Is Collected&nbsp; &nbsp; &nbsp;113 </div> <div> <br> </div> <div> Looking at How Information Is Presented&nbsp; &nbsp; &nbsp;116 </div> <div> <br> </div> <div> Conducting Interviews&nbsp; &nbsp; &nbsp;120 </div> <div> <br> </div> <div> &nbsp; &nbsp; Basic Interview Techniques&nbsp; &nbsp; &nbsp;121 </div> <div> <br> </div> <div> &nbsp; &nbsp; Before You Begin the Interview Process&nbsp; &nbsp; &nbsp;128 </div> <div> <br> </div> <div> Interviewing Users&nbsp; &nbsp; &nbsp;128 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Data Type and Usage&nbsp; &nbsp; &nbsp;129 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing the Samples&nbsp; &nbsp; &nbsp;131 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Information Requirements&nbsp; &nbsp; &nbsp;135 </div> <div> <br> </div> <div> Interviewing Management&nbsp; &nbsp; &nbsp;143 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Current Information Requirements&nbsp; &nbsp; &nbsp;144 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Additional Information Requirements&nbsp; &nbsp; &nbsp;145 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Future Information Requirements&nbsp; &nbsp; &nbsp;146 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Overall Information Requirements&nbsp; &nbsp; &nbsp;147 </div> <div> <br> </div> <div> Compiling a Complete List of Fields&nbsp; &nbsp; &nbsp;148 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Preliminary Field List&nbsp; &nbsp; &nbsp;148 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Calculated Field List&nbsp; &nbsp; &nbsp;156 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing Both Lists with Users and Management&nbsp; &nbsp; &nbsp;156 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;162 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;164 </div> <div> <br> </div> <div> Chapter 7:&nbsp; Establishing Table Structures&nbsp; &nbsp; &nbsp;165 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;165 </div> <div> <br> </div> <div> Defining the Preliminary Table List&nbsp; &nbsp; &nbsp;166 </div> <div> <br> </div> <div> &nbsp; &nbsp; Identifying Implied Subjects&nbsp; &nbsp; &nbsp;166 </div> <div> <br> </div> <div> &nbsp; &nbsp; Using the List of Subjects&nbsp; &nbsp; &nbsp;168 </div> <div> <br> </div> <div> &nbsp; &nbsp; Using the Mission Objectives&nbsp; &nbsp; &nbsp;172 </div> <div> <br> </div> <div> Defining the Final Table List&nbsp; &nbsp; &nbsp;174 </div> <div> <br> </div> <div> &nbsp; &nbsp; Refining the Table Names&nbsp; &nbsp; &nbsp;176 </div> <div> <br> </div> <div> &nbsp; &nbsp; Indicating the Table Types&nbsp; &nbsp; &nbsp;182 </div> <div> <br> </div> <div> &nbsp; &nbsp; Composing the Table Descriptions&nbsp; &nbsp; &nbsp;182 </div> <div> <br> </div> <div> Associating Fields with Each Table&nbsp; &nbsp; &nbsp;189 </div> <div> <br> </div> <div> Refining the Fields&nbsp; &nbsp; &nbsp;191 </div> <div> <br> </div> <div> &nbsp; &nbsp; Improving the Field Names&nbsp; &nbsp; &nbsp;191 </div> <div> <br> </div> <div> &nbsp; &nbsp; Using an Ideal Field to Resolve Anomalies&nbsp; &nbsp; &nbsp;196 </div> <div> <br> </div> <div> &nbsp; &nbsp; Resolving Multipart Fields&nbsp; &nbsp; &nbsp;199 </div> <div> <br> </div> <div> &nbsp; &nbsp; Resolving Multivalued Fields&nbsp; &nbsp; &nbsp;201 </div> <div> <br> </div> <div> Refining the Table Structures&nbsp; &nbsp; &nbsp;208 </div> <div> <br> </div> <div> &nbsp; &nbsp; A Word about Redundant Data and Duplicate Fields&nbsp; &nbsp; &nbsp;208 </div> <div> <br> </div> <div> &nbsp; &nbsp; Using an Ideal Table to Refine Table Structures&nbsp; &nbsp; &nbsp;209 </div> <div> <br> </div> <div> &nbsp; &nbsp; Establishing Subset Tables&nbsp; &nbsp; &nbsp;216 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;229 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;231 </div> <div> <br> </div> <div> Chapter 8:&nbsp; Keys&nbsp; &nbsp; &nbsp;233 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;233 </div> <div> <br> </div> <div> Why Keys Are Important&nbsp; &nbsp; &nbsp;234 </div> <div> <br> </div> <div> Establishing Keys for Each Table&nbsp; &nbsp; &nbsp;234 </div> <div> <br> </div> <div> &nbsp; &nbsp; Candidate Keys&nbsp; &nbsp; &nbsp;235 </div> <div> <br> </div> <div> &nbsp; &nbsp; Primary Keys&nbsp; &nbsp; &nbsp;243 </div> <div> <br> </div> <div> &nbsp; &nbsp; Alternate Keys&nbsp; &nbsp; &nbsp;249 </div> <div> <br> </div> <div> &nbsp; &nbsp; Non-keys&nbsp; &nbsp; &nbsp;250 </div> <div> <br> </div> <div> Table-Level Integrity&nbsp; &nbsp; &nbsp;251 </div> <div> <br> </div> <div> Reviewing the Initial Table Structures&nbsp; &nbsp; &nbsp;251 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;259 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;260 </div> <div> <br> </div> <div> Chapter 9:&nbsp; Field Specifications&nbsp; &nbsp; &nbsp;263 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;263 </div> <div> <br> </div> <div> Why Field Specifications Are Important&nbsp; &nbsp; &nbsp;264 </div> <div> <br> </div> <div> Field-Level Integrity&nbsp; &nbsp; &nbsp;266 </div> <div> <br> </div> <div> Anatomy of a Field Specification&nbsp; &nbsp; &nbsp;267 </div> <div> <br> </div> <div> &nbsp; &nbsp; General Elements&nbsp; &nbsp; &nbsp;267 </div> <div> <br> </div> <div> &nbsp; &nbsp; Physical Elements&nbsp; &nbsp; &nbsp;275 </div> <div> <br> </div> <div> &nbsp; &nbsp; Logical Elements&nbsp; &nbsp; &nbsp;278 </div> <div> <br> </div> <div> Using Unique, Generic, and Replica Field Specifications&nbsp; &nbsp; &nbsp;283 </div> <div> <br> </div> <div> Defining Field Specifications for Each Field in the Database&nbsp; &nbsp; &nbsp;287 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;291 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;292 </div> <div> <br> </div> <div> Chapter 10:&nbsp; Table Relationships&nbsp; &nbsp; &nbsp;293 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;293 </div> <div> <br> </div> <div> Why Relationships Are Important&nbsp; &nbsp; &nbsp;294 </div> <div> <br> </div> <div> Types of Relationships&nbsp; &nbsp; &nbsp;295 </div> <div> <br> </div> <div> &nbsp; &nbsp; One-to-One Relationships&nbsp; &nbsp; &nbsp;296 </div> <div> <br> </div> <div> &nbsp; &nbsp; One-to-Many Relationships&nbsp; &nbsp; &nbsp;298 </div> <div> <br> </div> <div> &nbsp; &nbsp; Many-to-Many Relationships&nbsp; &nbsp; &nbsp;301 </div> <div> <br> </div> <div> &nbsp; &nbsp; Self-Referencing Relationships&nbsp; &nbsp; &nbsp;308 </div> <div> <br> </div> <div> Identifying Existing Relationships&nbsp; &nbsp; &nbsp;312 </div> <div> <br> </div> <div> Establishing Each Relationship&nbsp; &nbsp; &nbsp;323 </div> <div> <br> </div> <div> &nbsp; &nbsp; One-to-One and One-to-Many Relationships&nbsp; &nbsp; &nbsp;323 </div> <div> <br> </div> <div> &nbsp; &nbsp; The Many-to-Many Relationship&nbsp; &nbsp; &nbsp;331 </div> <div> <br> </div> <div> &nbsp; &nbsp; Self-Referencing Relationships&nbsp; &nbsp; &nbsp;337 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing the Structure of Each Table&nbsp; &nbsp; &nbsp;342 </div> <div> <br> </div> <div> Refining All Foreign Keys&nbsp; &nbsp; &nbsp;343 </div> <div> <br> </div> <div> &nbsp; &nbsp; Elements of a Foreign Key&nbsp; &nbsp; &nbsp;343 </div> <div> <br> </div> <div> Establishing Relationship Characteristics&nbsp; &nbsp; &nbsp;349 </div> <div> <br> </div> <div> &nbsp; &nbsp; Defining a Deletion Rule for Each Relationship&nbsp; &nbsp; &nbsp;349 </div> <div> <br> </div> <div> &nbsp; &nbsp; Identifying the Type of Participation for Each Table&nbsp; &nbsp; &nbsp;354 </div> <div> <br> </div> <div> &nbsp; &nbsp; Identifying the Degree of Participation for Each Table&nbsp; &nbsp; &nbsp;357 </div> <div> <br> </div> <div> &nbsp; &nbsp; Verifying Table Relationships with Users and Management&nbsp; &nbsp; &nbsp;360 </div> <div> <br> </div> <div> &nbsp; &nbsp; A Final Note&nbsp; &nbsp; &nbsp;360 </div> <div> <br> </div> <div> Relationship-Level Integrity&nbsp; &nbsp; &nbsp;361 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;366 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;368 </div> <div> <br> </div> <div> Chapter 11:&nbsp; Business Rules&nbsp; &nbsp; &nbsp;369 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;369 </div> <div> <br> </div> <div> What Are Business Rules?&nbsp; &nbsp; &nbsp;370 </div> <div> <br> </div> <div> &nbsp; &nbsp; Types of Business Rules&nbsp; &nbsp; &nbsp;373 </div> <div> <br> </div> <div> Categories of Business Rules&nbsp; &nbsp; &nbsp;375 </div> <div> <br> </div> <div> &nbsp; &nbsp; Field-Specific Business Rules&nbsp; &nbsp; &nbsp;375 </div> <div> <br> </div> <div> &nbsp; &nbsp; Relationship-Specific Business Rules&nbsp; &nbsp; &nbsp;376 </div> <div> <br> </div> <div> Defining and Establishing Business Rules&nbsp; &nbsp; &nbsp;378 </div> <div> <br> </div> <div> &nbsp; &nbsp; Working with Users and Management&nbsp; &nbsp; &nbsp;378 </div> <div> <br> </div> <div> &nbsp; &nbsp; Defining and Establishing Field-Specific Business Rules&nbsp; &nbsp; &nbsp;379 </div> <div> <br> </div> <div> &nbsp; &nbsp; Defining and Establishing Relationship-Specific Business Rules&nbsp; &nbsp; &nbsp;386 </div> <div> <br> </div> <div> Validation Tables&nbsp; &nbsp; &nbsp;394 </div> <div> <br> </div> <div> &nbsp; &nbsp; What Are Validation Tables?&nbsp; &nbsp; &nbsp;394 </div> <div> <br> </div> <div> &nbsp; &nbsp; Using Validation Tables to Support Business Rules&nbsp; &nbsp; &nbsp;395 </div> <div> <br> </div> <div> Reviewing the Business Rule Specifications Sheets&nbsp; &nbsp; &nbsp;400 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;408 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;409 </div> <div> <br> </div> <div> Chapter 12:&nbsp; Views&nbsp; &nbsp; &nbsp;411 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;411 </div> <div> <br> </div> <div> What Are Views?&nbsp; &nbsp; &nbsp;411 </div> <div> <br> </div> <div> Anatomy of a View&nbsp; &nbsp; &nbsp;413 </div> <div> <br> </div> <div> &nbsp; &nbsp; Data View&nbsp; &nbsp; &nbsp;413 </div> <div> <br> </div> <div> &nbsp; &nbsp; Aggregate View&nbsp; &nbsp; &nbsp;418 </div> <div> <br> </div> <div> &nbsp; &nbsp; Validation View&nbsp; &nbsp; &nbsp;422 </div> <div> <br> </div> <div> Determining and Defining Views&nbsp; &nbsp; &nbsp;424 </div> <div> <br> </div> <div> &nbsp; &nbsp; Working with Users and Management&nbsp; &nbsp; &nbsp;425 </div> <div> <br> </div> <div> &nbsp; &nbsp; Defining Views&nbsp; &nbsp; &nbsp;426 </div> <div> <br> </div> <div> &nbsp; &nbsp; Reviewing the Documentation for Each View&nbsp; &nbsp; &nbsp;434 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;441 </div> <div> <br> </div> <div> Review Questions&nbsp; &nbsp; &nbsp;442 </div> <div> <br> </div> <div> Chapter 13:&nbsp; Reviewing Data Integrity&nbsp; &nbsp; &nbsp;445 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;445 </div> <div> <br> </div> <div> Why You Should Review Data Integrity&nbsp; &nbsp; &nbsp;446 </div> <div> <br> </div> <div> Reviewing and Refining Data Integrity&nbsp; &nbsp; &nbsp;446 </div> <div> <br> </div> <div> &nbsp; &nbsp; Table-Level Integrity&nbsp; &nbsp; &nbsp;447 </div> <div> <br> </div> <div> &nbsp; &nbsp; Field-Level Integrity&nbsp; &nbsp; &nbsp;447 </div> <div> <br> </div> <div> &nbsp; &nbsp; Relationship-Level Integrity&nbsp; &nbsp; &nbsp;448 </div> <div> <br> </div> <div> &nbsp; &nbsp; Business Rules&nbsp; &nbsp; &nbsp;448 </div> <div> <br> </div> <div> &nbsp; &nbsp; Views&nbsp; &nbsp; &nbsp;448 </div> <div> <br> </div> <div> Assembling the Database Documentation&nbsp; &nbsp; &nbsp;449 </div> <div> <br> </div> <div> Done at Last!&nbsp; &nbsp; &nbsp;451 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;452 </div> <div> <br> </div> <div> PART III:&nbsp; OTHER DATA BASE DESIGN ISSUES&nbsp; &nbsp; &nbsp;453 </div> <div> <br> </div> <div> Chapter 14:&nbsp; Bad Design—What Not to Do&nbsp; &nbsp; &nbsp;455 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;455 </div> <div> <br> </div> <div> “Flat-File” Design&nbsp; &nbsp; &nbsp;456 </div> <div> <br> </div> <div> Spreadsheet Design&nbsp; &nbsp; &nbsp;457 </div> <div> <br> </div> <div> &nbsp; &nbsp; Dealing with the Spreadsheet View Mindset&nbsp; &nbsp; &nbsp;459 </div> <div> <br> </div> <div> Database Design Based on the Database Software&nbsp; &nbsp; &nbsp;461 </div> <div> <br> </div> <div> A Final Thought&nbsp; &nbsp; &nbsp;463 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;463 </div> <div> <br> </div> <div> Chapter 15:&nbsp; Bending or Breaking the Rules&nbsp; &nbsp; &nbsp;465 </div> <div> <br> </div> <div> Topics Covered in This Chapter&nbsp; &nbsp; &nbsp;465 </div> <div> <br> </div> <div> When May You Bend or Break the Rules?&nbsp; &nbsp; &nbsp;465 </div> <div> <br> </div> <div> &nbsp; &nbsp; Designing an Analytical Database&nbsp; &nbsp; &nbsp;465 </div> <div> <br> </div> <div> &nbsp; &nbsp; Improving Processing Performance&nbsp; &nbsp; &nbsp;466 </div> <div> <br> </div> <div> Documenting Your Actions&nbsp; &nbsp; &nbsp;469 </div> <div> <br> </div> <div> Summary&nbsp; &nbsp; &nbsp;471 </div> <div> <br> </div> <div> Chapter 16:&nbsp; In Closing&nbsp; &nbsp; &nbsp;473 </div> <div> <br> </div> <div> <br> </div> <div> PART IV:&nbsp; APPENDIXES&nbsp; &nbsp; &nbsp;475 </div> <div> <br> </div> <div> Appendix A:&nbsp; Answers to Review Questions&nbsp; &nbsp; &nbsp;477 </div> <div> <br> </div> <div> Appendix B:&nbsp; Diagram of the Database Design Process&nbsp; &nbsp; &nbsp;501 </div> <div> <br> </div> <div> Appendix C:&nbsp; Design Guidelines&nbsp; &nbsp; &nbsp;519 </div> <div> <br> </div> <div> Appendix D:&nbsp; Documentation Forms&nbsp; &nbsp; &nbsp;529 </div> <div> <br> </div> <div> Appendix E:&nbsp; Database-Design Diagram Symbols&nbsp; &nbsp; &nbsp;533 </div> <div> <br> </div> <div> Appendix F:&nbsp; Sample Designs&nbsp; &nbsp; &nbsp;535 </div> <div> <br> </div> <div> Appendix G:&nbsp; On Normalization&nbsp; &nbsp; &nbsp;541 </div> <div> <br> </div> <div> Appendix H:&nbsp; Recommended Reading&nbsp; &nbsp; &nbsp;551 </div> <div> <br> </div> <div> Glossary&nbsp; &nbsp; &nbsp;553 </div> <div> <br> </div> <div> References&nbsp; &nbsp; &nbsp;567 </div> <div> <br> </div> <div> Index&nbsp; &nbsp; &nbsp;569 </div> <div> <br> </div>

Rubrieken

Uw cookie-instellingen
Deze website maakt gebruik van verschillende soorten cookies. Sommige cookies worden geplaatst door diensten van derden die op onze pagina's worden weergegeven. Om deze externe content te kunnen tonen is nodig dat u toestemming geeft voor het zetten van persoonlijke en marketingcookies. U kunt uw toestemming op elk moment wijzigen of intrekken. In onze cookieverklaring vindt u meer informatie.

Populaire producten

    Personen

      Trefwoorden

        Database Design for Mere Mortals

        Recensiebeleid
        Noordhoff terugkoopgarantie

        Noordhoff koopt jouw boek terug, zonder zorgen!

        Heb je jouw boeken niet meer nodig?

        Als je jouw studieboeken gekocht hebt bij hanzestudybook.nl, kun je geselecteerde titels moeiteloos terugverkopen aan Noordhoff. Geen vragen, geen gedoe en lekker duurzaam.

        Volledige informatie op Noordhoff.nl

        AI-book

        Wat is een AI-book?

        Een AI-book is niet een boek dat geschreven is door AI maar een boek dat verrijkt is met AI. Het maakt de inhoud van een boek interactief via WhatsApp, zodat je ermee kunt chatten. Zie het als een razend slimme assistent die het boek perfect begrijpt en er alles uit onthouden heeft. Jij kunt deze assistent alles vragen. Vraag bijvoorbeeld hoe je iets kunt toepassen op jouw persoonlijke situatie, om een korte samenvatting, of wat de belangrijkste inzichten zijn. AI-books zijn alleen te gebruiken via WhatsApp, je hoeft er geen aparte app voor te installeren.
        Meer informatie over AI-books

        ?

        Geef uw beoordeling

        Database Design for Mere Mortals

        Verwijder uw beoordeling