Front cover -- Half title page -- Relational Database Design and Implementation -- Copyright page -- Table of Contents -- Preface to the Third Edition -- Changes in the Third Edition -- What You Need to Know -- Acknowledgments -- Part I Introduction -- Introduction -- Chapter 1 The Database Environment -- Defining a Database -- Lists and Files -- Databases -- Data "Ownership" -- Service-Oriented Architecture -- Database Software: DBMSs -- Database Hardware Architecture -- Centralized -- Client/Server -- Distributed -- The Web -- Remote Access -- Other Factors in the Database Environment -- Security -- Government Regulations and Privacy -- Legacy Databases -- For Further Reading -- Chapter 2 Systems Analysis and Database Requirements -- Dealing with Resistance to Change -- The Structured Design Life Cycle -- Conducting the Needs Assessment -- Assessing Feasibility -- Generating Alternatives -- Evaluating and Choosing an Alternative -- Creating Design Requirements -- Alternative Analysis Methods -- Prototyping -- Spiral Methodology -- Object-Oriented Analysis -- For Further Reading -- Part II Database Design Theory -- Database Design Theory -- Chapter 3 Why Good Design Matters -- Effects of Poor Database Design -- Unnecessary Duplicated Data and Data Consistency -- Data Insertion Problems -- Data Deletion Problems -- Meaningful Identifiers -- Chapter 4 Entities and Relationships -- Entities and Their Attributes -- Entity Identifiers -- Single-Valued versus Multivalued Attributes -- Avoiding Collections of Entities -- Documenting Entities and Their Attributes -- Entities and Attributes for Antique Opticals -- Domains -- Documenting Domains -- Practical Domain Choices -- Basic Data Relationships -- One-to-One Relationships -- One-to-Many Relationships -- Many-to-Many Relationships -- Weak Entities and Mandatory Relationships.

Documenting Relationships -- The Chen Method -- IE Style Diagrams -- UML Style Diagrams -- Basic Relationships for Antique Opticals -- Dealing with Many-to-Many Relationships -- Composite Entities -- Documenting Composite Entities -- Resolving Antique Opticals' Many-to-Many Relationships -- Relationships and Business Rules -- Data Modeling versus Data Flow -- Schemas -- For Further Reading -- Chapter 5 The Relational Data Model -- Understanding Relations -- Columns and Column Characteristics -- Rows and Row Characteristics -- Types of Tables -- A Notation for Relations -- Primary Keys -- Primary Keys to Identify People -- Avoiding Meaningful Identifiers -- Concatenated Primary Keys -- All-Key Relations -- Representing Data Relationships -- Referential Integrity -- Foreign Keys and Primary Keys in the Same Table -- Views -- The View Mechanism -- Why Use Views? -- The Data Dictionary -- Sample Data Dictionary Tables -- A Bit of History -- For Further Reading -- Chapter 6 Normalization -- Translating an ER Diagram into Relations -- Normal Forms -- First Normal Form -- Understanding Repeating Groups -- Handling Repeating Groups -- Problems with First Normal Form -- Second Normal Form -- Understanding Functional Dependencies -- Using Functional Dependencies to Reach 2NF -- Problems with 2NF Relations -- Third Normal Form -- Transitive Dependencies -- Boyce-Codd Normal Form -- Fourth Normal Form -- Multivalued Dependencies -- Fifth Normal Form -- Projections and Joins -- Projection -- Equi-Join -- Understanding 5NF -- Sixth Normal Form -- For Further Reading -- Chapter 7 Database Structure and Performance Tuning -- Joins and Database Performance -- Indexing -- Deciding Which Indexes to Create -- Clustering -- Partitioning -- Horizontal Partitioning -- Vertical Partitioning -- For Further Reading -- Chapter 8 Codd's Rules for Relational Database Design.

Rule 1: The Information Rule -- Rule 2: The Guaranteed Access Rule -- Rule 3: Systematic Treatment of Null Values -- Rule 4: Dynamic Online Catalog Based on the Relational Model -- Rule 5: The Comprehensive Data Sublanguage Rule -- Rule 6: The View Updating Rule -- Rule 7: High-Level Insert, Update, Delete -- Rule 8: Physical Data Independence -- Rule 9: Logical Data Independence -- Rule 10: Integrity Independence -- Rule 11: Distribution Independence -- Rule 12: Nonsubversion Rule -- Chapter 9 Using SQL to Implement a Relational Design -- Database Structure Hierarchy -- Naming and Identifying Structural Elements -- Schemas -- Creating a Schema -- Identifying the Schema You Want to Use -- Domains -- Tables -- Column Data Types -- Default Values -- NOT NULL CONSTRAINTS -- Primary Keys -- Foreign Keys -- Additional Column Constraints -- Requiring Unique Values -- Check Clauses -- Views -- Deciding Which Views to Create -- View Updatability Issues -- Creating Views -- Temporary Tables -- Creating Temporary Tables -- Loading Temporary Tables with Data -- Disposition of Temporary Table Rows -- Creating Indexes -- Modifying Database Elements -- Adding Columns -- Adding Table Constraints -- Modifying Columns -- Changing Column Definitions -- Changing Default Values -- Changing Null Status -- Changing Column Constraints -- Deleting Table Elements -- Renaming Table Elements -- Deleting Database Elements -- Chapter 10 Using CASE Tools for Database Design -- CASE Capabilities -- ER Diagram Reports -- Data Flow Diagrams -- The Data Dictionary -- Code Generation -- Sample Input and Output Designs -- The Drawing Environment -- For Further Reading -- Chapter 11 Database Design Case Study 1: Mighty-Mite Motors -- Corporate Overview -- Product Development Division -- Manufacturing Division -- Marketing and Sales Division -- Current Information Systems.

