Concepts of Database Management, Fifth Edition

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

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780619215293 | 0619215291
Cover: Paperback
Copyright: 7/12/2004

Buy New

Currently Available, Usually Ships in 24-48 Hours

$163.19

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.

Preface

viii

Introduction to Database Management

(28)

Objectives

(1)

Introduction

(1)

Premiere Products Background

(3)

Database Background

(7)

Database Management Systems

(3)

Advantages of Database Processing

(3)

Disadvantages of Database Processing

(1)

Introduction to the Henry Books Database Case

(7)

Summary

(1)

Key Terms

(1)

Review Questions

(1)

Premiere Products Exercises

(1)

Henry Books Case

(1)

The Relational Model 1: Introduction, QBE, and Relational Algebra

(38)

Objectives

(1)

Introduction

(1)

Relational Databases

(4)

Query-By-Example (QBE)

(1)

Simple Queries

(2)

Simple Criteria

(1)

Compound Criteria

(2)

Computed Fields

(1)

Calculating Statistics

(2)

Grouping

(1)

Sorting

(3)

Sorting on Multiple Keys

(2)

Joining Tables

(3)

Joining Multiple Tables

(1)

Using an Update Query

(1)

Using a Delete Query

(1)

Using a Make-Table Query

(1)

Relational Algebra

(1)

Select

(1)

Project

(1)

Join

(3)

Normal Set Operations

(2)

Union

(1)

Intersection

(1)

Difference

(1)

Product

(1)

Division

(1)

Summary

(1)

Key Terms

(1)

Review Questions

(1)

Premiere Products Exercises: QBE

(1)

Premiere Products Exercises: Relational Algebra

(1)

Henry Books Case

(2)

The Relational Model 2: SQL

(42)

Objectives

(1)

Introduction

(1)

Table Creation

(2)

Simple Retrieval

(5)

Compound Conditions

(4)

Computed Fields

(1)

Using Special Operators (LIKE and IN)

(2)

Sorting

(2)

Built-In Functions

(3)

Nesting Queries

(1)

Grouping

(2)

Joining Tables

(4)

Union

(1)

Updating Tables

(1)

Creating a Table from a Query

(1)

Summary of SQL Commands

(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

FREE SHIPPING

Rent More, Save More! Use code: BBRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

Concepts of Database Management, Fifth Edition

Summary

Table of Contents

Supplemental Materials