Table of contents for Database concepts / David M. Kroenke, David J. Auer.

Bibliographic record and links to related information available from the Library of Congress catalog.

Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.


Counter
CONTENTS
Preface 
PART I ¿Fundamentals
CHAPTER ONE -Getting Started
Chapter Objectives
Why Use a Database?
Problems with Lists
Using Relational Database Tables
A Relational Design for the Student with Adviser List
A Relational Design for the Student with Adviser and Department List
A Relational Design for Art Course Enrollments
A Relational Design for Parts and Prices
Processing the Relational Tables
Processing Tables with SQL
What Is a Database System?
The Database
The DBMS
Application Programs
Personal versus Enterprise-class Database Systems
THE ACCESS WORKBENCH SECTION ONE - GETTING STARTED WITH MICROSOFT ACCESS
INSERTING DATA INTO TABLES ¿ THE DATASHEET VIEW
CREATING AN ACCESS DATABASE
MODIFYING DATA IN TABLES ¿ THE DATASHEET VIEW
INSERTING DATA INTO TABLES ¿ USING A FORM
MODIFYING DATA AND DELETING RECORDS - USING A FORM
CREATING SINGLE TABLE ACCESS REPORTS
CLOSING A DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workbench Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
CHAPTER TWO -The Relational Model
Chapter Objectives
Relations
A Sample Relation and Two Nonrelations
A Note on Presenting Relation Structures
A Note on Terminology
Types of Keys
Composite Keys
Candidate and Primary Keys
Surrogate Keys
Foreign Keys and Referential Integrity
The Problem of Null Values
Functional Dependencies and Normalization
Functional Dependencies
Primary and Candidate Keys Revisited
Normalization
Relational Design Principles
The Normalization Process
Step 1
Step 2
Step 3
Normalization Examples
Normalization Example 1
Normalization Example 2
Normalization Example 3
Normalization Example 4
THE ACCESS WORKBENCH SECTION TWO - WORING WITH MULTIPLE TABLES IN MICROSOFT ACCESS
MODIFICATION PROBLEMS IN NON-NORMALIZED TABLES
WORKING WITH MULTIPLE TABLES
CREATING RELATIONSHIPS BETWEEN TABLES
USING A FORM THAT INCLUDES TWO TABLES
CREATING A REPORT THAT INCLUDES DATA FORM TWO TABLES
CLOSING THE DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
CHAPTER THREE - Structured Query Language
Chapter Objectives
An Example Database
 ¿Does Not Work With MS Access SQL¿
