Database Systems: An Application-Oriented Approach, Introductory Version

by: Kifer, Michael; Bernstein, Arthur; Lewis, Philip M.

ISBN 13:
9780201708721
ISBN 10:
0201708728
Edition: 2nd
Format: Paperback
Copyright: 01/01/2005
Publisher: Addison Wesley
Newer Edition

Note: Not guaranteed to come with supplemental materials (access cards, study guides, lab manuals, CDs, etc.)

Extend Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Sorry, this item is currently unavailable.

Summary

(Pearson Education) Textbook taking an application-oriented approach to database and transaction processing, with a running case study throughout the text. Covers Triggers and Active Databases, OLAP and Data Mining, TP Monitors and how they implement the ACID properties, and security and Internet commerce. DLC: Database management.

Preface

xxiii

PART One Introduction

(52)

Overview of Databases and Transactions

(12)

What Are Databases and Transactions?

(2)

Features of Modern Database and Transaction Processing Systems

(4)

Major Players in the Implementation and Support of Database and Transaction Processing Systems

(1)

Decision Support Systems---OLAP and OLTP

(2)

Exercises

(3)

A Closer Look

(14)

Case Study: A Student Registration System

(1)

Introduction to Relational Databases

(6)

What Makes a Program a Transaction?

(5)

Bibliographic Notes

(1)

Exercises

(3)

Case Study: Starting the Student Registration System

(24)

Software Engineering Methodology

(2)

Requirements Document

(7)

Requirements Analysis---New Issues

(2)

Application Generators

(1)

GULs and Objects

(4)

Events and Procedures

(2)

Accessing Databases and Executing Transactions

(2)

Specifying the Student Registration System

(1)

Specification Document

(1)

Bibliographic Notes

(1)

Exercises

(3)

PART Two Database Management

(424)

The Relational Data Model

(34)

What Is a Data Model?

(3)

The Relational Model

(11)

Basic Concepts

(3)

Integrity Constraints

(7)

SQL---Data Definition Sublanguage

(18)

Specifying the Relation Type

(1)

The System Catalog

(1)

Key Constraints

(1)

Dealing with Missing Information

(1)

Semantic Constraints

(3)

User-Defined Domains

(1)

Foreign Key Constraints

(2)

Reactive Constraints

(3)

Database Views

(1)

Modifying Existing Definitions

(2)

SQL-Schemas

(1)

Access Control

(2)

Bibliographic Notes

(1)

Exercises

(2)

Database Design I: The Entity-Relationship Model

(34)

Conceptual Modeling with the E-R Approach

(1)

Entities and Entity Types

(4)

Relationships and Relationship Types

(5)

Advanced Features of the E-R Approach

(7)

Entity Type Hierarchies

(4)

Participation Constraints

103

(3)

A Brokerage Firm Example

106

(4)

Limitations of the E-R Approach

110

(4)

Case Study: A Design for the Student Registration System

114

(5)

Bibliographic Notes

119

(1)

Exercises

119

(4)

Query Languages I: Relational Algebra and SQL

123

(54)

Relational Algebra: Under the Hood of SQL

124

(16)

Basic Operators

124

(9)

Derived Operators

133

(7)

The Query Sublanguage of SQL

140

(27)

Simple SQL Queries

140

(6)

Set Operations

146

(3)

Nested Queries

149

(5)

Aggregation over Data

154

(5)

A Simple Query Evaluation Algorithm

159

(2)

Database Systems: An Application-Oriented Approach, Introductory Version

9780201708721

0201708728

Summary

Table of Contents

Write a Review

Database Systems: An Application-Oriented Approach, Introductory Version

9780201708721

0201708728

Summary

Table of Contents

Write a Review

Related Products