PREFACE
Part I FOUNDATIONS
1 OVERVIEW OF DATABASE SYSTEMS
1.1 Managing Data
1.2 A Historical Perspective
1.3 File Systems versus a DBMS
1.4 Advantages of a DBMS
1.5 Describing and Storing Data in a DBMS
1.6 Queries in a DBMS
1.7 Transaction Management
1.8 Structure of a DBMS
1.9 People Who Work with Databases
1.10 Review Questions
2 INTRODUCTION TO DATABASE DESIGN
2.1 Database Design and ER Diagrams
2.2 Entities,Attributes,and Entity Sets
2.3 Relationships and Relationship Sets
2.4 Additional Features of the ER Model
2.5 Conceptual Design With the ER Model
2.6 Conceptual Design for Large Enterprises
2.7 The Unified Modeling Language
2.8 Case Study:The Internet Shop
2.9 Review Questions
3 THE RELATIONAL MODEL
3.1 Introduction to the Relational Model
3.2 Integrity Constraints over Relations
3.3 Enforcing Integrity Constraints
3.4 Querying Relational Data
3.5 Logical Database Design:ER to Relational
3.6 Introduction to Views
3.7 Destroying/Altering Tables and Views
3.8 Case Study:The Internet Store
……
3.9