Chapter 1 Introduction 1.1 Database-System Applications 1.2 Purpose of Database Systems 1.3 View of Data 1.3.1 Data Models 1.3.2 Relational Data Model 1.3.3 Data Abstraction 1.3.4 Instances and Schemas 1.4 Database Languages 1.4.1 Data-Definition Language 1.4.2 The SQL Data-Definition Language 1.4.3 Data-Manipulation Language 1.4.4 The SQL Data-Manipulation Language 1.4.5 Database Access from Application Programs 1.5 Database Design 1.6 Database Engine 1.6.1 Storage Manager 1.6.2 The Query Processor 1.6.3 Transaction Management 1.7 Database and Application Architecture 1.8 Database Users and Administrators 1.8.1 Database Users and User Interfaces 1.8.2 Database Administrator 1.9 History of Database Systems 1.10 Summary Review Terms Practice Exercises Exercises Tools Further Reading Bibliography PART 1 RELATIONAL LANGUAGES Chapter 2 Introduction to the Relational Model 2.1 Structure of Relational Databases 2.2 Database Schema 2.3 Keys 2.4 Schema Diagrams 2.5 Relational Query Languages 2.6 Summary Review Terms Practice Exercises Exercises Further Reading Bibliography Chapter 3 Introduction to SQL 3.1 Overview of the SQL Query Language 3.2 SQL Data Definition 3.2.1 Basic Types …… PART 2 DATABASE DESIGN AND APPLICATION DEVELOPMENT
PART 3 DATA MANAGEMENT IMPLEMANTATION PART 4 ADVANCED TOPICS Appendix A Detailed University Schema