Database Development and Management

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

ISBN: 9780849333187 | 0849333180
Cover: Hardcover
Copyright: 1/13/2006

Rent

(Recommended)

$94.09

Term

Due

Price

Semester

Aug 2

$104.55

Quarter

Jul 18

$99.32

Short Term

Jun 7

$94.09

*This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.
Buy New

Usually Ships in 3-5 Business Days

$142.84
eBook

Available Instantly

Online: 180 Days

Downloadable: 180 Days

$99.00

Today's database professionals must understand how to apply database systems to business processes and how to develop database systems for both business intelligence and Web-based applications. Database Development and Management demonstrates to students and other IT professionals what databases are, how to build and manage them, and how they can be deployed for information processing, data analysis, and business intelligence. This self-contained text provides hands-on projects required for professionally developing and managing databases.

Preface

xvii

Acknowledgments

xxv

Introduction to Database Systems

(16)

Objectives

(1)

Functions of a Database

(1)

Database Management System

(6)

Database Components

(6)

Database Development Process

(1)

Summary

(2)

Review Questions

(1)

Conceptual Design and Data Modeling

(40)

Objectives

(1)

Introduction to Database Design Process

(2)

Conceptual Design

(1)

Database Design

(1)

Physical Design

(1)

Understanding Business Process

(5)

Business Process

(1)

Case Study: Hillcrest Computing Business Process

(1)

Investigating Business Requirements

(3)

Entity-Relationship Data Model

(11)

Entities

(1)

Attributes, Identifiers, and Domains

(1)

Relationships

(4)

Cardinality

(1)

Relationship Naming

(1)

Recursive Relationships

(1)

Ternary Relationships

(1)

Business Rules

(1)

Representing Business Process with Entity-Relationship Model

(17)

Determining Entities from Business Information

(1)

Identifying Attributes from Business Information

(3)

Identifying Relationships among Entities

(1)

Identifying Cardinalities

(3)

Creating Entity-Relationship Diagrams

(1)

Creating Entities

(3)

Creating Relationships

(4)

Entity-Relationship Modeling

(2)

Summary

(5)

Review Questions

(1)

Case Study Projects

(1)

Computer Service

(1)

University Registration

(1)

Mail Order

(3)

Table Structure and Normalization

(30)

Objectives

(1)

Introduction to Tables

(5)

Tables

(1)

Keys

(2)

Linking Tables

(1)

Functional Dependency

(2)

Table Normalization

(21)

Why Table Normalization

(4)

Normal Forms

(1)

First Normal Form (1NF)

(1)

Second Normal Form (2NF)

(1)

Third Normal Form (3NF)

(2)

Boyce--Codd Normal Form (BCNF)

(1)

Fourth Normal Form (4NF)

(4)

Domain-Key Normal Form (DKNF)

(8)

Denormalization

(1)

Summary

(4)

Review Questions

(1)

Case Study Projects

(1)

Computer Service

(1)

University Registration

(1)

Mail Order

(2)

Transforming Data Models to Relational Databases

(36)

Objectives

(1)

Introduction

(1)

DBMS Selection

(1)

Transforming Data Models to Relational Databases

(13)

Representing Entities

(4)

Representing Relationships

(9)

Enforcing Constraints

102

(2)

Creating Database for Business Process

104

(17)

Creating the Hillcrest Computing Database

110

(1)

Designing Tables

111

(2)

Creating Surrogate Keys

113

(2)

Enforcing Constraints

115

(3)

Creating Relationship Diagrams

118

(3)

Summary

121

(2)

Review Questions

121

(1)

Case Study Projects

122

(1)

Computer Service

122

(1)

University Registration

122

(1)

Mail Order

122

(1)

Physical Design and Database Implementation with SQL

123

(36)

Objectives

123

(1)

Introduction

123

(1)

Physical Design

124

(1)

Database System Architecture

124

(1)

Data Type and Size

124

(1)

Database Accessing

125

(1)

Data Usage

125

(1)

Creating, Controlling, and Modifying Database Objects with SQL

125

(17)

Creating Database Objects

126

(1)

Creating Databases

126

(1)

Defining Data Types

127

(1)

Creating Tables

128

(5)

Creating Views

133

(1)

Creating Database Objects in Query Analyzer

133

(3)

