Database Design for Mere Mortals 25th Anniversary Edition, 4th edition Michael J Hernandez-Test Bank

Desk of contents

Foreword xix

Preface xxi

Introduction xxix

What’s New within the Fourth Edition xxxi

Who Ought to Learn This Ebook xxxii

The Function of This Ebook xxxiii

The best way to Learn This Ebook xxxvi

How This Ebook Is Organized xxxvii

A Phrase concerning the Examples and Strategies in This Ebook xl

PART I: RELATIONAL DATA BASE DESIGN 1
Chapter 1: The Relational Database 3

Matters Lined in This Chapter 3

What Is a Database? 3

The Relational Database 5

Retrieving Knowledge 7

Benefits of a Relational Database 9

Relational Database Administration Methods 10

What’s Subsequent? 11

Abstract 13

Assessment Questions 14

Chapter 2: Design Targets 17

Matters Lined in This Chapter 17

Why Ought to You Be Involved with Database Design? 17

The Significance of Concept 19

The Benefit of Studying a Good Design Methodology 21

Targets of Good Design 22

Advantages of Good Design 23

Database-Design Strategies 24

Conventional Design Strategies 24

The Design Methodology Introduced in This Ebook 26

Normalization 27

Abstract 30

Assessment Questions 31

Chapter 3: Terminology 33

Matters Lined in This Chapter 33

Why This Terminology Is Vital 33

Worth-Associated Phrases 35

Knowledge 35

Data 35

Null 37

The Worth of Null 38

The Downside with Null 39

Construction-Associated Phrases 41

Desk 41

Discipline 44

Document 45

View 46

Keys 48

Index 50

Relationship-Associated Phrases 50

Relationships 50

Sorts of Relationships 52

Sorts of Participation 57

Diploma of Participation 57

Integrity-Associated Phrases 59

Discipline Specification 59

Knowledge Integrity 59

Abstract 61

Assessment Questions 62

PART II: THE DESIGN PROCESS 65
Chapter 4: Conceptual Overview 67

Matters Lined in This Chapter 67

The Significance of Finishing the Design Course of 68

Defining a Mission Assertion and Mission Targets 69

Analyzing the Present Database 70

Creating the Knowledge Constructions 72

Figuring out and Establishing Desk Relationships 73

Figuring out and Defining Enterprise Guidelines 74

Figuring out and Defining Views 75

Reviewing Knowledge Integrity 75

Abstract 77

Assessment Questions 78

Chapter 5: Beginning the Course of 81

Matters Lined in This Chapter 81

Conducting Interviews 82

Participant Tips 84

Interviewer Tips (These Are for You) 86

Defining the Mission Assertion 91

The Properly-Written Mission Assertion 91

Composing a Mission Assertion 93

Defining the Mission Targets 96

Properly-Written Mission Targets 97

Composing Mission Targets 99

Abstract 103

Assessment Questions 104

Chapter 6: Analyzing the Present Database 107

Matters Lined in This Chapter 107

Attending to Know the Present Database 107

Paper-Based mostly Databases 111

Legacy Databases 111

Conducting the Evaluation 113

How Knowledge Is Collected 113

How Data Is Introduced 116

Conducting Interviews 120

Fundamental Interview Strategies 121

Earlier than You Start the Interview Course of 128

Interviewing Customers 128

Reviewing Knowledge Sort and Utilization 129

Reviewing the Samples 131

Reviewing Data Necessities 135

Interviewing Administration 143

Reviewing Present Data Necessities 144

Reviewing Extra Data Necessities 145

Reviewing Future Data Necessities 146

Reviewing Total Data Necessities 147

Compiling a Full Checklist of Fields 148

The Preliminary Discipline Checklist 148

The Calculated Discipline Checklist 156

Reviewing Each Lists with Customers and Administration 156

Abstract 162

Assessment Questions 164

Chapter 7: Establishing Desk Constructions 165

Matters Lined in This Chapter 165

Defining the Preliminary Desk Checklist 166

Figuring out Implied Topics 166

Utilizing the Checklist of Topics 168

Utilizing the Mission Targets 172

Defining the Last Desk Checklist 174

Refining the Desk Names 176

Indicating the Desk Sorts 182

Composing the Desk Descriptions 182

Associating Fields with Every Desk 189

Refining the Fields 191

Enhancing the Discipline Names 191

Utilizing an Very best Discipline to Resolve Anomalies 196

Resolving Multipart Fields 199

Resolving Multivalued Fields 201

Refining the Desk Constructions 208

A Phrase about Redundant Knowledge and Duplicate Fields 208

