9780619000578

Concepts of Database Management

by
  • ISBN13:

    9780619000578

  • ISBN10:

    0619000570

  • Edition: 3rd
  • Format: Paperback
  • Copyright: 7/1/2000
  • Publisher: Course Technology Ptr
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $47.95

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.

Table of Contents

Preface v
Introduction to Database Management
1(24)
Objectives
1(1)
Introduction
2(1)
Henry's Basic Data
3(8)
Background
11(5)
Advantages of Database Processing
16(2)
Disadvantages of Database Processing
18(1)
History of Database Management
19(1)
Hierarchical and Network Databases
20(3)
Summary, Key Terms, and Review Questions
23(2)
The Relational Model 1: Introduction, QBE, and the Relational Algebra
25(32)
Objectives
25(1)
Introduction
26(1)
Premiere Products
26(5)
Relational Databases
31(3)
QBE
34(11)
The Relational Algebra
45(8)
Summary, Key Terms, and Review Questions
53(4)
The Relational Model 2: SQL
57(24)
Objectives
57(1)
Introduction
58(1)
Database Creation
58(2)
Simple Retrieval
60(3)
Compound Conditions
63(2)
Computed Fields
65(1)
Sorting
65(2)
Built-In Functions
67(1)
Nesting Queries
68(3)
Grouping
71(2)
Joining Tables
73(2)
Union
75(1)
Updating Tables
76(2)
Summary, Key Terms, and Review Questions
78(3)
The Relational Model 3: Advanced Topics
81(22)
Objectives
81(1)
Introduction
82(1)
Views
82(5)
Indexes
87(3)
Security
90(1)
Integrity Rules
90(4)
Changing the Structure of a Relational Database
94(2)
The Catalog
96(2)
Itegrity in SQL
98(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

Rewards Program

Write a Review