Reengineering Project -- New Information Systems Division -- Basic System Goals -- Current Business Processes -- Sales and Ordering Processes -- Manufacturing, Inventory, and Shipping Processes -- Product Testing and Support Function -- Designing the Database -- Examining the Data Flows -- The ER Diagram -- Creating the Tables -- Generating the SQL -- Chapter 12 Database Design Case Study 2: East Coast Aquarium -- Organizational Overview -- Animal Tracking Needs -- The Volunteer Organization -- The Volunteers Database -- Creating the Application Prototype -- Creating the ER Diagram -- Designing the Tables -- Generating the SQL -- The Animal Tracking Database -- Highlights of the Application Prototype -- Food Management -- Handling Arriving Animals -- Problem Analysis -- Creating the ER Diagram -- Creating the Tables -- Generating the SQL -- Part III Relational Design Practice -- Part III text -- Chapter 13 Database Design Case Study 3: SmartMart -- The Merchandising Environment -- Product Requirements -- In-Store Sales Requirements -- Web Sales Requirements -- Personnel Requirements -- Putting Together an ERD -- Stores, Products, and Employees -- Reference Entities -- Circular Relationships -- Mutually Exclusive Relationships -- One-to-One Relationships -- In-Store Sales -- Web Sales -- Creating the Tables -- Generating the SQL -- Part IV Database Implementation Issues -- Part IV text -- Chapter 14 Concurrency Control -- The Multiuser Environment -- Transactions -- Logging and Rollback -- Recovery -- Problems with Concurrent Use -- Lost Update #1 -- Lost Update #2 -- Inconsistent Analysis -- Dirty Reads -- Nonrepeatable Read -- Phantom Read -- Solution 1: Classic Locking -- Read or Exclusive Locks -- Operation of Write/Exclusive Locks -- Problem with Write/Exclusive Locks: Deadlock -- Read or Shared Locks -- Two-Phase Locking.

Locks and Transaction Length -- Solution 2: Optimistic Concurrency Control (Optimistic Locking) -- Solution #3: Multiversion Concurrency Control (Timestamping) -- Transaction Isolation Levels -- Web Database Concurrency Control Issues -- Distributed Database Issues -- For Further Reading -- Chapter 15 Database Security -- Sources of External Security Threats -- Physical Threats -- Hackers and Crackers -- Types of Attacks -- Sources of Internal Threats -- Employee Threats -- External Remedies -- Securing the Perimeter: Firewalls -- Handling Malware -- Buffer Overflows -- Physical Server Security -- User Authentication -- User IDs and Passwords (What the User Knows) -- Login Devices (What the User Has) -- Biometrics (What the User Is) -- VPNs -- Combating Social Engineering -- Handling Other Employee Threats -- Internal Solutions -- Internal Database User IDs and Passwords -- Authorization Matrices -- Types of Access Rights -- Using an Authorization Matrix -- Database Implementations -- Granting and Revoking Access Rights -- Granting Rights -- Revoking Rights -- Who Has Access to What -- Backup and Recovery -- Backup -- Disaster Recovery -- The Bottom Line: How Much Security Do You Need? -- For Further Reading -- Chapter 16 Data Warehousing -- Scope and Purpose of a Data Warehouse -- Obtaining and Preparing the Data -- Data Modeling for the Data Warehouse -- Dimensional Modeling Basics -- Dates and Data -- Data Warehouse Appliances -- For Further Reading -- Chapter 17 Data Quality -- Why Data Quality Matters -- Recognizing and Handling Incomplete Data -- Missing Rows -- Missing Column Data -- Missing Primary Key Data -- Recognizing and Handling Incorrect Data -- Wrong Codes -- Wrong Calculations -- Wrong Data Entered into the Database -- Violation of Business Rules -- Recognizing and Handling Incomprehensible Data -- Multiple Values in a Column.

Orphaned Foreign Keys.