Database Concepts

For undergraduate database management students or business professionals

 

Here’s practical help for understanding, creating, and managing small databases—from two of the world’s leading database authorities. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.

Teaching and Learning Experience

This text will provide a better teaching and learning experience–for you and your students. Here's how:

• Provides a firm understanding of the concepts behind the software
• Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class
• Allows students to work with new, complete databases
• Includes coverage of some of the latest information available

For undergraduate database management students or business professionals

Here s practical help for understanding, creating, and managing small databases from two of the world s leading database authorities. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.

Teaching and Learning Experience
This text will provide a better teaching and learning experience for you and your students. Here's how:

• Provides a firm understanding of the concepts behind the software
• Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class
• Allows students to work with new, complete databases
• Includes coverage of some of the latest information available

"

Part I. Database Fundamentals

1. Getting Started

2. The Relational Model

3. Structured Query Language

Part II. Database Design

4. Data Modeling and the Entity-Relationship Model

5. Database Design

Part III. Database Management

6. Database Administration

7. Database Processing Applications

8. Big Data, Data Warehouses, and Business Intelligence Systems

Online Appendices

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

Appendix B. Getting Started with Oracle Database 11g Release 2 Express Edition

Appendix C. Getting Started with MySQL 5.6 Community Server

Appendix D. James River Jewelry Project Questions

Appendix E. SQL Views

Appendix F. Getting Started in Systems Analysis and Design

Appendix G. Getting Started with Microsoft Visio 2010

Appendix H. The Access Workbench–Section H–Microsoft Access 2101 Switchboards

Appendix I. Getting Started with Web Servers, PHP, and the NetBeans IDE

Appendix J. Business Intelligence Systems

Appendix K. Big Data