Database systems /
Peter Ro and, Carlos Coronel.
- New Delhi : Cengage Learning , c2008.
- 594 p. ill. ; 24 cm.
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