Concepts of Database Management, Fifth Edition,9780619215293

Concepts of Database Management, Fifth Edition

by ;
Edition: 5th
ISBN13: 9780619215293
ISBN10: 0619215291
Format: Paperback
Pub. Date: 2004-07-12
Publisher(s): Course Technology
Upgraded Edition: Click here!
  • Free Shipping Icon

    Free Shipping On All Orders!*

    Free economy shipping applies to all orders shipped to residential addresses. Orders shipped to campus receive free standard shipping. Free shipping offers do not apply to Marketplace items.

List Price: $165.00

Buy New

Usually ships in 2 to 3 business days.
$164.84
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $5.54

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.