Concepts of Database Management, Third Edition

by Pratt, Philip J.

Edition:

3rd

ISBN13:

9780619000578

ISBN10:

0619000570

Format:

Paperback

Pub. Date:

7/1/2000

Publisher(s):

Course Technology

Upgraded Edition: Click here!

Other versions by this Author

List Price: ~~$39.37~~

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours

$38.39

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

More New and Used
from Private Sellers

Starting at $0.01

Questions About This Book?

What version or edition is this?

This is the 3rd edition with a publication date of 7/1/2000.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.

Summary

Continuing the tradition of their successful first two editions, Philip J. Pratt and Joseph J. Adamski have created "The Concepts of Database Management, Third Edition" to even better serve those learners who are looking for a concise but complete introduction to database concepts. This book fits database fundamentals into a shorter format that teaches users how to build databases through two effective running case studies. Using Access as a foundation, the Third Edition begins with a discussion of database models and proceeds to cover QBE, SQL, Normalization, Design Methodology, and Administration. Each chapter features step-by-step instruction, exercises, and projects that enhance learning.

Preface

Introduction to Database Management

(24)

Objectives

(1)

Introduction

(1)

Henry's Basic Data

(8)

Background

(5)

Advantages of Database Processing

(2)

Disadvantages of Database Processing

(1)

History of Database Management

(1)

Hierarchical and Network Databases

(3)

Summary, Key Terms, and Review Questions

(2)

The Relational Model 1: Introduction, QBE, and the Relational Algebra

(32)

Objectives

(1)

Introduction

(1)

Premiere Products

(5)

Relational Databases

(3)

QBE

(11)

The Relational Algebra

(8)

Summary, Key Terms, and Review Questions

(4)

The Relational Model 2: SQL

(24)

Objectives

(1)

Introduction

(1)

Database Creation

(2)

Simple Retrieval

(3)

Compound Conditions

(2)

Computed Fields

(1)

Sorting

(2)

Built-In Functions

(1)

Nesting Queries

(3)

Grouping

(2)

Joining Tables

(2)

Union

(1)

Updating Tables

(2)

Summary, Key Terms, and Review Questions

(3)

The Relational Model 3: Advanced Topics

(22)

Objectives

(1)

Introduction

(1)

Views

(5)

Indexes

(3)

Security

(1)

Integrity Rules

(4)

Changing the Structure of a Relational Database

(2)

The Catalog

(2)

Itegrity in SQL

(2)

Summary, Key Terms, and Review Questions

100

(3)

Database Design 1: Normalization

103

(1)

Objectives

103

(1)

Introduction

104

(1)

Functional Dependence

105

(3)

Keys

108

(1)

First Normal Form

109

Concepts of Database Management, Third Edition

9780619000578

Buy New Textbook

Rent Textbook

Used Textbook

eTextbook

Questions About This Book?

Related Products

Summary

Table of Contents