Amazon no longer offers textbook rentals. We do!

Database Management Systems-Designing & Building Business Applications

by: POST

Database Management Systems-Designing & Building Business Applications

by: POST

ISBN 13:
9780072973129
ISBN 10:
0072973129
Edition: 3rd
Format: Hardcover
Copyright: 02/04/2004
Publisher: McGraw-Hill/Irwin

Rent From $99.07

New From $148.98

List Price $150.48 Save

Rent $99.07

TERM	PRICE	DUE
SEMESTER	$104.29	Dec 13
QUARTER	$99.07	Aug 16
SHORT TERM	$93.86	Jul 01

Added Benefits of Renting

Free Shipping Both Ways
Highlight/Take Notes Like You Own It
Purchase/Extend Before Due Date

Add to Cart

List Price $150.48 Save $1.50

New $148.98

Usually Ships in 3-4 Business Days

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

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

In today's increasingly decentralized and insecure business arena, effective database management has taken on a whole new urgency. Database Management Systems, Third Edition, introduces and explains core concepts of database design, development, and administration. Special sections demonstrate how to first evaluate security threats and then design vital security components and integrate them into each application. Applied exercises and cases bring facts and data into the real world.

Introduction

(28)

A Developer's View

(1)

Introduction

(1)

Databases and Application Development

(2)

Components of a Database Management System

(6)

Database Engine

(1)

Data Dictionary

(1)

Query Processor

(1)

Report Writer

(2)

Forms Generator

(1)

Application Generator

(1)

Communication and Integration

(1)

Security and Other Utilities

(1)

Advantages of the Database Management System Approach

(3)

Focus on Data

(1)

Data Independence

(1)

Data Independence and Client/Server Systems

(1)

Leading Commercial Databases

(1)

Brief History of Database Management Systems

(6)

Hierarchical Databases

(1)

Network Databases

(2)

Relational Databases

(1)

Object-Oriented Databases

(4)

Application Development

(1)

Sally's Pet Store

(1)

Rolling Thunder Bicycles

(1)

The Feasibility Study

(3)

Costs

(1)

Benefits

(1)

Summary

(1)

Key Terms

(1)

Review Questions

(1)

Exercises

(2)

Website References

(1)

Additional Reading

(1)

PART ONE SYSTEMS DESIGN

(114)

Database Design

(47)

A Developer's View

(1)

Introduction

(1)

Getting Started

(1)

Designing Databases

(4)

Identifying User Requirements

(1)

Business Objects

(1)

Tables and Relationships

(1)

Definitions

(1)

Primary Key

(1)

Class Diagrams

(10)

Classes and Entities

(1)

Associations and Relationships

(1)

Class Diagram Details

(8)

Sally's Pet Store Class Diagram

(2)

Data Types (Domains)

(4)

Text

(1)

Numbers

(1)

Dates and Times

(1)

Binary Objects

(1)

Computed Values

(1)

User-Defined Types (Domains/Objects)

(1)

Events

(2)

Large Projects

(1)

Rolling Thunder Bicycles

(5)

Application Design

(1)

Summary

(1)

Key Terms

(1)

Review Questions

(1)

Exercises

(5)

Website References

(1)

Additional Reading

(1)

Appendix: Database Design System

(7)

Sample Problem: Customer Orders

(1)

Getting Started: Identifying Columns

(1)

Creating a Table and Adding Columns

(2)

Relationships: Connecting Tables

(1)

Grading: Detecting and Solving Problems

(3)

Specifying Data Types

(1)

Data Normalization

(66)

A Developer's View

(1)

Introduction

(1)

Tables, Classes, and Keys

(4)

Composite Keys

(1)

Surrogate Keys

(1)

Notation

(2)

Sample Database for a Video Store

(6)

Initial Objects

(1)

Initial Form Evaluation

(2)

Problems with Repeating Sections

(2)

First Normal Form

(2)

Repeating Groups

(1)

Nested Repeating Groups

(1)

Second Normal Form

(3)

Problems with First Normal Form

(1)

Second Normal Form Definition

(1)

Dependence

(1)

Third Normal Form

(4)

Problems with Second Normal Form

(1)

Third Normal Form Definition

(2)

Checking Your Work

(1)

Beyond Third Normal Form

(4)

Boyce-Codd Normal Form

(1)

Fourth Normal Form

(1)

Domain-Key Normal Form

100

(2)

Data Rules and Integrity

102

(2)

The Effects of Business Rules

104

(2)

Converting a Class Diagram to Normalized Tables

106

(6)

One-to-Many Relationships

106

(2)

Many-to-Many Relationships

108

(1)

N-ary Associations

108

(1)

Generalization or Subtypes

108

(2)

Composition

110

(1)

Reflexive Associations

111

(1)

Summary

112

(1)

Sally's Pet Store Example

112

(3)

View Integration

115

(8)

Sally's Pet Store Example

115

(2)

Rolling Thunder Sample Integration Problem

117

(6)

Data Dictionary

123

(6)

