Database Design for Mere Mortals
25th Anniversary Edition
by Michael J. Hernandez
4th Edition
Publisher: Addison-Wesley Professional PTG
Book Details
| Print ISBN | 9780136788041 |
| eText ISBN | 9780136788171 |
| Publisher | Addison-Wesley Professional PTG |
| Publishing Year | 2021 |
| Edition | 4th Edition |
| Language | English |
| Pages | 640 |
In an era dominated by massive data streams, complex cloud architectures, and rapid digital transformation, establishing a rock-solid foundation in relational database design is more critical than ever before. Database Design for Mere Mortals 4th Edition stands as the definitive, software-independent guide that demystifies this complex field for beginners and seasoned professionals alike. By focusing on logical design principles rather than platform-specific syntax, this classic resource empowers readers to build systems that are highly reliable, scalable, and adaptable to future technological shifts. It provides a clear path forward for anyone tasked with organizing information, ensuring that your structural foundations remain secure regardless of the database management system you ultimately choose to deploy.
The author delivers a highly intuitive, step-by-step methodology that guides readers through the entire lifecycle of database creation. The text thoroughly explores how to establish robust table structures, define precise field specifications, assign primary keys, and configure complex table relationships. Rather than relying on dense mathematical proofs or intimidating academic jargon, the author uses clear, real-world examples to explain normalization, business rules, and views. This practical approach ensures that readers understand not only how to structure their data but also the underlying reasons why these design choices prevent common anomalies, duplicate fields, and devastating data redundancies.
This updated anniversary edition introduces modern enhancements, including remote interviewing techniques for capturing business requirements and updated review questions to reinforce key concepts. Ideal for self-directed learners, classroom students, and systems analysts, Database Design for Mere Mortals 4th Edition bridges the gap between theoretical database concepts and practical application. Utilizing the Database Design for Mere Mortals 4th Edition PDF as a digital study companion allows readers to easily search terms, highlight critical design sections, and master data integrity rules at their own pace. It remains the premier resource for creating databases that are robust, trustworthy, and ready for the future.
Table of Contents
Chapter 1: The Relational Database
- • What Is a Database?
- • The Relational Database
- • Retrieving Data
- • Advantages of a Relational Database
- • Relational Database Management Systems
Chapter 2: Design Objectives
- • Why Should You Be Concerned with Database Design?
- • The Importance of Theory
- • The Advantage of Learning a Good Design Methodology
- • Objectives of Good Design
- • Benefits of Good Design
- • Database-Design Methods
- • Normalization
Chapter 3: Terminology
- • Why This Terminology Is Important
- • Value-Related Terms
- • Structure-Related Terms
- • Relationship-Related Terms
- • Integrity-Related Terms
Chapter 4: Conceptual Overview
- • The Importance of Completing the Design Process
- • Defining a Mission Statement and Mission Objectives
- • Analyzing the Current Database
- • Creating the Data Structures
- • Determining and Establishing Table Relationships
- • Determining and Defining Business Rules
- • Determining and Defining Views
- • Reviewing Data Integrity
Chapter 5: Starting the Process
- • Conducting Interviews
- • Defining the Mission Statement
- • Defining the Mission Objectives
Chapter 6: Analyzing the Current Database
- • Getting to Know the Current Database
- • Conducting the Analysis
- • Looking at How Data Is Collected
- • Looking at How Information Is Presented
- • Conducting Interviews
- • Interviewing Users
- • Interviewing Management
- • Compiling a Complete List of Fields
Chapter 7: Establishing Table Structures
- • Defining the Preliminary Table List
- • Defining the Final Table List
- • Associating Fields with Each Table
- • Refining the Fields
- • Refining the Table Structures
Chapter 8: Keys
- • Why Keys Are Important
- • Establishing Keys for Each Table
- • Table-Level Integrity
- • Reviewing the Initial Table Structures
Chapter 9: Field Specifications
- • Why Field Specifications Are Important
- • Field-Level Integrity
- • Anatomy of a Field Specification
- • Using Unique, Generic, and Replica Field Specifications
- • Defining Field Specifications for Each Field in the Database
Chapter 10: Table Relationships
- • Why Relationships Are Important
- • Types of Relationships
- • Identifying Existing Relationships
- • Establishing Each Relationship
- • Refining All Foreign Keys
- • Establishing Relationship Characteristics
- • Relationship-Level Integrity
Chapter 11: Business Rules
- • What Are Business Rules?
- • Categories of Business Rules
- • Defining and Establishing Business Rules
- • Validation Tables
- • Reviewing the Business Rule Specifications Sheets
Chapter 12: Views
- • What Are Views?
- • Anatomy of a View
Chapter 13: Reviewing Data Integrity
- • Reviewing Table-Level Integrity
- • Reviewing Field-Level Integrity
- • Reviewing Relationship-Level Integrity
Chapter 14: Bad Design: What Not to Do
- • Analyzing Flat-File Designs
- • Recognizing Design Flaws
- • Correcting Bad Design Structures
Chapter 15: Bending or Breaking the Rules
- • When to Bend the Rules
- • Documenting Design Exceptions
Chapter 16: In Closing
- • Final Thoughts on Database Design
Customer Reviews
0.0
0 reviews
No reviews yet. Be the first to review this book!
Write a Review
Reviewed by GradeFocus
▶Research Sources (14)
- Database Design for Mere Mortals: 25th Anniversary Edition
- 3-2 Scenario Activity Database Design (docx) - CliffsNotes
- Database Design for Mere Mortals 25th Anniversary Edition
- Database Design for Mere Mortals: 25th Anniversary Edition
- Search result for "education" (40)
- Database Design for Mere Mortals - Fnac
- Database Design for Mere Mortals (4th ed.) - eBooks.com
- Database Design for Mere Mortals: 25th Anniversary Edition, 4th ...
- [PDF] Database Design for Mere Mortals - Pearsoncmg.com
- For Mere Mortals Series | InformIT
- Database Design for Mere Mortals, 4th Edition - GCTU Repository
- Database Design for Mere Mortals Reading : r/dataengineering
- [PDF] Database Design For Mere Mortals - ftp.arcchurches.com
- Database Design For Mere Mortals PDF - Scribd
