Concepts of Database Management

by PRATT/ADAMSKI

• ISBN13: 9780619064624
• ISBN10: 0619064625
• Format: Paperback
• Copyright: 2002-06-20
• Publisher: Course Technology

Summary

Offering a comprehensive introduction to database concepts, with a focus on the relational model of database management, this text makes a great companion for any database application course, or as a "concepts supplement" to a hands-on database management course. No other text has full coverage of the fundamentals of database design and administration in this manageable, nine-chapter format.

Table of Contents

Preface	vii
Introduction to Database Management	1	(28)
Objectives	1	(1)
Introduction	2	(1)
Premiere Products Background	2	(3)
Database Background	5	(6)
Database Management Systems	11	(4)
Advantages of Database Processing	15	(2)
Disadvantages of Database Processing	17	(1)
Introduction to the Henry Books Database Case	18	(7)
Summary	25	(1)
Key Terms	25	(1)
Review Questions	26	(1)
Premiere Products Exercises	26	(1)
Henry Books Case	27	(2)
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 Update Queries	49	(1)
Using Delete Queries	50	(1)
Using Make-Table Queries	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	(3)
Summary	134	(1)
Key Terms	134	(1)
Review Questions	135	(1)
Premiere Products Exercises	136	(1)
Henry Books Case	137	(2)
Database Design 1: Normalization	139	(30)
Objectives	139	(1)
Introduction	140	(2)
Functional Dependence	142	(2)
Keys	144	(1)
First Normal Form	145	(1)
Second Normal Form	146	(4)
Third Normal Form	150	(4)
Incorrect Decompositions	154	(6)
Multivalued Dependencies and Fourth Normal Form	160	(4)
Avoiding the Problem with Multivalued Dependencies	164	(1)
Summary	165	(1)
Key Terms	165	(1)
Review Questions	166	(1)
Premiere Products Exercises	167	(1)
Henry Books Case	167	(2)
Database Design 2: Design Methodology	169	(52)
Objectives	169	(1)
Introduction	170	(1)
User Views	170	(1)
Information-Level Design Methodology	171	(1)
Represent a User View as a Collection of Tables	171	(2)
Normalize the Tables	173	(1)
Represent All Keys	173	(4)
Database Design Language (DBDL)	174	(1)
Entity-Relationship Diagrams	175	(2)
Merge the Result into the Design	177	(1)
Database Design Examples	178	(13)
Physical-Level Design	191	(2)
Entity-Relationship Diagram Alternatives	193	(3)
Top-Down Versus Bottom-Up	196	(1)
Survey Form	197	(1)
Obtaining Information from Existing Documents	198	(5)
One-to-One Relationship Considerations	203	(2)
Many-to-Many Relationship Considerations	205	(3)
Nulls and Entity Subtypes	208	(5)
Avoiding Problems with Third Normal Form When Merging Tables	213	(2)
Summary	215	(1)
Key Terms	216	(1)
Review Questions	216	(2)
Premiere Products Exercises	218	(1)
Henry Books Case	218	(3)
DBMS Functions	221	(36)
Objectives	221	(1)
Introduction	222	(1)
Update and Retrieve Data	222	(2)
Provide Catalog Services	224	(1)
Support Concurrent Update	225	(11)
The Concurrent Update Problem	225	(4)
Avoiding the Lost Update Problem	229	(1)
Two-Phase Locking	230	(3)
Deadlock	233	(1)
Locking on PC-Based DBMSs	234	(2)
Timestamping	236	(1)
Recover Data	236	(5)
Journaling	237	(2)
Forward Recovery	239	(1)
Backward Recovery	240	(1)
Recovery on PC-Based DBMSs	240	(1)
Provide Security Services	241	(5)
Encryption	241	(1)
Authentication	242	(1)
Authorizations	243	(3)
Views	246	(1)
Privacy	246	(1)
Provide Data Integrity Features	246	(3)
Support Data Independence	249	(1)
Adding a Field	249	(1)
Changing the Length of a Field	249	(1)
Creating an Index	249	(1)
Adding or Changing a Relationship	249	(1)
Support Data Replication	250	(2)
Provide Utility Services	252	(1)
Summary	253	(1)
Key Terms	254	(1)
Review Questions	254	(1)
Premiere Products Exercises	255	(1)
Henry Books Case	256	(1)
Database Administration	257	(24)
Objectives	257	(1)
Introduction	258	(1)
Database Policy Formulation and Enforcement	259	(6)
Access Privileges	259	(2)
Security	261	(3)
Disaster Planning	264	(1)
Archiving	264	(1)
Other Database Administrative Functions	265	(7)
DBMS Evaluation and Selection	265	(6)
DBMS Maintenance	271	(1)
Data Dictionary Management	271	(1)
Training	271	(1)
Technical Functions	272	(9)
Database Design	272	(1)
Testing	272	(1)
Performance Tuning	273	(4)
Summary	277	(1)
Key Terms	277	(1)
Review Questions	278	(1)
Premiere Products Exercises	278	(1)
Henry Books Case	279	(2)
Database Management Approaches	281	(42)
Objectives	281	(1)
Introduction	282	(1)
Distributed Databases	282	(2)
Characteristics of Distributed DBMSs	284	(3)
Location Transparency	284	(1)
Replication Transparency	285	(1)
Fragmentation Transparency	285	(2)
Advantages of Distributed Databases	287	(1)
Disadvantages of Distributed Databases	287	(4)
Rules for Distributed Databases	291	(1)
Client/Server Systems	292	(4)
Advantages of Client/Server Systems	295	(1)
Triggers and Stored Procedures	296	(1)
Data Warehouses	296	(8)
Data Warehouse Structure and Access	298	(5)
Rules for OLAP Systems	303	(1)
Object-Oriented DBMSs	304	(8)
What is an Object-Oriented DBMS?	304	(1)
Objects and Classes	304	(2)
Methods and Messages	306	(2)
Inheritance	308	(1)
Unified Modeling Language	308	(3)
Rules for OODBMSs	311	(1)
Web Access to Databases	312	(2)
History of Database Management	314	(1)
Hierarchical and Network Databases	315	(2)
Network Model	315	(1)
Hierarchical Model	316	(1)
Summary	317	(2)
Key Terms	319	(1)
Review Questions	320	(1)
Premiere Products Exercises	321	(1)
Henry Books Case	322	(1)
Appendix A: Comprehensive Design Example	323	(36)
Introduction	323	(1)
Marvel College Requirements	323	(6)
General Description	323	(1)
Report Requirements	324	(5)
Update (Transaction) Requirements	329	(1)
Marvel College Information-Level Design	329	(21)
Final Information-Level Design	350	(1)
Exercises	351	(8)
Appendix B: Answers to Odd-Numbered Review Questions	359	(12)
Glossary	371	(10)
Index	381