Business

********NEW ACCESS 2007 TUTORIAL AVAILABLE AT www.prenhall.com/kroenke********

********Complete Access 2007 Updates available.  Click here.********

Appropriate for all introductory courses or brief courses on database development and management, as well as database courses designed around specific database products such as Microsoft Access, SQL Server, or MySQL.

Written by one of the world's leading database authorities, Database Concepts 3e, introduces the essential concepts students need to create and use small databases. 

Written by one of the world's leading database authorities, Database Concepts 3e, introduces the essential concepts students need to create and use small databases. 

********NEW ACCESS 2007 TUTORIAL AVAILABLE AT www.prenhall.com/kroenke********

• Conceptual Standpoint- Teaching Concepts Independent of DBMS Products illustrates database concepts with Microsoft Access, SQL Server 2005 Express edition, and MySQL 5.0. Students can use these products as tools, but all concepts are presented in a DMBS-agnostic manner.
  • Pg.

Do you use Access with your students?

• Access WorkBench sections are included in each chapter to illustrate concepts and techniques using Access. The Access Workbench topics start with creating a database and a single table in Section one and end with Web database processing against an Access database in Section Seven. All necessary basics are included so students can effectively build and use Access databases. 
  • Pg.

Do you assign cases?

• Start-to-finish running cases teach key database concepts through real-world scenarios and case studies, with all sample databases downloadable from the companion Web site. This enables students to understand the real-world challenges they will face in designing, developing, and managing databases. 
  

  • Pg.

Do you assign a variety of questions, exercises and projects for homework?

• Review Questions, Exercises, and Projects — Each chapter concludes with review questions, exercises and three projects (Garden Glory, James River Jewelry, Queen Anne Curiosity Shop) that run throughout the book.
  • Pg.

&a>

Major changes:

• NEW ACCESS 2007 TUTORIAL AVAILABLE AT www.prenhall.com/kroenke
• Coverage of SQL views (Appendix C)
• Coverage of subtype/supertype entities (Chapters 4 & 5)
• Coverage of associative entities and asssociation relationships (Ch. 5)
• Use of IE Crow's Foot E-R Diagrams instead of UML E-R models for ease of use and consistency with Database Processing (Ch. 4 and following)
• Rearrangement of the topics in Ch. 6 & 7- Distributed Database and Object-Relational Databases are covered as part of Database Administration in Ch. 6
• Additional coverage of Web based database processing including specific steps and code examples to create Web pages that display data stored in databases (Ch. 7)
• Coverage of concepts of Business Intelligence (BI) systems (Ch. 7)
• The use of the Access Workbench sections in each chapter and Appendix C to provide coverage of Access fundamentals
• Introduction to the use of SQL Server 2005 Express Edition (Appendix A) and MySQL 5.0 (Appendix B)
• Three example databases that run throughout various portions of the book (The Wedgewood Pacific Corporation and Heather Sweeny Design in the chapters, and Wallingford Motors in the Access Workbench sections- are fully developed with example datasets. 

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

Database Management  (MIS)
Database Applications - MySQL  (MIS)
Database Applications - SQL  (MIS)
Database Applications - ACCESS  (MIS)
Database Applications - SQL Server  (MIS)

• 
  Database Concepts, 4/E
  Kroenke & Auer
  ©2010 | Prentice Hall | Paper; 480 pp | Instock
  ISBN-10: 0136086535 | ISBN-13: 9780136086536
  Brief Description | Buy from myPearsonStore

  

  For undergraduate database courses.
  
  Written by one of the world's leading database authorities, Database Concepts, 4e, introduces the essential concepts students need to create and use small databases.  
  
  The new edition is updated for access 2007.
  
  

Instructor's Resource Center, 3/E
Kroenke
©2008 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0131986260 | ISBN-13: 9780131986268
  View Downloadable Files

Microsoft Access 2007 Updates, 3/E
Kroenke & Auer
©2009 | Prentice Hall | On-line Supplement | Instock
ISBN-10: 0136070574 | ISBN-13: 9780136070573
  View Downloadable Files

TestGen, 3/E
Kroenke
©2008 | Prentice Hall | Software | Instock
ISBN-10: 0131986279 | ISBN-13: 9780131986275
  View Downloadable Files

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0135059100 | ISBN-13: 9780135059104
©2008 | Instock | Suggested retail price: $91.00 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0137126425 | ISBN-13: 9780137126422
©2008 | Instock | Suggested retail price: $118.47 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0135026016 | ISBN-13: 9780135026014
©2008 | Instock (Additional assembly time required) | Suggested retail price: $104.47 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0138134367 | ISBN-13: 9780138134365
©2008 | Instock | Suggested retail price: $155.33 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0135019265 | ISBN-13: 9780135019269
©2008 | Instock (Additional assembly time required) | Suggested retail price: $107.53 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0321545605 | ISBN-13: 9780321545602
©2008 | Instock | Suggested retail price: $159.00 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0136069029 | ISBN-13: 9780136069027
©2009 | Instock (Additional assembly time required) | Suggested retail price: $85.33 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0138152144 | ISBN-13: 9780138152147
©2008 | Instock | Suggested retail price: $127.80 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0132361760 | ISBN-13: 9780132361767
©2008 | Instock | Suggested retail price: $138.93 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0132356104 | ISBN-13: 9780132356107
©2008 | Instock | Suggested retail price: $104.79 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0132427583 | ISBN-13: 9780132427586
©2008 | Instock (Additional assembly time required) | Suggested retail price: $85.33 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0131361538 | ISBN-13: 9780131361539
©2008 | Instock (Additional assembly time required) | Suggested retail price: $126.60 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0136134114 | ISBN-13: 9780136134114
©2008 | Instock (Additional assembly time required) | Suggested retail price: $85.33 | Buy from myPearsonStore
This package contains:

Package ISBN-10: 0132424304 | ISBN-13: 9780132424301
©2008 | Instock | Suggested retail price: $272.33 | Buy from myPearsonStore
This package contains: