Concepts of Database Management

by Pratt, Philip J.

• ISBN13: 9780619000578
• ISBN10: 0619000570
• Edition: 3rd
• Format: Paperback
• Copyright: 2000-07-01
• Publisher: Course Technology Ptr

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