| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Database Fundamentals | |
| |
| |
| Properties of a Database | |
| |
| |
| The Database Management System (DBMS) | |
| |
| |
| Layers of Data Abstraction | |
| |
| |
| Physical Data Independence | |
| |
| |
| Logical Data Independence | |
| |
| |
| Prevalent Database Models | |
| |
| |
| Flat Files | |
| |
| |
| The Hierarchical Model | |
| |
| |
| The Network Model | |
| |
| |
| The Relational Model | |
| |
| |
| The Object-Oriented Model | |
| |
| |
| The Object-Relational Model | |
| |
| |
| A Brief History of Databases | |
| |
| |
| Why Focus on Relational? | |
| |
| |
| Quiz | |
| |
| |
| Exploring Relational Database Components | |
| |
| |
| Conceptual Database Design Components | |
| |
| |
| Entities | |
| |
| |
| Attributes | |
| |
| |
| Relationships | |
| |
| |
| Business Rules | |
| |
| |
| Logical/Physical Database Design Components | |
| |
| |
| Tables | |
| |
| |
| Columns and Data Types | |
| |
| |
| Constraints | |
| |
| |
| Integrity Constraints | |
| |
| |
| Views | |
| |
| |
| Quiz | |
| |
| |
| Forms-Based Database Queries | |
| |
| |
| QBE: The Roots of Forms-Based Queries | |
| |
| |
| Getting Started in Microsoft Access | |
| |
| |
| The Microsoft Access Relationships Panel | |
| |
| |
| The Microsoft Access Table Design View | |
| |
| |
| Creating Queries in Microsoft Access | |
| |
| |
| List All Customers | |
| |
| |
| Choosing Columns to Display | |
| |
| |
| Sorting Results | |
| |
| |
| Advanced Sorting | |
| |
| |
| Choosing Rows to Display | |
| |
| |
| Compound Row Selection | |
| |
| |
| Using Not Equal | |
| |
| |
| Joining Tables | |
| |
| |
| Limiting Join Results | |
| |
| |
| Outer Joins | |
| |
| |
| Multiple Joins; Calculated Columns | |
| |
| |
| Aggregate Functions | |
| |
| |
| Self-Joins | |
| |
| |
| Quiz | |
| |
| |
| Introduction to SQL | |
| |
| |
| The History of SQL | |
| |
| |
| Getting Started with Oracle SQL | |
| |
| |
| Where's the Data? | |
| |
| |
| Finding Database Objects Using Catalog Views | |
| |
| |
| Viewing Database Objects Using Oracle Enterprise Manager | |
| |
| |
| Data Query Language (DQL): The SELECT Statement | |
| |
| |
| Listing All Employees | |
| |
| |
| Limiting Columns to Display | |
| |
| |
| Sorting Results | |
| |
| |
| Choosing Rows to Display | |
| |
| |
| Joining Tables | |
| |
| |
| Aggregate Functions | |
| |
| |
| Data Manipulation Language (DML) | |
| |
| |
| Transaction Support (COMMIT and ROLLBACK) | |
| |
| |
| The INSERT Statement | |
| |
| |
| The UPDATE Statement | |
| |
| |
| The DELETE Statement | |
| |
| |
| Data Definition Language (DDL) Statements | |
| |
| |
| The CREATE TABLE Statement | |
| |
| |
| The ALTER TABLE Statement | |
| |
| |
| The CREATE VIEW Statement | |
| |
| |
| The CREATE INDEX Statement | |
| |
| |
| The DROP Statement | |
| |
| |
| Data Control Language (DCL) Statements | |
| |
| |
| The GRANT Statement | |
| |
| |
| The REVOKE Statement | |
| |
| |
| Quiz | |
| |
| |
| The Database Life Cycle | |
| |
| |
| The Traditional Method | |
| |
| |
| Planning | |
| |
| |
| Requirements Gathering | |
| |
| |
| Conceptual Design | |
| |
| |
| Logical Design | |
| |
| |
| Physical Design | |
| |
| |
| Construction | |
| |
| |
| Implementation and Rollout | |
| |
| |
| Ongoing Support | |
| |
| |
| Nontraditional Methods | |
| |
| |
| Prototyping | |
| |
| |
| Rapid Application Development (RAD) | |
| |
| |
| Quiz | |
| |
| |
| Logical Database Design Using Normalization | |
| |
| |
| The Need for Normalization | |
| |
| |
| Insert Anomaly | |
| |
| |
| Delete Anomaly | |
| |
| |
| Update Anomaly | |
| |
| |
| Applying the Normalization Process | |
| |
| |
| Choosing a Primary Key | |
| |
| |
| First Normal Form: Eliminating Repeating Data | |
| |
| |
| Second Normal Form: Eliminating Partial Dependencies | |
| |
| |
| Third Normal Form: Eliminating Transitive Dependencies | |
| |
| |
| Beyond Third Normal Form | |
| |
| |
| Denormalization | |
| |
| |
| Practice Problems | |
| |
| |
| TLA University Academic Tracking | |
| |
| |
| Computer Books Company | |
| |
| |
| Quiz | |
| |
| |
| Data and Process Modeling | |
| |
| |
| Entity Relationship Modeling | |
| |
| |
| ERD Formats | |
| |
| |
| Super Types and Subtypes | |
| |
| |
| Guidelines for Drawing ERDs | |
| |
| |
| Process Models | |
| |
| |
| The Flowchart | |
| |
| |
| The Function Hierarchy Diagram | |
| |
| |
| The Swim Lane Diagram | |
| |
| |
| The Data Flow Diagram | |
| |
| |
| Relating Entities and Processes | |
| |
| |
| Quiz | |
| |
| |
| Physical Database Design | |
| |
| |
| Designing Tables | |
| |
| |
| Implementing Super Types and Subtypes | |
| |
| |
| Naming Conventions | |
| |
| |
| Integrating Business Rules and Data Integrity | |
| |
| |
| NOT NULL Constraints | |
| |
| |
| Primary Key Constraints | |
| |
| |
| Referential (Foreign Key) Constraints | |
| |
| |
| Unique Constraints | |
| |
| |
| Check Constraints | |
| |
| |
| Data Types, Precision, and Scale | |
| |
| |
| Triggers | |
| |
| |
| Designing Views | |
| |
| |
| Adding Indexes for Performance | |
| |
| |
| Quiz | |
| |
| |
| Connecting Databases to the Outside World | |
| |
| |
| Deployment Models | |
| |
| |
| Centralized Model | |
| |
| |
| Distributed Model | |
| |
| |
| Client/Server Model | |
| |
| |
| Connecting Databases to the Web | |
| |
| |
| Introduction to the Internet and the Web | |
| |
| |
| Components of the Web "Technology Stack" | |
| |
| |
| Invoking Transactions from Web Pages | |
| |
| |
| Connecting Databases to Applications | |
| |
| |
| Connecting Databases via ODBC | |
| |
| |
| Connecting Databases to Java Applications | |
| |
| |
| Quiz | |
| |
| |
| Database Security | |
| |
| |
| Why Is Security Necessary? | |
| |
| |
| Database Server Security | |
| |
| |
| Physical Security | |
| |
| |
| Network Security | |
| |
| |
| System-Level Security | |
| |
| |
| Database Client and Application Security | |
| |
| |
| Login Credentials | |
| |
| |
| Data Encryption | |
| |
| |
| Other Client Considerations | |
| |
| |
| Database Access Security | |
| |
| |
| Database Security Architectures | |
| |
| |
| Schema Owner Accounts | |
| |
| |
| System Privileges | |
| |
| |
| Object Privileges | |
| |
| |
| Roles | |
| |
| |
| Views | |
| |
| |
| Security Monitoring and Auditing | |
| |
| |
| Quiz | |
| |
| |
| Database Implementation | |
| |
| |
| Cursor Processing | |
| |
| |
| Transaction Management | |
| |
| |
| What Is a Transaction? | |
| |
| |
| DBMS Support for Transactions | |
| |
| |
| Locking and Transaction Deadlock | |
| |
| |
| Performance Tuning | |
| |
| |
| Tuning Database Queries | |
| |
| |
| Tuning DML Statements | |
| |
| |
| Change Control | |
| |
| |
| Quiz | |
| |
| |
| Databases for Online Analytical Processing | |
| |
| |
| Data Warehouses | |
| |
| |
| OLTP Systems Compared with Data Warehouse Systems | |
| |
| |
| Data Warehouse Architecture | |
| |
| |
| Data Marts | |
| |
| |
| Data Mining | |
| |
| |
| Quiz | |
| |
| |
| Final Exam | |
| |
| |
| Answers to Quizzes and Final Exam | |
| |
| |
| Chapter 1 | |
| |
| |
| Chapter 2 | |
| |
| |
| Chapter 3 | |
| |
| |
| Chapter 4 | |
| |
| |
| Chapter 5 | |
| |
| |
| Chapter 6 | |
| |
| |
| Chapter 7 | |
| |
| |
| Chapter 8 | |
| |
| |
| Chapter 9 | |
| |
| |
| Chapter 10 | |
| |
| |
| Chapter 11 | |
| |
| |
| Chapter 12 | |
| |
| |
| Index | |