Rent More, Save More! Use code: KBRENTAL

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

Concepts of Database Management

by: PRATT/ADAMSKI

Concepts of Database Management

by: PRATT/ADAMSKI

ISBN 13:
9780619064624
ISBN 10:
0619064625
Format: Paperback
Copyright: 06/20/2002
Publisher: Course Technology
Newer Edition

Rent

Sorry, this item is currently unavailable.

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

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

Preface

vii

Introduction to Database Management

(28)

Objectives

(1)

Introduction

(1)

Premiere Products Background

(3)

Database Background

(6)

Database Management Systems

(4)

Advantages of Database Processing

(2)

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

(2)

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 Update Queries

(1)

Using Delete Queries

(1)

Using Make-Table Queries

(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

(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

Rent More, Save More! Use code: KBRENTAL

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

Concepts of Database Management

Concepts of Database Management

9780619064624

0619064625

Summary

Table of Contents

Supplemental Materials

Write a Review

Rent More, Save More! Use code: KBRENTAL

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

Concepts of Database Management

Concepts of Database Management

9780619064624

0619064625

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products