DBMS Table Definition

123

(4)

Data Volume and Usage

127

(2)

Summary

129

(1)

Key Terms

130

(1)

Review Questions

130

(1)

Exercises

131

(7)

Website References

138

(1)

Additional Reading

138

(1)

Appendix: Formal Definitions of Normalization

139

(4)

Initial Definitions

139

(1)

Normal Form Definitions

140

(3)

PART TWO QUERIES

143

(78)

Data Queries

144

(38)

A Developer's View

145

(1)

Introduction

145

(1)

Three Tasks of a Query Language

146

(1)

Four Questions to Retrieve Data

146

(2)

What Output Do You Want to See?

147

(1)

What Do You Already Know?

147

(1)

What Tables Are Involved?

147

(1)

How Are the Tables Joined?

147

(1)

Sally's Pet Store

148

(1)

Vendor Differences

149

(1)

Query Basics

149

(10)

Single Tables

149

(2)

Introduction to SQL

151

(1)

Sorting the Output

151

(1)

Distinct

152

(1)

Criteria

153

(1)

Boolean Algebra

154

(1)

DeMorgan's Law

155

(3)

Useful Where Clauses

158

(1)

Computations

159

(4)

Basic Arithmetic Operators

159

(1)

Aggregation

159

(3)

Functions

162

(1)

Subtotals and Group By

163

(3)

Conditions on Totals (Having)

164

(1)

Where versus Having

165

(1)

The Best and the Worst

166

(1)

Multiple Tables

166

(8)

Joining Tables

167

(1)

Identifying Columns in Different Tables

168

(1)

Joining Many Tables

169

(1)

Hints on Joining Tables

170

(2)

Table Alias

172

(1)

Create View

172

(2)

Summary

174

(1)

Key Terms

175

(1)

Review Questions

175

(1)

Exercises

175

(3)

Website References

178

(1)

Additional Reading

178

(1)

Appendix: SQL Syntax

179

(3)

Alter Table

179

(1)

Commit Work

179

(1)

Create Index

179

(1)

Create Table

179

(1)

Create Trigger

179

(1)

Create View

180

(1)

Delete

180

(1)

Drop

180

(1)

Insert

180

(1)

Grant

180

(1)

Revoke

180

(1)

Rollback

181

(1)

Select

181

(1)

Select Into

181

(1)

Update

181

(1)

Advanced Queries and Subqueries

182

(39)

A Developer's View

183

(1)

Introduction

183

(1)

Sally's Pet Store

184

(1)

Subqueries

184

(3)

Calculations or Simple Lookup

184

(1)

Subqueries and Sets of Data

185

(1)

Subquery with Any and All

185

(2)

Subtraction: Not In

187

(1)

Outer Joins

188

(2)

Correlated Subqueries Are Dangerous

190

(3)

More Features and Tricks with SQL Select

193

(6)

Union, Intersect, Except

193

(1)

Multiple Join Columns

194

(1)

Reflexive Join

195

(1)

Case Function

196

(1)

Inequality Joins

197

(1)

Questions with ``Every'' Need the Exists Clause

197

(2)

SQL Select Summary

199

(1)

SQL Data Definition Commands

199

(2)

SQL Data Manipulation Commands

201

(2)

Insert and Delete

201

(1)

Update

202

(1)

Quality: Testing Queries

203

(2)

Summary

205

(1)

Key Terms

206

(1)

Review Questions

206

(1)

Exercises

206

(4)

Website References

210

(1)

Additional Reading

210

(1)

Appendix: Introduction to Programming

211

(10)

Variables and Data

211

(1)

Variable Scope

212

(1)

Computations

213

(1)

Standard Internal Functions

214

(1)

Input and Output

215

(1)

Conditions

216

(1)

Loops

217

(1)

Subroutines

218

(2)

Summary

220

(1)

PART THREE APPLICATIONS

221

(108)

Forms, Reports, and Applications

222

(43)

A Developer's View

223

(1)

Introduction

223

(1)

Effective Design of Reports and Forms

224

(6)

Human Factors Design

224

(2)

Window Controls

226

(2)

User Interface---Web Notes

228

(1)

User Interface---Accessibility Issues

229

(1)

Form Layout

230

(5)

Tabular Forms

230

(1)

Single-Row or Columnar-Forms

231

(1)

Subform Forms

232

(1)

Switchboard Forms

233

(2)

Creating Forms

235

(10)

Updateable Queries

235

(1)

Linked Forms

236

(1)

Properties and Controls

236

(1)

Controls on Forms

237

(4)

Multiple Forms

241

(2)

International Attributes

243

(2)

Direct Manipulation of Graphical Objects

245

(2)

Sally's Pet Store Example

245

(1)

The Internet

246

(1)

Complications and Limitations of a Graphical Approach

247

(1)

Reports

247

(8)

Report Design

248

(1)

Terminology

248

(2)

Basic Report Types

250

(4)

Graphs

254

(1)

Application Features

255

(6)

Menus and Toolbars

255

(2)

