Concepts of Database Management, Fifth Edition

by Pratt, Philip J.; Adamski, Joseph J.

• ISBN13: 9780619215293
• ISBN10: 0619215291
• Edition: 5th
• Format: Paperback
• Copyright: 2004-07-12
• Publisher: Course Technology

Summary

This edition includes expanded coverage of SQL, entity-relationship (E-R) diagrams, normalization, and database design. The two featured caseproblems bring to life real-world database issues such as database design, data integrity, concurrent updates, and data security.

Table of Contents

Preface	viii
Introduction to Database Management	1	(28)
Objectives	1	(1)
Introduction	2	(1)
Premiere Products Background	2	(3)
Database Background	5	(7)
Database Management Systems	12	(3)
Advantages of Database Processing	15	(3)
Disadvantages of Database Processing	18	(1)
Introduction to the Henry Books Database Case	19	(7)
Summary	26	(1)
Key Terms	26	(1)
Review Questions	27	(1)
Premiere Products Exercises	27	(1)
Henry Books Case	28	(1)
The Relational Model 1: Introduction, QBE, and Relational Algebra	29	(38)
Objectives	29	(1)
Introduction	30	(1)
Relational Databases	30	(4)
Query-By-Example (QBE)	34	(1)
Simple Queries	34	(2)
Simple Criteria	36	(1)
Compound Criteria	37	(2)
Computed Fields	39	(1)
Calculating Statistics	40	(2)
Grouping	42	(1)
Sorting	43	(3)
Sorting on Multiple Keys	44	(2)
Joining Tables	46	(3)
Joining Multiple Tables	48	(1)
Using an Update Query	49	(1)
Using a Delete Query	50	(1)
Using a Make-Table Query	51	(1)
Relational Algebra	52	(1)
Select	53	(1)
Project	54	(1)
Join	54	(3)
Normal Set Operations	57	(2)
Union	57	(1)
Intersection	58	(1)
Difference	58	(1)
Product	59	(1)
Division	60	(1)
Summary	61	(1)
Key Terms	62	(1)
Review Questions	62	(1)
Premiere Products Exercises: QBE	63	(1)
Premiere Products Exercises: Relational Algebra	64	(1)
Henry Books Case	65	(2)
The Relational Model 2: SQL	67	(42)
Objectives	67	(1)
Introduction	68	(1)
Table Creation	68	(2)
Simple Retrieval	70	(5)
Compound Conditions	75	(4)
Computed Fields	79	(1)
Using Special Operators (LIKE and IN)	80	(2)
Sorting	82	(2)
Built-In Functions	84	(3)
Nesting Queries	87	(1)
Grouping	88	(2)
Joining Tables	90	(4)
Union	94	(1)
Updating Tables	95	(1)
Creating a Table from a Query	96	(1)
Summary of SQL Commands	97	(7)
Summary	104	(1)
Key Terms	104	(1)
Review Questions	105	(1)
Premiere Products Exercises	105	(1)
Henry Books Case	106	(3)
The Relational Model 3: Advanced Topics	109	(30)
Objectives	109	(1)
Introduction	110	(1)
Views	110	(7)
Indexes	117	(4)
Security	121	(1)
Integrity Rules	122	(6)
Entity Integrity	122	(1)
Referential Integrity	123	(4)
Legal-Values Integrity	127	(1)
Structure Changes	128	(3)
Making Complex Changes	131	(1)
System Catalog	131	(4)
Summary	135	(1)
Key Terms	135	(1)
Review Questions	136	(1)
Premiere Products Exercises	137	(1)
Henry Books Case	138	(1)
Database Design 1: Normalization	139	(34)
Objectives	139	(1)
Introduction	140	(2)
Functional Dependence	142	(3)
Keys	145	(1)
First Normal Form	146	(2)
Second Normal Form	148	(4)
Third Normal Form	152	(4)
Incorrect Decompositions	156	(6)
Multivalued Dependencies and Fourth Normal Form	162	(4)
Avoiding the Problem with Multivalued Dependencies	166	(1)
Application to Database Design	166	(2)
Summary	168	(1)
Key Terms	168	(1)
Review Questions	169	(1)
Premiere Products Exercises	170	(1)
Henry Books Case	170	(3)
Database Design 2: Design Methodology	173	(52)
Objectives	173	(1)
Introduction	174	(1)
User Views	174	(1)
Information-Level Design Methodology	175	(1)
Represent the User View as a Collection of Tables	175	(2)
Normalize the Tables	177	(1)
Represent All Keys	177	(4)
Types of Primary Keys	178	(1)
Database Design Language (DBDL)	179	(1)
Entity-Relationship Diagrams	180	(1)
Merge the Result into the Design	181	(1)
Database Design Examples	182	(13)
Physical-Level Design	195	(2)
Top-Down Versus Bottom-Up	197	(1)
Survey Form	198	(1)
Obtaining Information from Existing Documents	199	(5)
One-to-One Relationship Considerations	204	(3)
Many-to-Many Relationship Considerations	207	(2)
Nulls and Entity Subtypes	209	(5)
Avoiding Problems with Third Normal Form When Merging Tables	214	(1)
The Entity-Relationship Model	215	(5)
Summary	220	(1)
Key Terms	221	(1)
Review Questions	221	(2)
Premiere Products Exercises	223	(1)
Henry Books Case	224	(1)
DBMS Functions	225	(36)
Objectives	225	(1)
Introduction	226	(1)
Update and Retrieve Data	226	(2)
Provide Catalog Services	228	(1)
Support Concurrent Update	229	(11)
The Concurrent Update Problem	229	(4)
Avoiding the Lost Update Problem	233	(1)
Two-Phase Locking	234	(3)
Deadlock	237	(1)
Locking on PC-Based DBMSs	238	(2)
Timestamping	240	(1)
Recover Data	240	(5)
Journaling	241	(2)
Forward Recovery	243	(1)
Backward Recovery	244	(1)
Recovery on PC-Based DBMSs	244	(1)
Provide Security Services	245	(5)
Encryption	245	(1)
Authentication	246	(1)
Authorizations	247	(3)
Views	250	(1)
Privacy	250	(1)
Provide Data Integrity Features	250	(3)
Support Data Independence	253	(1)
Adding a Field	253	(1)
Changing the Length of a Field	253	(1)
Creating an Index	253	(1)
Adding or Changing a Relationship	253	(1)
Support Data Replication	254	(2)
Provide Utility Services	256	(1)
Summary	257	(1)
Key Terms	258	(1)
Review Questions	258	(1)
Premiere Products Exercises	259	(1)
Henry Books Case	260	(1)
Database Administration	261	(24)
Objectives	261	(1)
Introduction	262	(1)
Database Policy Formulation and Enforcement	263	(6)
Access Privileges	263	(2)
Security	265	(3)
Disaster Planning	268	(1)
Archiving	268	(1)
Other Database Administrative Functions	269	(7)
DBMS Evaluation and Selection	269	(6)
DBMS Maintenance	275	(1)
Data Dictionary Management	275	(1)
Training	275	(1)
Technical Functions	276	(5)
Database Design	276	(1)
Testing	276	(1)
Performance Tuning	277	(4)
Summary	281	(1)
Key Terms	281	(1)
Review Questions	282	(1)
Premiere Products Exercises	282	(1)
Henry Books Case	283	(2)
Database Management Approaches	285	(42)
Objectives	285	(1)
Introduction	286	(1)
Distributed Databases	286	(2)
Characteristics of Distributed DBMSs	288	(3)
Location Transparency	288	(1)
Replication Transparency	289	(1)
Fragmentation Transparency	289	(2)
Advantages of Distributed Databases	291	(1)
Disadvantages of Distributed Databases	291	(4)
Rules for Distributed Databases	295	(1)
Client/Server Systems	296	(4)
Advantages of Client/Server Systems	299	(1)
Triggers and Stored Procedures	300	(1)
Data Warehouses	300	(8)
Data Warehouse Structure and Access	302	(5)
Rules for OLAP Systems	307	(1)
Object-Oriented DBMSs	308	(8)
What is an Object-Oriented DBMS?	308	(1)
Objects and Classes	308	(2)
Methods and Messages	310	(2)
Inheritance	312	(1)
Unified Modeling Language	312	(3)
Rules for OODBMSs	315	(1)
Web Access to Databases	316	(2)
History of Database Management	318	(1)
Hierarchical and Network Databases	319	(2)
Network Model	319	(1)
Hierarchical Model	320	(1)
Summary	321	(2)
Key Terms	323	(1)
Review Questions	324	(1)
Premiere Products Exercises	325	(1)
Henry Books Case	326	(1)
Appendix A: Comprehensive Design Example: Marvel College	327	(36)
Introduction	327	(1)
Marvel College Requirements	327	(6)
General Description	327	(1)
Report Requirements	328	(5)
Update (Transaction) Requirements	333	(1)
Marvel College Information-Level Design	333	(21)
Final Information-Level Design	354	(1)
Exercises	355	(8)
Appendix B: Additional Case Problem: Alexamara Marina Group	363	(10)
Alexamara Marina Group Exercises	368	(5)
Chapter 1	368	(1)
Chapter 2	368	(1)
Chapter 3	369	(2)
Chapter 4	371	(1)
Chapter 5	372	(1)
Chapter 6	372	(1)
Appendix C: SQL Reference	373	(14)
Alter Table	373	(1)
Column or Expression List (SELECT Clause)	374	(1)
Computed Fields	374	(1)
Functions	374	(1)
Conditions	374	(2)
Simple Conditions	374	(1)
Compound Conditions	375	(1)
Between Conditions	375	(1)
Like Conditions	375	(1)
IN Conditions	376	(1)
Create Index	376	(1)
Create Table	377	(1)
Create View	378	(1)
Data Types	378	(1)
Delete Rows	379	(1)
Drop Index	379	(1)
Drop Table	380	(1)
Grant	380	(1)
Insert	381	(1)
Integrity	381	(1)
Revoke	382	(1)
Select	382	(1)
Select Into	383	(1)
Subqueries	384	(1)
Union	384	(1)
Update	385	(2)
Appendix D: ``How Do I'' Reference	387	(2)
Appendix E: Answers to Odd-Numbered Review Questions	389	(12)
Chapter 1---Introduction to Database Management	389	(1)
Chapter 2---The Relational Model 1: Introduction, QBE, and Relational Algebra	390	(1)
Chapter 3---The Relational Model 2: SQL	391	(1)
Chapter 4---The Relational Model 3: Advanced Topics	392	(1)
Chapter 5---Database Design 1: Normalization	393	(1)
Chapter 6---Database Design 2: Design Methodology	394	(1)
Chapter 7---DBMS Functions	395	(2)
Chapter 8---Database Administration	397	(1)
Chapter 9---Database Management Approaches	398	(3)
Glossary	401	(10)
Index	411