Database systems / Peter Ro and, Carlos Coronel.

Includes bibliographical references and index.

PARTI DATABASE CONCEPTS
CHAPTER I DATABASE SYSTEMS
1.1 Data vs. Information
i .2 Introducing the Database and the DBMS
1.3 Why Database Design Is Important
1.4 Historical Roots: Files and File Systems
1.5 Problems with File System Data Management
1.6 Database Systems
Review Questions
Problems
CHAPTER 2 DATA MODELS
2.1 Data Modeling and Data Models
2.2 The Importance of Data Models
2.3 Data Model Basic Building Blocks
2.4 Business Rules
2.5 The Evolution of Data Models
2.6 Degrees of Data Abstraction
Review Questions
Problems
PART II DESIGN CONCEPTS
CHAPTER 3 THE RELATIONAL DATABASE MODEL
3.1 A Logical View of Data
3.2 Keys
3.3 Integrity Rules
3.4 Relational Set Operators
3.5 The Data Dictionary and the System Catalog
3.6 Relationships within the Relational Database
3.7 Data Redundancy Revisited
3.8 Indexes
3.9 Codd's Relational Database Rules
Review Questions
Problems ' '
CHAPTER 4 ENTITY RELATIONSHIP (ER) MODELING
4.1 The Entity Relationship Model (ERM)
4.2 Developing an ER Diagram )
4.3 Database Design Challenges: Conflicting Goals
Review Questions " -C' i
Problems r . sfn! :i
CHAPTER 5 NORMALIZATION OF DATABASE TABLES
5.1 Database Tables and Normalization
5.2 The Need for Normalization
5.3 The Normalization Process
5.4 Improving the Design
5.5 Surrogate Key Considerations
5.6 Higher-Level Normal Forms
5.7 Normalization and Database Design
5.8 Denormalization




Review Questions '
Problems
CHAPTER 6 ADVANCED DATA MODELING The Extended Entity Relationship Model A
6.2 Entity Clustering
6.3 Entity Integrity: Selecting Primary Keys
6.4 Design Cases: Learning Flexible Database Design
6.5 Data Modeling Checklist
Review Questions
Problems
PART III ADVANCED DESIGN AND IMPLEMENTATION
CHAPTER 7 introduction TO STRUCTURED QUERY LANGUAGE (SQL)
7.1 Introduction to SQL
7.2 Data Definition Commands
7.3 Data Manipulation Commands


7.4 SELECT Queries
7.5 Advanced Data Definition Commands
7.6 Advanced SELECT Queries
7.7 Virtual Tables: Creating a View
7.8 Joining Database Tables '
Review Questions
Problems
CHAPTER 8 ADVANCED SQL
&;l Relational Set Operators ^ .
8.2 SQL Join Operators
8.3 Subqueries and Correlated Queries
8.4 SQL Functions
8.5 Oracle Sequences
8.6 Updatable Views
8.7 Procedural SQL
8.8 Embedded SQL
Review Questions
Problems ■
CHAPTER 9 DATABASE DESIGN
9.1 The Information System , . .
9.2 The Systems Development Life Cycle (SDLC)
9.3 The Database Life Cycle (DBLC)
9.4 Database Design Strategies
9.5 Centralized vs. Decentralized Design
Review Questions
Problems
PART IV ADVANCED DATABASE CONCEPTS
CHAPTER 10 TRANSACTION MANAGEMENT
AND CONCURRENCY CONTROL
10.1 What Is a Transaction?
10.2 Concurrency Control
10.3 Concurrency Control with Locking Methods
10.4 Concurrency Control with Time Stamping Methods
10.5 Concurrency Control with Optimistic Methods
10.6 Database Recovery Management -
Review Questions ^ by
Problems 11 - r o -. -A
CHAPTER II DATABASE PERFORMANCE TUNING AND .
.

QUERY OPTIMIZATION . ^Database Performance-Tuning Concepts ^
1.2 Query Processing
1.3 Indexes and Query Optimization
1.4 Optimizer Choices
1.5 SQL Performance Tuning
1.6 Query Formulation
1.7 DBMS Performance Tuning
1.8 Query Optimization Example p^- '.
Review Questions '
Problems T)
CHAPTER 12 DISTRIBUTED DATABASE MANAGEMENT SYSTEMS
12.1 The Evolution of Distributed Database Management Systems
12.2 DDBMS Advantages and Disadvantages
12.3 Distributed Processing and Distributed Databases
12.4 Characteristics of Distributed Database Management Systems
12.5 DDBMS Components '
12.6 Levels of Data and Process Distribution t .
12.7 Distributed Database Transparency Features
12.8 Distribution Transparency
12.9 Transaction Transparency
12.10 Performance Transparency and Query Optimization
12.1 I Distributed Database Design
12.12 Client/Server vs. DDBMS
12.13 C. J. Date's Twelve Commandments for Distributed Databases "
Review Questions
Problems
CHAPTER 13 BUSINESS INTELLIGENCE AND DATA WAREHOUSES
13.1 The Need for Data Analysis
13.2 Business Intelligence
13.3 Business Intelligence Architecture
13.4 Decision Support Data
13.5 The Data Warehouse
13.6 Online Analytical Processing
13.7 Star Schemas
13.8 Implementing a Data Warehouse
13.9 Data Mining
13.10 SQL Extensions For CLAP
Review Questions
Problems
PART V DATABASES AND THE INTERNET
CHAPTER 14 DATABASE CONNECTIVITY AND WEB TECHNOLOGIES
14.1 Database Connectivity
14.2 Internet Databases
14.3 Extensible Markup Language (XML)
Review Questions
Problems ,
FART VI DATAgASE ADMINISTRATION
CHAPTER 15 DATABASE ADMINISTRATION AND SECURITY
15.1 Data as a Corporate Asset
15.2 The Need for and Role of a Database in an Organization
15.3 Introduction of a Database: Special Considerations
15.4 The Evolution of the Database Administration Function
15.5 The Database Environment's Human Component
15.6 Security
15.7 Database Administration Ibols
15.8 Developing a Data Administration Strategy
15.9 The DBA at Work: Using Oracle for Database Administration
Review Questions
Index