Modern Database Management,9780805360547

This item qualifies for
FREE SHIPPING!

Modern Database Management

by McFadden, Fred R.; Hoffer, Jeffrey A.; Prescott, Mary B.

ISBN13:

9780805360547

ISBN10:

0805360549

Format:

Hardcover

Pub. Date:

8/1/1998

Publisher(s):

Pearson College Div

Upgraded Edition: Click here!

Other versions by this Author

List Price: ~~$95.00~~

More New and Used
from Private Sellers

Starting at $0.01

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

Summary

For Introductory courses in Database Management. Modern Database Management, 5/e is the ideal book for your database management course. While sufficient technical detail is provided, the emphasis remains on management and implementation issues pertinent in a business information systems curriculum. When used in tandem with Modern Systems Analysis and Design, 2/e by Jeffrey A. Hoffer, Joey F. George, and Joseph S. Valacich (1999-Addison Wesley Longman), students can follow a common systems development framework in the SA&D and database sequence.

Preface

xix

Part I The Context of Database Management

(82)

PART I OVERVIEW

(1)

Chapter 1 The Database Environment

(34)

Learning Objectives

(1)

Introduction

(1)

Basic Concepts and Definitions

(3)

Data

(1)

Data versus Information

(1)

Metadata

(2)

Traditional File Processing Systems

(3)

File Processing Systems at Pine Valley Furniture Company

(1)

Disadvantages of File Processing Systems

(1)

Program-Data Dependence

(1)

Duplication of Data

(1)

Limited Data Sharing

(1)

Lengthy Development Times

(1)

Excessive Program Maintenance

(1)

The Database Approach

(5)

The Database Approach at Pine Valley Furniture Company

(1)

Enterprise Data Model

(1)

Relational Databases

(2)

Implementing the Relational Database

(1)

A Database Application

(1)

The Range of Database Applications

(5)

Personal Computer Databases

(1)

Workgroup Databases

(2)

Department Databases

(1)

Enterprise Databases

(1)

Summary of Databases Applications

(1)

Advantages of the Database Approach

(4)

Program-Data Independence

(1)

Minimal Data Redundancy

(1)

Improved Data Consistency

(1)

Improved Data Sharing

(1)

Increased Productivity of Application Development

(1)

Enforcement of Standards

(1)

Improved Data Quality

(1)

Improved Data Accessibility and Responsiveness

(1)

Reduced Program Maintenance

(1)

Cautions About Database Benefits

(1)

Costs and Risks of the Database Approach

(1)

New, Specialized Personnel

(1)

Installation and Management Cost and Complexity

(1)

Conversion Costs

(1)

Need for Explicit Backup and Recovery

(1)

Organizational Conflict

(1)

Components of the Database Environment

(2)

Evolution of Database Systems

(2)

1960s

(1)

1970s

(1)

1980s

(1)

1990s

(1)

2000 and Beyond

(1)

Summary

(1)

Chapter Review

(5)

Key Terms

(1)

Review Questions

(1)

Problems and Exercises

(2)

Field Exercises

(1)

References

(1)

Further Reading

(1)

Project Case: Mountain View Community Hospital

(2)

Chapter 2 Database Development Process

(46)

Learning Objectives

(1)

Introduction

(1)

Database Development Within Information Systems Development

(6)

Information Systems Architecture

(1)

Information Engineering

(1)

Information Systems Planning

(1)

Identifying Strategic Planning Factors

(1)

Identifying Corporate Planning Objects

(1)

Developing an Enterprise Model

(3)

Database Development Process

(7)

Systems Development Life Cycle

(1)

Enterprise Modeling

(1)

Conceptual Data Modeling

(1)

Logical Database Design

(1)

Physical Database Design and Creation

(1)

Database Implementation

(1)

Database Maintenance

(1)

Alternative IS Development Approaches

(2)

The Role of CASE and a Repository

(1)

Managing the People Involved in Database Development

(2)

Three-Schema Architecture for Database Development

(3)

