Database Systems An Application-Oriented Approach, Introductory Version

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

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780321228383 | 0321228383
Cover: Paperback
Copyright: 3/30/2004

Rent

(Recommended)

$59.36

Term

Due

Price

Short Term

Jan 13

$56.23

Semester

Jan 4

$62.48

Quarter

Dec 18

$59.36

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping bag.
Buy Used

In Stock Usually Ships Within 24-48 hours.

$13.59
Buy New

In Stock Usually Ships in 24 Hours.

$54.88

This book presents the conceptual principles underlying the design and implementation of databases and their applications by providing a solid foundation of the theory underlying database systems.This book takes an applications-oriented approach to database concepts and covers topics including; ER Modeling, UML, XML, object-oriented databases, SQL, database tuning, and the important software issues that arise when implementing database applications.This book is appropriate for programmers who want to understand database system concepts and how they apply to real-world databases.

Preface

xvii

PART ONE Introduction

(28)

Overview of Databases and Transactions

(10)

What Are Databases and Transactions?

(3)

Features of Modern Database and Transaction Processing Systems

(1)

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

(2)

Decision Support Systems---OLAP and OLTP

(4)

The Big Picture

(16)

Case Study: A Student Registration System

(1)

Introduction to Relational Databases

(6)

What Makes a Program a Transaction---The ACID Properties

(9)

Bibliographic Notes

(1)

Exercises

(4)

PART TWO Database Management

(290)

The Relational Data Model

(38)

What Is a Data Model?

(4)

The Relational Model

(11)

Basic Concepts

(3)

Integrity Constraints

(8)

SQL---Data Definition Sublanguage

(23)

Specifying the Relation Type

(1)

The System Catalog

(1)

Key Constraints

(1)

Dealing with Missing Information

(1)

Semantic Constraints

(4)

User-Defined Domains

(1)

Foreign-Key Constraints

(3)

Reactive Constraints

(3)

Database Views

(1)

Modifying Existing Definitions

(2)

SQL-Schemas

(1)

Access Control

(2)

Bibliographic Notes

(1)

Exercises

(3)

Conceptual Modeling of Databases with Entry-Relationship Diagrams and the Unified Modeling Language

(58)

Conceptual Modeling with the E-R Approach

(1)

Entities and Entity Types

(3)

Relationships and Relationship Types

(5)

Advanced Features in Conceptual Data Modeling

(8)

Entity Type Hierarchies

(3)

Participation Constraints

(2)

The Part-of Relationship

(3)

From E-R Diagrams to Relational Database Schemas

(9)

Representation of Entities

(2)

Representation of Relationships

(2)

Representing IsA Hierarchies in the Relational Model

(2)

Representation of Participation Constraints

(2)

Representation of the Part-of Relationship

(1)

UML: A New Kid on the Block

(11)

Representing Entities in UML

(1)

Representing Relationships in UML

(4)

Advanced Modeling Concepts in UML

101

(4)

Translation to SQL

105

(1)

A Brokerage Firm Example

106

(5)

An Entity-Relationship Design

106

(4)

A UML Design

110

(1)

Case Study: A Database Design for the Student Registration System

111

(8)

The Database Part of the Requirements Document

112

(1)

The Database Design

113

(6)

Limitations of Data Modeling Methodologies

119

(8)

Bibliographic Notes

123

(1)

Exercises

123

(4)

Relational Algebra and SQL

127

(66)

Relational Algebra: Under the Hood of SQL

128

(19)

Basic Operators

128

(9)

Derived Operators

137

(10)

The Query Sublanguage of SQL

147

(35)

Simple SQL Queries

148

(6)

Set Operations

154

(3)

Nested Queries

157

(6)

Quantified Predicates

163

(1)

Aggregation over Data

164

(6)

Join Expressions in the FROM Clause

170

(1)

A Simple Query Evaluation Algorithm

171

(3)

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Database Systems An Application-Oriented Approach, Introductory Version

Summary

Table of Contents

Supplemental Materials