Modifying Database Objects

136

(4)

Manipulating Data in Tables

140

(1)

Controlling Database Object Privileges

141

(1)

Transporting Database Data

142

(12)

Entering Data Manually

142

(1)

Importing and Exporting Data

143

(1)

Import/Export Wizard

143

(2)

Bulk Copy Program (bcp)

145

(4)

Bulk Insert

149

(1)

Accessing External Data

149

(3)

Copying Database

152

(2)

Summary

154

(5)

Review Questions

154

(2)

Case Study Projects

156

(1)

Computer Service

156

(1)

University Registration

157

(1)

Mail Order

157

(2)

Querying Databases

159

(26)

Objectives

159

(1)

Introduction

159

(1)

Retrieving Data from Tables

159

(22)

Querying with Select, From and Where Statements

160

(1)

Logical Operators

160

(5)

Comparison Operators

165

(2)

Arithmetic Operators

167

(2)

Subqueries

169

(3)

Joining Multiple Tables with SQL

172

(2)

Inner Join

174

(1)

Outer Join

175

(1)

Multiple Joins

176

(1)

Self Join

176

(3)

SQL Built-In Functions

179

(2)

Summary

181

(4)

Review Questions

182

(1)

Case Study Projects

183

(1)

Computer Service

183

(1)

University Registration

183

(1)

Mail Order

184

(1)

SQL Procedures

185

(36)

Objectives

185

(1)

Introduction

185

(1)

SQL Programming Extension

186

(4)

Variables

186

(1)

Flow-Control Structures

187

(3)

Procedures and Functions

190

(12)

Functions

190

(1)

Built-In Functions

191

(2)

User-Defined Functions

193

(3)

Procedures

196

(1)

Viewing and Executing Stored Procedures

197

(1)

Creating, Modifying, and Deleting Stored Procedures

198

(4)

Triggers

202

(8)

About Triggers

203

(1)

Trigger Execution

203

(1)

Creating, Modifying, and Deleting Triggers

204

(2)

Using Triggers

206

(1)

Validating Business Constraints

206

(2)

Implementing Dynamic Application Logic

208

(1)

Keeping Referential Integrities

209

(1)

Debugging SQL Procedures

210

(7)

Procedure Debugger

211

(2)

Return Statement

213

(2)

@ @ Error

215

(1)

Raiserror

216

(1)

Summary

217

(4)

Review Questions

217

(1)

Case Study Projects

218

(1)

Computer Service

218

(1)

University Registration

219

(1)

Mail Order

219

(2)

Database Views, Indexes, and Cursors

221

(36)

Objectives

221

(1)

Introduction

221

(4)

Creating and Managing Views

225

(8)

Creating Views

225

(1)

Creating a View Using Enterprise Manager

225

(1)

Creating a View by Create View Statement

226

(1)

Creating a View by Create View Wizard

227

(2)

Modifying Views

229

(1)

Modifying Data in Views

230

(1)

Creating Calculated Columns in Views

230

(3)

Deleting Views

233

(1)

Creating and Managing Indexes

233

(6)

Creating Indexes

234

(1)

Creating Indexes with Enterprise Manager

234

(1)

Creating Indexes with Wizard

235

(1)

Creating Indexes with Create Index Statement

235

(1)

Managing Indexes

236

(1)

Managing Indexes with Enterprise Manager

236

(1)

Managing Indexes with Query Analyzer

237

(1)

Managing Indexes with Stored Procedures

237

(2)

Updating Indexes

239

(1)

Deleting Indexes

239

(1)

Creating and Managing Cursors

239

(3)

Client Cursors

240

(1)

Application Programming Interface (API) Server Cursors

240

(1)

Transact-SQL Cursors

241

(1)

Case Study: Hillcrest Computing

242

(11)

Summary

253

(4)

Review Questions

253

(1)

Case Study Projects

254

(1)

Computer Service

254

(1)

University Registration

254

(1)

Mail Order

255

(2)

Accessing Data

257

(30)

Objectives

257

(1)

Introduction

257

(1)

Database Accessing

258

(2)

Open Database Connectivity (ODBC)

260

(6)

Object Linking and Embedding Database (OLE DB)

266

(3)

Active Data Object (ADO)

269

(14)

Example: Creating an ADO RecordSet Object

279

(4)