SQL for Data Definition
Defining Primary Keys with Table Constraints
Defining Foreign Keys with the Table Constraints
Submitting SQL to the DBMS
SQL for Inserting Relational Data
Inserting Data
SQL for Relational Query
The SQL SELECT/FROM/WHERE Framework
Reading Specified Columns from a Single Table
Reading Specified Rows from a Single Table
Reading Specified Columns and Specified Rows from a Single Table
Ranges, Wildcards, and Nulls in WHERE Clauses
Sorting the Results
SQL Built-In Functions and Calculations
Built-In Functions and Grouping
Querying Multiple Tables with Subqueries
Querying Multiple Tables with Joins
The SQL JOIN ... ON Syntax
Outer Joins
SQL for Relational Data Modification and Deletion
Modifying Data
Deleting Data
SQL for Table and Constraint Modification and Deletion
The DROP TABLE and ALTER TABLE Statements
The CHECK Constraint
SQL VIEWS
THE ACCESS WORKBENCH SECTION THREE - WORING WITH QUERIES IN MICROSOFT ACCESS
WORKING WITH MICROSOFT ACCESS SQL
WORKING WITH MICROSOFT ACCESS QUERY BY EXAMPLE (QBE)
CREATING TABLES WITH MICROSOFT ACCESS SQL
INSERTING DATA WITH MICROSOFT ACCESS SQL
ADDING REFERENTIAL INTEGRITY CONSTRAINTS USING ACCESS SQL
CLOSING THE DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
PART II - Database Design and Management
CHAPTER FOUR ¿ Data Modeling and the Entity-Relationship Model
Chapter Objectives
The Requirements Stage
The Entity-Relationship Data Model
Entities
Attributes
Identifiers
Relationships
Three Types of Binary Relationships
Maximum Cardinality
Minimum Cardinality
Entity-Relationship Diagrams
Variations of the E-R Model
E-R Variations in Data Modeling Products
ID-Dependent Entities
Weak Entities
Subtype Entities
Recursive Relationships
Developing an Example E-R Diagram
Heather Sweeney Designs
The Seminar Customer List
The Customer Form Letter
The Sales Invoice
Attribute Specifications
Business Rules
Validating the Data Model
THE ACCESS WORKBENCH SECTION FOUR -PROTOTYPING USING MICROSOFT ACCESS
CREATING A PROTOTYPE FORM FOR THE ORIGINAL DATA MODEL
CREATING A PROTOTYPE FORM FOR THE MODIFIED DATA MODEL
THE ACCESS BANDED FORM AND REPORT EDITORS
CLOSING THE DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
CHAPTER FIVE Database Design
Chapter Objectives
Transforming a Data Model into a Database Design
Representing Entities with the Relational Model
Representing the ITEM Entity
Surrogate Keys
Columns Properties
Data Types
NULL values
Default Values
Data Constraints
Verifying Normalizaiton
Representing the CUSTOMER Entity
Denormalization
A Relational Design for the SALES-COMMISSION Entity
Representing Weak Entities
Normal Forms
Representing Relationships
Relationships among Strong Entities
Representing One-to-One (1:1) Strong Entity Relationships
Representing One-to-Many (1:N) Strong Entity Relationships
Representing Many-to-Many (N:M) Strong Entity Relationships
Relationships Using Weak Entities
Relationships with Subtypes
Representing Recursive Relationships
Database Design at Heather Sweeney Designs
Weak Entities
Relationships
Enforcing Referential Integrity
THE ACCESS WORKBENCH SECTION FIVE -RELATIONSHIPS IN MICROSOFT ACCESS
N:M RELATIONSHIPS IN ACCESS
1:1 RELATIONSHIPS IN ACCESS
CLOSING THE DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
CHAPTER SIX -Database Administration
Chapter Objectives
The Heather Sweeney Designs Database
The Need for Control, Security, and Reliability
Concurrency Control
The Need for Atomic Transactions
Concurrent Transaction Processing
The Lost Update Problem
Concurrency Problems: Dirty Reads, Nonrepeatable Reads, and Phantom Reads
Resource Locking
Serializable Transactions
Deadlock
Optimistic Versus Pessimistic Locking
Declaring Lock Characteristics
Consistent Transactions
Transaction Isolation Level
Cursor Type
Database Security
User Accounts
User Processing Rights and Responsibilities
DBMS Level Security
Application Level Security
Database Backup and Recovery
Recovery via Reprocessing
Recovery via Rollback and Rollforward
Additional DBA Responsibilities
Distributed atabase Processing
Types of Distributed Databases
Challenges of Distributed Databases
Object-Relational Databases
THE ACCESS WORKBENCH SECTION SIX - DATABASE ADMINISTRATION IN MICROSOFT ACCESS
DATABASE SECURITY IN ACCESS
USING THE SECURED DATABASE
SECURED DATABASE ADMINISTRATION
CLOSING THE DATABASE AND EXITING ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
CHAPTER SEVEN - Database Processing Applications and Business Intelligence
Chapter Objectives
The Database Processing Environment
Queries, Forms, and Reports
Client/Server and Traditional Application Processing
Stored Procedures and Triggers
Web Database Processing
ODBC
ODBC Architecture
Establishing an ODBC Data Source Name
Web Processing with IIS
Active Server Pages (ASP) 
Active Data Objects ADO
The ADO Object Model
The Connection Object
The RecordSet Object
Fields Collection
Errors Collection
The Command Object
Challenges for Web Database Processing
Database Processing and XML
XML Schema Documents
XML and Database Processing
XML Web Services
Business Intelligence Systems
OLAP and Data Mining
OLAP
Data Mining
THE ACCESS WORKBENCH SECTION SEVEN - WEB DATABASE PROCESSING USING MICROSOFT ACCESS
A WEB HOME PAGE FOR WALLINGFORD MOTORS
SELECTING THE DATABASE FILE
CREATING AN ODBC DATA SOURCE
CREATING THE CUSTOMER CONTACTS VIEW
CREATING THE ASP PAGE
RUNNING THE ASP PAGE
IN CLOSING
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions
APPENDIX A -Getting Started with Microsoft SQL Server 2005 Express Edition
Chapter Objectives
Why Should I Learn Use SQL Server 2005 Express Edition?
What Will This Appendix Teach Me?
What Won¿t This Appendix Teach Me?
Staring SQL Server 2005 Management Studio Express Edition
Creating a Database in SQL Server 2005 Express Edition
Working with SQL Statements in SQL Server 2005
Working with SQL Scripts in SQL Server 2005
SQL Commands to Create Table Structures
SQL commands to insert database data 
Working with SQL Queries in SQL Server 2005
Additional Documentation for SQL Server 2005 Express
Review Questions
Exercises
APPENDIX B - Getting Started with MySQL
Chapter Objectives
Why Should I Learn Use MySQL?
What Will This Appendix Teach Me?
What Won¿t This Appendix Teach Me?
Starting MySQL
Creating a Database in MySQL
Selecting a Database in MySQL
Working with SQL Statements in MySQL
Working with SQL Scripts in MySQL
SQL Commands to Create Table Structures
SQL commands to insert database data 
Working with SQL Queries in MySQL
Additional Documentation for MySQL
Review Questions
Exercises
APPENDIX C -SQL Views
Chapter Objectives
Creating SQL Views
Using SQL Views
Using Views to Hide Columns and Rows
Using Views to Display Results of Computed Columns
Using Views to Hide Complicated SQL Syntax
Layering Computations and Built-in Functions
THE ACCESS WORKBENCH
SECTION C - WORING WITH VIEWS IN MICROSOFT ACCESS
WORKING WITH SQL VIEWS IN MICROSOFT ACCESS
Summary
Review Questions
Exercises
Access Workshop Exercises
Garden Glory Project Questions
James River Jewelry Project Questions
The Queen Anne Curiosity Shop Project Questions

Library of Congress Subject Headings for this publication:

Database management.
Relational databases.