At a Glance; Contents; Foreword; About the Authors; About the Technical Reviewers; Acknowledgments; Introduction; Chapter 1: The Fundamentals; Taking a Brief Jaunt Through History; Introducing Codd's Rules for an RDBMS; Rule 1: The Information Principle; Rule 2: Guaranteed Access; Rule 3: Systematic Treatment of NULL Values; Rule 4: Dynamic Online Catalog Based on the Relational Model; Rule 5: Comprehensive Data Sublanguage Rule; Rule 6: View Updating Rule; Rule 7: High-Level Insert, Update, and Delete; Rule 8: Physical Data Independence; Rule 9: Logical Data Independence

Rule 10: Integrity IndependenceRule 11: Distribution Independence; Rule 12: Nonsubversion Rule; Nodding at SQL Standards; Recognizing Relational Data Structures; Introducing Databases and Schemas; Understanding Tables, Rows, and Columns; Working with Missing Values (NULLs); Defining Domains; Storing Metadata; Defining Uniqueness Constraints (Keys); Types of Keys; Choosing Keys; Natural Keys; Smart Keys; Surrogate Keys; Understanding Relationships; Working with Binary Relationships; One-to-Many Relationships; One-to-Many (The General Case); One-to-N Relationship; Many-to-Many Relationships

Working with Nonbinary RelationshipsUnderstanding Functional Dependencies; Understanding Functional Dependencies; Finding Determinants; Relational Programming; Outlining the Database-Specific Project Phases; Conceptual Phase; Logical Phase; Physical; Engine Adjustment Phase; Summary; Chapter 2: Introduction to Requirements; Documenting Requirements; Gathering Requirements; Interviewing Clients; Asking the Right Questions; What Data Is Needed?; How Will the Data Be Used?; What Rules Govern the Use of the Data?; What Data Is Reported On?; Where Is the Data Now?

Will the Data Need to Be Integrated with Other Systems?How Much Is This Data Worth?; Who Will Use the Data?; Are Existing Systems Being Replaced?; Utilizing Other Types of Documentation; Early Project Documentation; Contracts or Client Work Orders; Level of Service Agreement; Audit Plans; Prototypes; Following Best Practices; Summary; Chapter 3: The Language of Data Modeling; Introducing Data Modeling; Entities; Attributes; Primary Keys; Alternate Keys; Foreign Keys; Domains; Relationships; Identifying Relationships; Nonidentifying Relationships; Role Names; Relationship Cardinality

Recursive RelationshipsSubtypes; Many-to-Many Relationships; Verb Phrases (Relationship Names); Descriptive Information; Alternative Modeling Methodologies; Information Engineering; Chen ERD; Best Practices; Summary; Chapter 4: Conceptual and Logical Data Model Production; Example Scenario; Building the Conceptual Model; Identifying Entities; Persons; Places; Objects; Ideas; Documents; Groups; Other Entities; Audit Trails; Events; Records and Journals; Entity Recap; Identifying Relationships Between Entities; One-to-N Relationships; Simple Relationships; Connection; Transactions