Summary

283

(4)

Review Questions

283

(1)

Case Study Projects

284

(1)

Computer Service

284

(1)

University Registration

284

(1)

Mail Order

285

(2)

Database Application Development

287

(52)

Objectives

287

(1)

Introduction

287

(1)

Understanding Business Process

288

(2)

User Interface Design and Format

290

(6)

Graphical User Interface

290

(3)

Enforcing Cardinality Constraints

293

(3)

Creating Forms

296

(27)

Creating Forms with Form Wizard

297

(1)

Creating Forms Based on Views with Form Wizard

297

(1)

Creating Forms Based on Tables with Form Wizard

298

(2)

Creating Forms Based on Stored Procedures with Form Wizard

300

(2)

Creating Forms without Wizard

302

(1)

Creating Company Logo

303

(2)

Creating Views for Forms

305

(1)

Placing Controls to Forms

305

(1)

Configuring Properties for Controls

306

(2)

Configuring Option Group with Control Wizard

308

(1)

Configuring Text Box with Conditional Formatting

309

(3)

Programming Event Procedures

312

(1)

Configuring Click Event for Combo Box

312

(2)

Creating Subforms

314

(1)

Creating Subform with Wizard

315

(3)

Configuring Click Event for Command Button

318

(3)

Configuring Command Button Using Wizard

321

(2)

Creating Reports

323

(12)

Creating Reports Using Wizards

323

(1)

Creating Report Based on Table or View

323

(1)

Embedding Subreport in Main Report

323

(2)

Creating Report Based on Stored Procedure

325

(2)

Dynamically Formatting Report Using Conditional Formatting

327

(1)

Creating Comprehensive Reports Using Forms, Reports, and Graphics

328

(1)

Creating More Sophisticated Sales Report

328

(1)

Creating Sales Chart

329

(1)

Creating Select Sales Center Form

330

(5)

Summary

335

(4)

Review Questions

336

(1)

Case Study Projects

336

(1)

Computer Service

337

(1)

University Registration

337

(1)

Mail Order

337

(2)

Network Databases

339

(72)

Objectives

339

(1)

Introduction

339

(1)

Client/Server Computing

340

(4)

Two-Tier Architecture

341

(1)

Three-Tier Architecture

342

(2)

Introduction to Extensible Markup Language (XML)

344

(12)

XML Data File (.xml File)

346

(1)

XML Schema Definition Language File (.xsd File)

347

(3)

Extensible Stylesheet File (.xsl file)

350

(3)

Export/Import XML Data

353

(3)

Developing Database Applications with Visual Studio .NET

356

(28)

Developing Windows Application

357

(1)

GUI Design for Windows Application

358

(3)

Accessing Data with ADO.NET

361

(6)

Writing Code to Perform Activities for Windows Application

367

(5)

Testing Windows Application Project

372

(1)

Developing Web Application

372

(4)

GUI Design for Web Application

376

(1)

Creating Data Adapters and Generating Dataset

377

(3)

Writing Code to Perform Activities for Web Application

380

(3)

Testing Web Application Project

383

(1)

XML Web Services and InfoPath

384

(21)

Creating Web Services with Visual Studio .NET

385

(6)

Creating InfoPath Forms

391

(1)

Creating Form Based on Existing Data Source

392

(3)

Creating Form Receiving Data from XML Web Service Data Source

395

(5)

Creating Form to Submit Data to XML Web Service Data Source

400

(5)

Summary

405

(6)

Review Questions

407

(1)

Case Study Projects

407

(1)

Computer Service

407

(1)

University Registration

408

(1)

Mail Order

409

(2)

Database Administration

411

(54)

Objectives

411

(1)

Introduction

411

(1)

Managing Database User Accounts and Security

412

(12)

Server Authentication

412

(1)

Windows Authentication Mode

412

(1)

Mixed Authentication Mode

413

(1)

Server Authorization

414

(1)

Database Users

414

(1)

Permissions

415

(1)

Roles

415

(2)

Creating Roles and Users, and Auditing Log-Ins

417

(1)

Creating Roles

418

(1)

Creating Users

418

(2)

Auditing Log-Ins

420

(4)

Backing Up and Recovering Databases

424

(13)

About Database Backups

426

(3)

About Database Recovery

429

(2)

Configuring Recovery Model