Custom Help

257

(4)

Summary

261

(1)

Key Terms

262

(1)

Review Questions

262

(1)

Exercises

262

(2)

Website References

264

(1)

Additional Reading

264

(1)

Database Integrity and Transactions

265

(33)

A Developer's View

266

(1)

Introduction

266

(1)

Procedural Languages

266

(3)

Where Should Code Be Located?

267

(1)

User-Defined Functions

268

(1)

Looking Up Data

269

(1)

Data Triggers

269

(5)

Statement versus Row Triggers

270

(1)

Canceling Data Changes in Triggers

271

(1)

Cascading Triggers

272

(1)

Instead of Triggers

273

(1)

Transactions

274

(2)

A Transaction Example

274

(1)

Starting and Ending Transactions

274

(2)

Savepoint

276

(1)

Multiple Users and Concurrent Access

276

(5)

Pessimistic Locks: Serialization

277

(1)

Multiuser Databases: Concurrent Access and Deadlock

278

(2)

Optimistic Locks

280

(1)

ACID Transactions

281

(2)

Key Generation

283

(2)

Database Cursors

285

(4)

Cursor Basics

285

(1)

Scrollable Cursors

286

(1)

Changing or Deleting Data with Cursors

287

(1)

Cursors with Parameters

288

(1)

Merchandise Inventory at Sally's Pet Store

289

(4)

Summary

293

(1)

Key Terms

294

(1)

Review Questions

294

(1)

Exercises

294

(2)

Website References

296

(1)

Additional Reading

297

(1)

Data Warehouses and Data Mining

298

(31)

A Developer's View

299

(1)

Introduction

299

(1)

Indexes

300

(3)

Binary Search

300

(1)

Pointers and Indexes

301

(1)

Bitmap Index and Statistics

301

(1)

Problems with Indexes

302

(1)

Data Warehouses and Online Analytical Processing

303

(3)

Data Warehouse Goals

303

(2)

Data Warehouse Issues

305

(1)

Olap Concepts

306

(2)

Olap Database Design

308

(10)

Olap Data Analysis

310

(2)

Olap in SQL

312

(4)

SQL Analytic Functions

316

(1)

SQL Olap Windows

316

(2)

Data Mining

318

(7)

Classification

320

(1)

Association Rules/Market Basket Analysis

321

(2)

Cluster Analysis

323

(1)

Geographic Analysis

324

(1)

Summary

325

(1)

Key Terms

326

(1)

Review Questions

326

(1)

Exercises

326

(1)

Website References

327

(1)

Additional Reading

328

(1)

PART FOUR DATABASE ADMINISTRATION

329

(66)

Database Administration

330

(30)

A Developer's View

331

(1)

Introduction

331

(1)

Data Administrator

332

(1)

Database Administrator

333

(1)

Database Structure

334

(1)

Metadata

335

(1)

Database Tasks by Development Stages

336

(3)

Database Planning

336

(1)

Database Design

337

(1)

Database Implementation

338

(1)

Database Operation and Maintenance

338

(1)

Backup and Recovery

339

(2)

Security and Privacy

341

(10)

Data Privacy

341

(1)

Threats

342

(1)

Physical Security

342

(2)

Managerial Controls

344

(1)

Logical Security

344

(5)

Division of Duties

349

(1)

Software Updates

350

(1)

Encryption

351

(2)

Sally's Pet Store

353

(2)

Summary

355

(1)

Key Terms

356

(1)

Review Questions

356

(1)

Exercises

357

(2)

Website References

359

(1)

Additional Reading

359

(1)

Distributed Databases and the Internet

360

(35)

A Developer's View

361

(1)

Introduction

361

(1)

Sally's Pet Store

361

(1)

Distributed Databases

362

(11)

Goals and Rules

363

(1)

Advantages and Applications

364

(2)

Creating a Distributed Database System

366

(1)

Distributed Query Processing

367

(2)

Data Replication

369

(1)

Concurrency, Locks, and Transactions

370

(2)

Independent Transaction Managers

372

(1)

Distributed Design Questions

372

(1)

Client/Server Databases

373

(7)

Client/Server versus File Server

374

(1)

Three-Tier Client/Server Model

375

(2)

The Back End: Server Databases

377

(1)

The Front End: Windows Clients

377

(1)

Maintaining Database Independence in the Client

378

(2)

Electronic Commerce Databases

380

(1)

The Web as a Client/Server System

381

(4)

HTML-Limited Clients

381

(2)

Web Server Database Fundamentals

383

(2)

Data Transmission Issues in Applications

385

(2)

XML: Transferring Data to Diverse Systems

387

(4)

Java and JDBC

391

(1)

Summary

392

(1)

Key Terms

393

(1)

Review Questions

393

(1)

Exercises

394

(1)

Website References

395

(1)

Additional Reading

396

Amazon no longer offers textbook rentals. We do!

Database Management Systems-Designing & Building Business Applications

Database Management Systems-Designing & Building Business Applications

9780072973129

0072973129

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review