Three-Tiered Database Location Architecture

(2)

Developing a Database Application for Pine Valley Furniture

(12)

Matching User Needs to the Information Systems Architecture

(2)

Analyzing Database Requirements

(3)

Designing the Database

(3)

Using a Database

(2)

Administering a Database

(1)

Summary

(1)

Chapter Review

(6)

Key Terms

(1)

Review Questions

(1)

Problems and Exercises

(3)

Field Exercises

(1)

References

(1)

Further Reading

(1)

Project Case: Mountain View Community Hospital

(6)

Part II Database Analysis

(122)

PART II OVERVIEW

(1)

Chapter 3 The Entity-Relationship Model

(44)

Learning Objectives

(1)

Introduction

(2)

The E-R Model

(2)

Sample E-R Diagram

(2)

E-R Model Notation

(1)

Entity-Relationship Model Constructs

(2)

Entities

(2)

Entity Type Versus Entity Instance

(1)

Entity Type Versus System Input, Output, or User

(6)

Strong Versus Weak Entity Types

(1)

Attributes

(1)

Simple Versus Composite Attributes

(1)

Single-Valued Versus Multivalued Attributes

(1)

Stored Versus Derived Attributes

(2)

Relationships

(14)

Basic Concepts and Definitions in Relationships

(1)

Attributes on Relationships

(1)

Associative Entities

(2)

Degree of a Relationship

101

(1)

Unary Relationship

101

(3)

Binary Relationship

104

(1)

Ternary Relationship

104

(1)

Cardinality Constraints

105

(1)

Minimum Cardinality

106

(1)

Maximum Cardinality

106

(1)

Some Examples

106

(1)

A Ternary Relationship

107

(1)

Modeling Time-Dependent Data

107

(3)

Multiple Relationships

110

(1)

E-R Modeling Example: Pine Valley Furniture Company

111

(3)

Database Processing at Pine Valley Furniture

114

(3)

Showing Product Information

114

(1)

Showing Customer Information

115

(1)

Showing Customer Order Status

115

(2)

Showing Product Sales

117

(1)

Summary

117

(1)

Chapter Review

118

(8)

Key Terms

118

(1)

Review Questions

119

(1)

Problems and Exercises

119

(5)

Field Exercises

124

(1)

References

124

(1)

Further Reading

125

(1)

Project Case: Mountain View Community Hospital

126

(3)

Chapter 4 The Enhanced E-R Model and Business Rules

129

(38)

Learning Objectives

129

(1)

Introduction

129

(1)

Representing Supertypes and Subtypes

130

(7)

Basic Concepts and Notation

130

(1)

An Example

131

(2)

Attribute Inheritance

133

(1)

When to Use Supertype/Subtype Relationships

133

(1)

Representing Specialization and Generalization

133

(1)

Generalization

133

(3)

Specialization

136

(1)

Combining Specialization and Generalization

137

(1)

Specifying Constraints in Supertype/Subtype Relationships

137

(8)

Specifying Completeness Constraints

137

(1)

Total Specialization Rule

138

(1)

Partial Specialization Rule

138

(1)

Specifying Disjointness Constraints

138

(1)

Disjoint Rule

139

(1)

Overlap Rule

139

(2)

Defining Subtype Discriminators

141

(1)

Disjoint Subtypes

141

(1)

Overlapping Subtypes

142

(1)

Defining Supertype/Subtype Hierarchies

143

(1)

An Example

143

(2)

Summary of Supertype/Subtype Hierarchies

145

(1)

Business Rules: An Overview

145

(3)

The Business Rules Paradigm

146

(1)

Scope of Business Rules

146

(1)

Classification of Business Rules

147

(1)

Business Rules: Defining Structural Constraints

148

(6)

Definitions

148

(1)

Facts

148

(1)

Derived Facts

149

(1)

Definitions for Data Model

150

(1)

Importance of Precise Definitions

150

(3)

Domain Constraints

153

(1)

Business Rules: Defining Operational Constraints

154

(5)

