Database Systems An Application Oriented Approach, Compete Version

Why Rent from Knetbooks?

Because Knetbooks knows college students. Our rental program is designed to save you time and money. Whether you need a textbook for a semester, quarter or even a summer session, we have an option for you. Simply select a rental period, enter your information and your book will be on its way!

Philip Lewis is a professor in the Department of Computer Science at the State University of New York at Stony Brook.

Introduction

Overview of Databases and Transactions What Are Databases and Transactions? Features of Modern Database and Transaction Processing Systems Major Players in the Implementation and Support of Database and Transaction Processing Systems Decision Support SystemsOLAP and OLTP

The Big Picture Case Study: A Student Registration System Introduction to Relational Databases What Makes a Program a TransactionThe ACID Properties Bibliographic Notes Exercises

Conceptual Modeling of Databases with Entity-Relationship Diagrams and the Unified Modeling Language Conceptual Modeling with the E-R Approach Entities and Entity Types Relationships and Relationship Types Advanced Features in Conceptual Data Modeling From E-R Diagrams to Relational Database Schemas UML: A New Kid on the Block A Brokerage Firm Example Case Study: A Database Design for the Student Registration System Limitations of Data Modeling Methodologies Bibliographic Notes Exercises

An Overview of Query Optimization Query Processing Architecture Heuristic Optimization Based on Algebraic Equivalences Estimating the Cost of a Query Execution Plan Estimating the Size of the Output Choosing a Plan Bibliographic Notes Exercises