Your textbook…

Database Concepts, 3rd Edition

By David M. Kroenke, David Auer

ISBN-10: 0-13-198625-2

ISBN-13: 978-0-13-198625-1

Published by Prentice Hall

Pub. Date: Jan 24, 2007

Format: Paper

Table of Contents

Part I. Fundamentals

1. Getting Started

Why Use a Database? Problems with Lists. Using Relational Database Tables. Processing the Relational Tables. What is a Database System?

The Access Workbench I

2. The Relational Model

Relations. Types of Keys. The Problem of Null Values. Functional Dependencies and Normalization. The Access Workbench II

3. Structured Query Language

An Example Database. "Does Not Work With MS Access SQL". SQL for Data Definition. SQL for Inserting Relational Data. SQL for Relational Query. SQL for Relational Data Modification and Deletion. SQL for Table and Constraint Modification and Deletion. SQL Views. The Access Workbench III

Part II. Database Design and Management

4. Data Modeling and the Entity-Relationship Model

The Requirements Stage. The Entity-Relationship Data Model. Entity-Relationship Diagrams. In-Dependent Entities. Recursive Relationships. Developing an Example E-R Diagram. The Access Workbench IV

5. Database Design

Transforming a Data Model into a Database Design. Representing Entities with the Relational Model. Representing Relationships. Database Design at Heather Sweeney Designs. The Access Workbench V

6. Advanced Topics

The Heather Sweeney Design Database. The Need for Control, Security, and Reliability. Concurrency Control. Database Security. Database Backup and Recovery. Additional DBA Responsibilities. Distributed Database Processing. Object-Relational Databases. The Access Workbench VI

7. Database Administration

The Database Processing Environment. Queries, Forms, and Reports. Client/Server and Traditional Applicaiton Processing. Stored Procedures and Triggers. Web Database Processing. Database Processing and XML. Business Intelligence Systems. The Access Workbench VII

Appendix A. Getting Started with Microsoft SQL Server 2005 Express Edition

Appendix B. Getting Started with MySQL

Appendix C. SQL Views

Appendix D- Access 2007 Tutorial (available online at www.prenhall.com/kroenke)

This textbook is also sold in the various packages listed below. Before purchasing one of these packages, speak with your professor about which one will help you be successful in your course.

Package ISBN-13: 9780137126422

$118.47 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
myitlab for GO! with Microsoft Office 2007
Prentice Hall | ©2008 | Access Code Card

Package ISBN-13: 9780135059104

$91.00 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
myitlab for Exploring Microsoft Office 2007
Prentice Hall | ©2008 | Access Code Card

Package ISBN-13: 9780321545602

$159.00 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
Access 2007 Guidebook, 6th Edition
Maggie Trigg, Phyllis Dobson | ©2008 | Paper; 672 pages

Package ISBN-13: 9780136134114

$85.33 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
Prentice Hall IT Career Guide, The, 2nd Edition
Fran Quittel | ©2006 | Paper; 100 pages

Package ISBN-13: 9780132361767

$138.93 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
Microsoft Office Access 2007 In Business, Core
Joseph J. Manzo | ©2008 | Paper; 352 pages

Package ISBN-13: 9780135019269

$107.53 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
Oracle SQL by Example, 3rd Edition
Alice Rischert | ©2004 | Paper; 960 pages

Package ISBN-13: 9780138152147

$138.93 | Add to Cart

This package contains:

Database Concepts, 3rd Edition
David M. Kroenke, David Auer | ©2008 | Paper; 448 pages
EXPL MICROSFT OFFC ACC07 V1&STU CD EXPL OFC
| ©2008 | Kit/Package/ShrinkWrap

Package ISBN-13: 9780135026014

$104.47 | Add to Cart

This package contains:

Package ISBN-13: 9780138134365

$160.73 | Add to Cart

This package contains:

Package ISBN-13: 9780136069027

$85.33 | Add to Cart

This package contains:

Package ISBN-13: 9780131361539

$126.60 | Add to Cart

This package contains:

Package ISBN-13: 9780132356107

$104.79 | Add to Cart

This package contains:

Package ISBN-13: 9780132427586

$85.33 | Add to Cart

This package contains:

Package ISBN-13: 9780132424301

$266.33 | Add to Cart

This package contains:

GO! with Microsoft Office Access 2003 Comprehensive and Student CD Package
Shelley Gaskin, Jeffrey Howard | ©2004 | Kit/Package/ShrinkWrap
GO! with Microsoft Office Excel 2003 Comprehensive and Student CD Package
Shelley Gaskin, Robert L. Ferrett, John Preston, Sally Preston | ©2004 | Paper

This item has been upgraded to Database Concepts, 4th Edition.