Declarative Approach to Business Rules

154

(1)

Constraint Specification Language

155

(1)

Constrained Objects and Constraining Objects

155

(1)

Sample Business Rules

156

(3)

Summary

159

(1)

Chapter Review

160

(5)

Key Terms

160

(1)

Review Questions

160

(1)

Problems and Exercises

161

(2)

Field Exercises

163

(1)

References

164

(1)

Further Reading

164

(1)

Project Case: Mountain View Community Hospital

165

(2)

Chapter 5 Object-Oriented Modeling

167

(38)

Learning Objectives

167

(1)

Introduction

167

(3)

The Unified Modeling Language

170

(1)

Object-Oriented Modeling

171

(20)

Representing Objects and Classes

171

(2)

Types of Operations

173

(1)

Representing Associations

174

(3)

Representing Association Classes

177

(3)

Representing Derived Attributes, Derived Associations, and Derived Roles

180

(1)

Representing Generalization

181

(5)

Interpreting Inheritance and Overriding

186

(1)

Representing Multiple Inheritance

187

(1)

Representing Aggregation

187

(4)

Business Rules

191

(1)

Object Modeling Example: Pine Valley Furniture Company

191

(3)

Summary

194

(1)

Chapter Review

195

(7)

Key Terms

195

(1)

Review Questions

196

(1)

Problems and Exercises

197

(4)

Field Exercises

201

(1)

References

201

(1)

Project Case: Mountain View Community Hospital

202

(3)

Part III Database Design

205

(90)

PART III OVERVIEW

206

(1)

Chapter 6 Logical Database Design and the Relational Model

207

(46)

Learning Objectives

207

(1)

Introduction

207

(1)

The Relational Data Model

208

(5)

Basic Definitions

208

(1)

Relational Data Structure

209

(1)

Relational Keys

209

(1)

Properties of Relations

210

(1)

Removing Multivalued Attributes from Tables

210

(1)

Example Database

211

(2)

Integrity Constraints

213

(5)

Domain Constraints

213

(1)

Entity Integrity

213

(1)

Referential Integrity

214

(1)

Operational Constraints

215

(1)

Creating Relational Tables

215

(2)

Well-Structured Relations

217

(1)

Transforming EER Diagrams into Relations

218

(14)

Step 1: Map Regular Entities

219

(1)

Composite Attributes

219

(1)

Multivalued Attributes

220

(1)

Step 2: Map Weak Entities

221

(1)

Step 3: Map Binary Relationships

222

(1)

Map Binary One-to-Many Relationships

222

(1)

Map Binary Many-to-Many Relationships

223

(1)

Map Binary One-to-One Relationships

224

(1)

Step 4: Map Associative Entities

224

(1)

Identifier Not Assigned

224

(1)

Identifier Assigned

225

(2)

Step 5: Map Unary Relationships

227

(1)

Unary One-to-Many Relationships

227

(1)

Unary Many-to-Many Relationships

228

(1)

Step 6: Map Ternary (and n-ary) Relationships

229

(2)

Step 7: Map Supertype/Subtype Relationships

231

(1)

Introduction to Normalization

232

(5)

Steps in Normalization

233

(2)

Functional Dependencies and Keys

235

(1)

Determinants

235

(1)

Candidate Keys

235

(2)

The Basic Normal Forms

237

(4)

First Normal Form

237

(1)

Second Normal Form

237

(1)

Third Normal Form

238

(3)

Normalizing Summary Data

241

(1)

Merging Relations

241

(2)

An Example

241

(1)

View Integration Problems

241

(1)

Synonyms

242

(1)

Homonyms

242

(1)

Transitive Dependencies

242

(1)

Supertype/Subtype Relationships

243

(1)

Summary

243

(1)

Chapter Review

244

(7)

Key Terms

244

(1)

Review Questions

244

(1)

Problems and Exercises

245

(4)

Field Exercises

249

(1)

References

250

(1)

Further Reading

250

(1)

Project Case: Mountain View Community Hospital

