CART

(0) items

Concepts of Database Management,9780619064624
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Concepts of Database Management

by
Edition:
4th
ISBN13:

9780619064624

ISBN10:
0619064625
Format:
Paperback
Pub. Date:
6/20/2002
Publisher(s):
Course Technology
List Price: $70.33
More New and Used
from Private Sellers
Starting at $0.01
See Prices

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

New Textbook

We're Sorry
Sold Out

Related Products


  • CONCEPTS DATABASE MNGMNT
    CONCEPTS DATABASE MNGMNT
  • Concepts of Database Management
    Concepts of Database Management
  • Concepts of Database Management
    Concepts of Database Management
  • Concepts of Database Management
    Concepts of Database Management
  • Concepts of Database Management, Fifth Edition
    Concepts of Database Management, Fifth Edition
  • Concepts of Database Management, Third Edition
    Concepts of Database Management, Third Edition




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


Please wait while the item is added to your cart...