431

(1)

Creating Backup Device

431

(1)

Backing Up Database

432

(3)

Restoring Database

435

(2)

Database Replication

437

(5)

Creating Distribution Database

438

(1)

Configuring Replication Publisher

439

(1)

Configuring Replication Subscriber

440

(2)

Optimizing Database Performance

442

(17)

Transactions and Locks

443

(2)

Tools Used in Performance Tuning

445

(1)

Using Enterprise Manager

446

(2)

Using Profiler

448

(2)

Using Query Analyzer

450

(6)

Impact of Database Structure on Performance

456

(1)

RAID 0

457

(1)

RAID 1

457

(1)

RAID 5

457

(2)

RAID 10

459

(1)

Database Maintenance Plan

459

(3)

Summary

462

(3)

Review Questions

463

(1)

Case Study Projects

463

(1)

Computer Service

463

(1)

University Registration

464

(1)

Mail Order

464

(1)

Data Analysis Services

465

(48)

Objectives

465

(1)

Introduction

465

(2)

Data Warehouse

467

(19)

Data Warehouse Components

468

(1)

Data Warehouse Developing Tools

469

(1)

Data Warehouse Design

470

(1)

Design Goals

470

(1)

About Dimensional Modeling

470

(1)

Fact Table

471

(1)

Dimension Table

472

(2)

Data Transformation

474

(1)

Data Extraction

474

(1)

Data Cleaning

474

(1)

Data Loading

475

(1)

Data Transformation Services (DTS)

476

(10)

OnLine Analytical Processing (OLAP)

486

(22)

OLAP Terminology

487

(1)

Cube

487

(2)

OLAP Architecture

489

(2)

Analysis Manager

491

(1)

Setting OLAP Data Source

492

(1)

Defining Shared Dimensions

492

(1)

Creating Cube

493

(2)

Data Analysis with Cube

495

(1)

Creating Security Role

496

(4)

PivotTable Service

500

(1)

Building and Manipulating PivotTable in Excel

501

(5)

Building and Manipulating PivotTable List for Web Application

506

(2)

Summary

508

(5)

Review Questions

510

(1)

Case Study Projects

511

(2)

Data Mining

513

(82)

Objectives

513

(1)

Introduction

513

(2)

Data-Mining Process

515

(8)

Data-Mining Process Standards

515

(1)

Understanding Business

516

(2)

Understanding Data

518

(1)

Data Preparation

519

(1)

Mining

520

(2)

Evaluation

522

(1)

Deployment

522

(1)

Data-Mining Algorithms

523

(12)

Decision Tree Algorithm

524

(1)

Constructing Top-Level Node

525

(3)

Constructing Second-Level Node

528

(3)

Clustering Algorithm

531

(4)

Developing Data-Mining Models in SQL Server

535

(29)

Preparing Data-Mining Tools in Analysis Services

535

(1)

Using Data Transformation Services to Prepare Data for Data Mining

536

(3)

Exploring Relationships between Predictable Columns and Input Columns

539

(5)

Creating Decision Tree Data-Mining Model Using Single Relational Table

544

(3)

Creating Cluster Data-Mining Models

547

(1)

Creating Cluster Data-Mining Model Using Single Relational Table

547

(2)

Creating Cluster Data-Mining Model Using Multiple Relational Tables

549

(4)

Creating Cluster Data-Mining Model Using OLAP

553

(2)

Deploying Data-Mining Results with DTS

555

(1)

Creating Table for Data-Mining Model and Table for Prediction

556

(1)

Training Data-Mining Model

557

(1)

Predicting Member Cards with DTS

557

(7)

Creating Form to Display Data-Mining Results

564

(1)

Summary

564

(3)

Review Questions

565

(1)

Case Study Projects

566

(1)

APPENDICES

Appendix A: Sample Databases

567

(18)

Student_Club Database

567

(8)

Hillcrest Computing Database

575

(10)

Appendix B: Installation of SQL Server

585

(6)

SQL Server Installation

585

(6)

Appendix C: Suggested Resources

591

(4)

Web Sites

591

(1)

Books and Articles

592

(1)

Professional Books

592

(1)

Textbooks

593

(1)

Articles

593

(2)

Index

595

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Database Development and Management

Summary

Table of Contents

Supplemental Materials