251

(2)

Chapter 7 Physical Database Design

253

(42)

Learning Objectives

253

(1)

Introduction

253

(1)

Physical Database Design Process

254

(3)

Data Volume and Usage Analysis

255

(2)

Designing Fields

257

(3)

Choosing Data Types

257

(1)

Coding and Compression Techniques

257

(2)

Controlling Data Integrity

259

(1)

Handling Missing Data

260

(1)

Designing Physical Records and Denormalization

260

(7)

Handling Fixed-Length Fields

261

(1)

Handling Variable-Length Fields

261

(1)

Denormalization

261

(6)

Designing Physical Files

267

(7)

Pointer

267

(1)

Access Methods

267

(1)

File Organizations

268

(1)

Sequential File Organizations

268

(1)

Indexed File Organizations

268

(4)

Hashed File Organizations

272

(1)

Summary of File Organizations

272

(1)

Clustering Files

272

(2)

Designing Controls for Files

274

(1)

Using and Selecting Indexes

274

(2)

Creating a Primary Key Index

274

(1)

Creating a Secondary Key Index

275

(1)

When to Use Indexes

275

(1)

RAID: Improving File Access Performance by Parallel Processing

276

(6)

Choosing Among RAID Levels

278

(1)

RAID-0

278

(1)

RAID-1

278

(3)

RAID-2

281

(1)

RAID-3

281

(1)

RAID-4

281

(1)

RAID-5

281

(1)

RAID Performance

281

(1)

Designing Databases

282

(3)

Choosing Database Architectures

282

(3)

Optimizing for Query Performance

285

(1)

Summary

286

(2)

Chapter Review

288

(5)

Key Terms

288

(1)

Review Questions

288

(1)

Problems and Exercises

289

(2)

Field Exercises

291

(1)

References

292

(1)

Further Reading

292

(1)

Project Case: Mountain View Community Hospital

293

(2)

Part IV Implementation

295

(186)

PART IV OVERVIEW

296

(1)

Chapter 8 Client/Server and Middleware

297

(26)

Learning Objectives

297

(1)

Introduction

297

(1)

Client/Server Architectures

298

(4)

File Server Architectures

299

(1)

Limitations of File Servers

300

(1)

Database Server Architectures

301

(1)

Three-Tier Architectures

302

(2)

Partitioning an Application

304

(1)

Role of the Mainframe

305

(1)

Using Parallel Computer Architectures

306

(3)

Multiprocessor Hardware Architectures

307

(1)

Business Related Uses of SMP and MPP Architectures

308

(1)

Using Middleware

309

(2)

Establishing Client/Server Security

311

(1)

Client/Server Issues

312

(2)

Summary

314

(1)

Chapter Review

315

(4)

Key Terms

315

(1)

Review Questions

316

(1)

Problems and Exercises

316

(1)

Field Exercises

317

(1)

References

318

(1)

Project Case: Mountain View Community Hospital

319

(4)

Chapter 9 SQL

323

(58)

Learning Objectives

323

(1)

Introduction

323

(1)

History of the SQL Standard

324

(1)

The Role of SQL in a Database Architecture

325

(2)

The SQL Environment

327

(4)

Defining a Database in SQL

331

(6)

Generating SQL Database Definitions

332

(1)

Creating Tables

332

(2)

Creating Data Integrity Controls

334

(2)

Changing Table Definitions

336

(1)

Removing Tables

336

(1)

Establishing Synonyms

336

(1)

Inserting, Updating, and Deleting Data

337

(1)

Batch Input

337

(1)

Deleting Database Contents

338

(1)

Changing Database Contents

338

(1)

Internal Schema Definition in RDBMSs

338

(2)

Creating Indexes

339

(1)

Processing Single Tables

340

(14)

Clauses of the SELECT Statement

340

(2)

Using Expressions

342

(1)

Using Functions

343

(2)

Using Wildcards

345

(1)

Comparison Operators

345

(1)

Using Boolean Operators

346

(1)

Ranges

