Concepts of Database Management 8th Edition by Philip Pratt, Mary Last ISBN 1285427106 978-1285427102

Chapter 1. Introduction to Database Management

TAL Distributors Background

Database Background

Database Management Systems

Advantages of Database Processing

Disadvantages of Database Processing

Introduction to the Colonial Adventure Tours Database Case

Introduction to the Solmaris Condominium Group Database Case

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 2. The Relational Model 1: Introduction, QBE, and Relational Algebra

Relational Databases

Query-by-Example (QBE)

Simple Queries

Simple Criteria

Compound Criteria

Computed Fields

Functions

Grouping

Sorting

Sorting on Multiple Keys

Joining Tables

Joining Multiple Tables

Using an Update Query

Using a Delete Query

Using a Make-Table Query

Relational Algebra

SELECT

PROJECT

JOIN

Normal Set Operations

Product

Division

Summary

Key Terms

Review Questions

TAL Distributors Exercises: QBE

TAL Distributors Exercises: Relational Algebra

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 3. The Relational Model 2: SQL

Getting Started with SQL

Getting Started with Access 2010 or 2013

Table Creation

Simple Retrieval

Compound Conditions

Computed Fields

Using Special Operators (LIKE and IN)

Sorting

Built-In Functions

Subqueries

Grouping

Joining Tables

Union

Updating Tables

Creating a Table from a Query

Summary of SQL Commands

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 4. The Relational Model 3: Advanced Topics

Views

Indexes

Security

Integrity Rules

Entity Integrity

Referential Integrity

Legal-Values Integrity

Structure Changes

Making Complex Changes

System Catalog

Stored Procedures

Triggers

Triggers in Access 2013

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 5. Database Design 1: Normalization

Functional Dependence

Keys

First Normal Form

Second Normal Form

Third Normal Form

Incorrect Decompositions

Multivalued Dependencies and Fourth Normal Form

Avoiding the Problem with Multivalued Dependencies

Application to Database Design

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 6. Database Design 2: Design Method

User Views

Information-Level Design Method

Represent the User View as a Collection of Tables

Normalize the Tables

Identify All Keys

Database Design Language (DBDL)

Entity-Relationship (E-R) Diagrams

Merge the Result into the Design

Database Design Examples

Physical-Level Design

Top-Down versus Bottom-Up Design

Survey Form

Obtaining Information from Existing Documents

One-to-One Relationship Considerations

Many-to-Many Relationship Considerations

Nulls and Entity Subtypes

Avoiding Problems with third normal form when Merging Tables

The Entity-Relationship Model

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 7. DBMS Functions

Update and Retrieve Data

Provide Catalog Services

Support Concurrent Update

The Concurrent Update Problem

Avoiding the Lost Update Problem

Two-Phase Locking

Deadlock

Locking on PC-Based DBMSs

Timestamping

Recover Data

Journaling

Forward Recovery

Backward Recovery

Recovery on PC-Based DBMSs

Provide Security Services

Encryption

Authentication

Authorizations

Views

Privacy

Provide Data Integrity Features

Support Data Independence

Adding a Field

Changing the Length of a Field

Creating an Index

Adding or Changing a Relationship

Support Data Replication

Provide Utility Services

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 8. Database Administration

Database Policy Formulation and Enforcement

Access Privileges

Security

Disaster Planning

Archiving

Other Database Administrative Functions

DBMS Evaluation and Selection

DBMS Maintenance

Data Dictionary Management

Training

Technical Functions

Database Design

Testing

Performance Tuning

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Chapter 9. Database Management Approaches

Distributed Databases

Characteristics of Distributed DBMSs

Location Transparency

Replication Transparency

Fragmentation Transparency

Advantages of Distributed Databases

Disadvantages of Distributed Databases

Rules for Distributed Databases

Client/Server Systems

Advantages of Client/Server Systems

Web Access to Databases

XML

Data Warehouses

Data Warehouse Structure and Access

Rules for OLAP Systems

Object-Oriented Dbmss

What Is an Object-Oriented DBMS?

Objects and Classes

Methods and Messages

Inheritance

Unified Modeling Language (UML)

Rules for OODBMSs

Summary

Key Terms

Review Questions

TAL Distributors Exercises

Colonial Adventure Tours Case

Solmaris Condominium Group Case

Appendix A. Comprehensive Design Example: Marvel College

Appendix B. SQL Reference

Appendix C. “How Do I” Reference

Appendix E. Using Access to Create a Web App

Appendix F. A Systems Analysis Approach to Information-Level Requirements