Fundamentals of database management systems / Mark L. Gillenson.

Includes index.

Table of contents Cover
Title Page
Copyright Page
Brief Contents
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: Lucky Rent-A-Car
Relational Query Optimizer Relational DBMS Performance
Relational Query Optimizer Concepts
Summary
Chapter 5 The Relational Database Model: Introduction
Introduction
The Relational Database Concept
Relational Terminology
Primary and Candidate Keys
Foreign Keys and Binary Relationships
Many-to-Many Binary Relationship
Data Retrieval from a Relational Database
Extracting Data from a Relation
The Relational Select Operator
The Relational Project Operator
Combination of the Relational Select and Project Operators
Extracting Data Across Multiple Relations: Data Integration Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
Chapter 6 The Relational Database Model: Additional Concepts
Introduction
Relational Structures for Unary and Ternary Relationships
Unary One-to-Many Relationships
Unary Many-to-Many Relationships
Ternary Relationships
Referential Integrity
The Referential Integrity Concept
Three Delete Rules
Summary
Chapter 7 Logical Database Design
Introduction
Converting E-R Diagrams into Relational Tables
Introduction
Converting a Simple Entity

"The New Corporate Resource The development of database management systems, as well as the development of modern computers, came about as a result of society's recognition of the crucial importance of storing, managing, and retrieving its rapidly expanding volumes of business data. To understand how far we have come in this regard, it is important to know where we began and how the concept of managing data has developed. This chapter begins with the historical background of the storage and uses of data and then continues with a discussion of the importance of data to the modern corporation."-- Provided by publisher

Computer Science & Engineering Computer Science & Engineering

Muktadir Rahman