Cart
Free Shipping on all orders in Australia
Over 5 million books in stock
We aim to be carbon neutral by 2022
Database Concepts By David M. Kroenke

Database Concepts by David M. Kroenke

Condition - Very Good
$37.99
Only 3 left

Database Concepts Summary

Database Concepts by David M. Kroenke

********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.

Table of Contents

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)

Additional information

GOR005207841
Database Concepts by David M. Kroenke
Used - Very Good
Paperback
Pearson Education (US)
2007-01-24
448
0131986252
9780131986251
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us.

Customer Reviews - Database Concepts