347

(1)

Distinct

348

(2)

IN and NOT IN Lists

350

(1)

Sorting Results: The ORDER BY Clause

350

(1)

Categorizing Results: The GROUP BY Clause

351

(1)

Qualifying Results by Categories: The HAVING Clause

352

(2)

Processing Multiple Tables

354

(9)

Equi-join

354

(1)

Natural Join

355

(1)

Outer Join

356

(2)

Subqueries

358

(3)

Correlated Subqueries

361

(2)

View Definitions

363

(3)

Ensuring Transaction Integrity

366

(2)

Data Dictionary Facilities

368

(1)

Triggers and Procedures

369

(2)

SQL3

371

(1)

Summary

372

(1)

Chapter Review

373

(7)

Key Terms

373

(1)

Review Questions

373

(1)

Problems and Exercises

374

(3)

Field Exercises

377

(1)

References

378

(1)

Web Site References

378

(1)

Further Reading

379

(1)

Project Case: Mountain View Community Hospital

380

(1)

Chapter 10 Database Access from Client Applications

381

(36)

Learning Objectives

381

(1)

Introduction

381

(1)

Survey of Desktop Database Technology

382

(1)

Using Query-by-Example

383

(13)

The History and Importance of QBE

384

(1)

QBE: The Basics

384

(2)

Database Definition

386

(1)

Relationships

387

(1)

Building Queries Using QBE

388

(1)

Single-Table Queries

388

(2)

Selecting Qualified Records

390

(1)

Multiple-Table Queries

390

(2)

Self-Join

392

(1)

Basing a Query on Another Query

393

(1)

Access97 Query Types

394

(2)

Building a Client Application

396

(5)

Application Menus

396

(1)

Form Development

397

(2)

Report Development

399

(2)

Using OLE, COM, and ActiveX Controls for Database Access

401

(2)

Embedding SQL in Programs

403

(3)

Using Visual Basic for Applications (VBA) in Client Applications

406

(1)

Building Internet Database Servers

407

(2)

Summary

409

(1)

Chapter Review

410

(5)

Key Terms

410

(1)

Review Questions

410

(1)

Problems and Exercises

411

(2)

Field Exercises

413

(1)

References

414

(1)

Project Case: Mountain View Community Hospital

415

(2)

Chapter 11 Distributed Databases

417

(36)

Learning Objectives

417

(1)

Introduction

417

(5)

Objectives and Trade-offs

421

(1)

Options for Distributing a Database

422

(9)

Data Replication

423

(1)

Snapshot Replication

424

(1)

Near Real-Time Replication

425

(1)

Pull Replication

425

(1)

Database Integrity with Replication

425

(1)

When to Use Replication

426

(1)

Horizontal Partitioning

426

(1)

Vertical Partitioning

427

(2)

Combinations of Operations

429

(1)

Selecting the Right Data Distribution Strategy

430

(1)

Distributed DBMS

431

(11)

Location Transparency

433

(1)

Replication Transparency

434

(1)

Failure Transparency

435

(1)

Commit Protocol

435

(1)

Concurrency Transparency

436

(1)

Timestamping

437

(1)

Query Optimization

437

(3)

Evolution of Distributed DBMS

440

(1)

Remote Unit of Work

440

(1)

Distributed Unit of Work

441

(1)

Distributed Request

441

(1)

Distributed DBMS Products

442

(3)

IBM Corporation and DB2

442

(1)

Sybase Inc.

443

(1)

Oracle Corporation

444

(1)

Computer Associates International and Ingres

444

(1)

Microsoft Corporation and SQL Server

445

(1)

Summary

445

(2)

Chapter Review

447

(5)

Key Terms

447

(1)

Review Questions

447

(1)

Problems and Exercises

448

(2)

Field Exercises

450

(1)

References

451

(1)

Project Case: Mountain View Community Hospital

452

(1)

Chapter 12 Object-Oriented Database Development

453

(28)

Learning Objectives

453

(1)

Introduction

453

(1)