Utilizing an Very best Desk to Refine Desk Constructions 209

Establishing Subset Tables 216

Abstract 229

Assessment Questions 231

Chapter 8: Keys 233

Matters Lined in This Chapter 233

Why Keys Are Vital 234

Establishing Keys for Every Desk 234

Candidate Keys 235

Major Keys 243

Alternate Keys 249

Non-keys 250

Desk-Stage Integrity 251

Reviewing the Preliminary Desk Constructions 251

Abstract 259

Assessment Questions 260

Chapter 9: Discipline Specs 263

Matters Lined in This Chapter 263

Why Discipline Specs Are Vital 264

Discipline-Stage Integrity 266

Anatomy of a Discipline Specification 267

Basic Components 267

Bodily Components 275

Logical Components 278

Utilizing Distinctive, Generic, and Reproduction Discipline Specs 283

Defining Discipline Specs for Every Discipline within the Database 287

Abstract 291

Assessment Questions 292

Chapter 10: Desk Relationships 293

Matters Lined in This Chapter 293

Why Relationships Are Vital 294

Sorts of Relationships 295

One-to-One Relationships 296

One-to-Many Relationships 298

Many-to-Many Relationships 301

Self-Referencing Relationships 308

Figuring out Current Relationships 312

Establishing Every Relationship 323

One-to-One and One-to-Many Relationships 323

The Many-to-Many Relationship 331

Self-Referencing Relationships 337

Reviewing the Construction of Every Desk 342

Refining All International Keys 343

Components of a International Key 343

Establishing Relationship Traits 349

Defining a Deletion Rule for Every Relationship 349

Figuring out the Sort of Participation for Every Desk 354

Figuring out the Diploma of Participation for Every Desk 357

Verifying Desk Relationships with Customers and Administration 360

A Last Notice 360

Relationship-Stage Integrity 361

Abstract 366

Assessment Questions 368

Chapter 11: Enterprise Guidelines 369

Matters Lined in This Chapter 369

What Are Enterprise Guidelines? 370

Sorts of Enterprise Guidelines 373

Classes of Enterprise Guidelines 375

Discipline-Particular Enterprise Guidelines 375

Relationship-Particular Enterprise Guidelines 376

Defining and Establishing Enterprise Guidelines 378

Working with Customers and Administration 378

Defining and Establishing Discipline-Particular Enterprise Guidelines 379

Defining and Establishing Relationship-Particular Enterprise Guidelines 386

Validation Tables 394

What Are Validation Tables? 394

Utilizing Validation Tables to Help Enterprise Guidelines 395

Reviewing the Enterprise Rule Specs Sheets 400

Abstract 408

Assessment Questions 409

Chapter 12: Views 411

Matters Lined in This Chapter 411

What Are Views? 411

Anatomy of a View 413

Knowledge View 413

Combination View 418

Validation View 422

Figuring out and Defining Views 424

Working with Customers and Administration 425

Defining Views 426

Reviewing the Documentation for Every View 434

Abstract 441

Assessment Questions 442

Chapter 13: Reviewing Knowledge Integrity 445

Matters Lined in This Chapter 445

Why You Ought to Assessment Knowledge Integrity 446

Reviewing and Refining Knowledge Integrity 446

Desk-Stage Integrity 447

Discipline-Stage Integrity 447

Relationship-Stage Integrity 448

Enterprise Guidelines 448

Views 448

Assembling the Database Documentation 449

Carried out at Final! 451

Abstract 452

PART III: OTHER DATA BASE DESIGN ISSUES 453
Chapter 14: Unhealthy Design—What To not Do 455

Matters Lined in This Chapter 455

“Flat-File” Design 456

Spreadsheet Design 457

Coping with the Spreadsheet View Mindset 459

Database Design Based mostly on the Database Software program 461

A Last Thought 463

Abstract 463

Chapter 15: Bending or Breaking the Guidelines 465

Matters Lined in This Chapter 465

When Might You Bend or Break the Guidelines? 465

Designing an Analytical Database 465

Enhancing Processing Efficiency 466

Documenting Your Actions 469

Abstract 471

Chapter 16: In Closing 473

PART IV: APPENDIXES 475

Appendix A: Solutions to Assessment Questions 477
Appendix B: Diagram of the Database Design Course of 501
Appendix C: Design Tips 519
Appendix D: Documentation Varieties 529
Appendix E: Database-Design Diagram Symbols 533
Appendix F: Pattern Designs 535
Appendix G: On Normalization 541
Appendix H: Really helpful Studying 551
Glossary 553
References 567
Index 569

Present much less