Fundamentals of Database Management Systems, Second Edition

CONTENTS

Preface

About The Author

CHAPTER 1 DATA: THE NEW CORPORATE RESOURCE

Introduction

The History of Data

The Origins of Data

Data Through the Ages

Early Data Problems Spawn Calculating Devices

Swamped with Data

Modern Data Storage Media

Data in Today's Information Systems Environment

Using Data for Competitive Advantage

Problems in Storing and Accessing Data

Data as a Corporate Resource

The Database Environment

Summary

CHAPTER 2 DATA MODELING

Introduction

Binary Relationships

What is a Binary Relationship?

Cardinality

Modality

More About Many-to-Many Relationships

Unary Relationships

One-to-One Unary Relationship

One-to-Many Unary Relationship

Many-to-Many Unary Relationship

Ternary Relationships

Example: The General Hardware Company

Example: Good Reading Book Stores

Example: World Music Association

Example: Lucky Rent-A-Car

Summary

CHAPTER 3 THE DATABASE MANAGEMENT SYSTEM CONCEPT

Introduction

Data Before Database Management

Records and Files

Basic Concepts in Storing and Retrieving Data

The Database Concept

Data as a Manageable Resource

Data Integration and Data Redundancy

Multiple Relationships

Data Control Issues

Data Independence

DBMS Approaches

Summary

CHAPTER 4 RELATIONAL DATA RETRIEVAL: SQL

Introduction

Data Retrieval with the SQL SELECT Command

Introduction to the SQL SELECT Command

Basic Functions

Built-In Functions

Grouping Rows

The Join

Subqueries

A Strategy for Writing SQL SELECT Commands

Example: Good Reading Book Stores

Example: World Music Association

Example: ...