Object Definition Language

454

(12)

Defining a Class

454

(1)

Defining an Attribute

455

(1)

Defining User Structures

456

(1)

Defining Operations

456

(1)

Defining a Range for an Attribute

457

(1)

Defining Relationships

457

(2)

Defining an Attribute with an Object Identifier as Its Value

459

(1)

Defining Many-to-Many Relationships, Keys, and Multivalued Attributes

460

(2)

Defining Generalization

462

(2)

Defining an Abstract Class

464

(2)

Defining Other User Structures

464

(2)

OODB Design for Pine Valley Furniture Company

466

(1)

Creating Object Instances

467

(1)

Object Query Language

468

(6)

Basic Retrieval Command

469

(1)

Including Operations in Select Clause

469

(1)

Finding Distinct Values

470

(1)

Querying Multiple Classes

470

(1)

Writing Subqueries

471

(1)

Calculating Summary Values

471

(1)

Calculating Group Summary Values

472

(1)

Qualifying Groups

472

(1)

Using a Set in a Query

473

(1)

Current ODBMS Products and Their Applications

474

(1)

Summary

474

(1)

Chapter Review

475

(4)

Key Terms

475

(1)

Review Questions

476

(1)

Problems and Exercises

476

(1)

Field Exercises

477

(1)

References

478

(1)

Project Case: Mountain View Community Hospital

479

(2)

Part V Data Administration

481

(92)

PART V OVERVIEW

482

(1)

Chapter 13 Data and Database Administration

483

(46)

Learning Objectives

483

(1)

Introduction

483

(1)

The Changing Roles of Data and Database Administrators

484

(6)

Data Administration

484

(1)

Database Administration

485

(3)

Changing Approaches to Data Administration

488

(2)

Modeling Enterprise Data

490

(1)

Planning for Databases

491

(1)

Managing Data Security

492

(6)

Threats to Data Security

492

(2)

Views

494

(1)

Authorization Rules

495

(2)

User-Defined Procedures

497

(1)

Encryption

497

(1)

Authentication Schemes

497

(1)

Backing Up Database

498

(7)

Basic Recovery Facilities

499

(1)

Backup Facilities

499

(1)

Journalizing Facilities

499

(1)

Checkpoint Facility

500

(1)

Recovery Manager

500

(1)

Recovery and Restart Procedures

500

(1)

Switch

501

(1)

Restore/Rerun

501

(1)

Transaction Integrity

501

(1)

Backward Recovery

502

(1)

Forward Recovery

503

(1)

Types of Database Failure

503

(1)

Aborted Transactions

503

(1)

Incorrect Data

504

(1)

System Failure

504

(1)

Database Destruction

505

(1)

Controlling Concurrent Access

505

(6)

The Problem of Lost Updates

505

(1)

Serializability

506

(1)

Locking Mechanisms

507

(1)

Locking Level

507

(1)

Types of Locks

508

(1)

Deadlock

508

(2)

Managing Deadlock

510

(1)

Versioning

510

(1)

Managing Data Quality

511

(3)

Security Policy and Disaster Recovery

512

(1)

Personnel Controls

513

(1)

Physical Access Controls

513

(1)

Maintenance Controls

514

(1)

Data Protection and Privacy

514

(1)

Data Dictionaries and Repositories

514

(2)

Repositories

515

(1)

Overview of Tuning the Database for Performance

516

(3)

Installation of the DBMS

517

(1)

Memory Usage

517

(1)

Input/Output (I/O) Contention

518

(1)

CPU Usage

518

(1)

Application Tuning

518

(1)

Summary

519

(1)

Chapter Review

520

(7)

Key Terms

520

(1)

Review Questions

520

(2)

Problems and Exercises

522

(3)

Field Exercises

525

(1)

References

525

(2)

Project Case: Mountain View Community Hospital

527

(2)

Chapter 14 Data Warehouse

529

(44)

Learning Objectives

529

(1)

Introduction

529

(2)

Basic Concepts of Data Warehousing

531

(3)

A Brief History

531

(1)

The Need for Data Warehousing

532

(1)

Need for a Company-Wide View

532

(1)

Need to Separate Operational and Information Systems

533

(1)

Data Warehouse Architectures

534

(4)

Generic Two-Level Architecture

534

(1)

An Expanded Data Warehouse Architecture

534

(3)

Three-Layer Data Architecture

537

(1)

Role of the Enterprise Data Model

537

(1)

Role of Metadata

537

(1)

Some Data Characteristics

538

(4)

Status versus Event Data

538

(1)

Transient versus Periodic Data

539

(1)

An Example of Transient and Periodic Data

540

(1)

Transient Data

541

(1)

Periodic Data

542

(1)

The Reconciled Data Layer

542

(4)

Characteristics of Reconciled Data

543

(1)

The Data Reconciliation Process

543

(1)

Capture

544

(1)

Scrub

544

(1)

Load and Index

545

(1)

Data Transformation

546

(5)

Data Transformation Functions

547

(1)

Record-Level Functions

547

(1)

Field-Level Functions

548

(2)

More Complex Transformations

550

(1)

Tools to Support Data Reconciliation

550

(1)

Data Quality Tools

550

(1)

Data Conversion Tools

550

(1)

Data-Cleansing Tools

550

(1)

The Derived Data Layer

551

(8)

Characteristics of Derived Data

551

(1)

The Star Schema

552

(1)

Fact Tables and Dimension Tables

552

(1)

Example Star Schema

552

(2)

Grain of a Fact Table

554

(1)

Size of the Fact Table

554

(2)

Variations of the Star Schema

556

(1)

Multiple Fact Tables

556

(1)

Snowflake Schema

556

(1)

Proprietary Database

557

(1)

Independent versus Dependent Data Marts

558

(1)

The User Interface

559

(4)

Role of Metadata

559

(1)

On-Line Analytical Processing (OLAP) Tools

560

(1)

Slicing a Cube

561

(1)

Drill-Down

561

(1)

Data-Mining Tools

562

(1)

Data-Mining Techniques

562

(1)

Data-Mining Applications

562

(1)

Data Visualization

563

(1)

Summary

563

(2)

Chapter Review

565

(5)

Key Terms

565

(1)

Review Questions

565

(1)

Problems and Exercises

566

(2)

Field Exercises

568

(1)

References

568

(1)

Further Reading

569

(1)

Project Case: Mountain View Community Hospital

570

(3)

Appendix A Object-Relational Databases

573

(6)

Basic Concepts and Definitions

573

(2)

Features of an ORDBMS

574

(1)

Complex Data Types

574

(1)

Enhanced SQL

575

(1)

A Simple Example

575

(1)

Content Addressing

576

(1)

Advantages of the Object-Relational Approach

576

(1)

ORDBMS Vendors and Products

577

(1)

References

577

(2)

Appendix B Advanced Normal Forms

579

(6)

Boyce-Codd Normal Form

579

(3)

Anomalies in STUDENT_ADVISOR

579

(1)

Definition of Boyce-Codd Normal Form (BCNF)

580

(1)

Converting a Relation to BCNF

580

(2)

Fourth Normal Form

582

(2)

Multivalued Dependencies

583

(1)

Higher Normal Forms

584

(1)

References

584

(1)

Appendix C Data Structures

585

(14)

Pointers

585

(2)

Data Structure Building Blocks

587

(2)

Linear Data Structures

589

(5)

Stacks

590

(1)

Queues

590

(1)

Sorted Lists

591

(2)

Multilists

593

(1)

Hazards of Chain Structures

594

(1)

Trees

594

(4)

Balanced Trees

595

(3)

References

598

(1)

Glossary of Terms

599

(12)

Glossary of Acronyms

611

(2)

Index

613

FREE SHIPPING OVER $59!

Modern Database Management

9780805360547

Rent Textbook

Used Textbook

eTextbook

New Textbook

Related Products

Summary

Table of Contents