Database concepts / David M. Kroenke.

Includes bibliographical references and index.

Preface xiii
PART 1 DATABASE FUNDAMENTALS 1 (84)
Getting Started
2 (28)
Chapter Objectives
2 (1)
Why Use a Database?
3 (13)
Relational Databases
5 (2)
Representing Relationships
7 (1)
The Parts List Example
8 (8)
What Is a Database System?
16 (6)
Functions of an Application Program
17 (1)
Functions of a DBMS
18 (1)
Definition and Components of a Database
19 (2)
Desktop Versus Organizational Database Systems
21 (1)
How to Build a Database System
22 (2)
Building a Data Model
22 (1)
Creating a Database Design
23 (1)
Implementing a Database
24 (1)
Summary
24 (2)
Review Questions
26 (1)
Exercises
27 (1)
Garden Glory Project Questions
28 (1)
James River Jewelry Project Questions
28 (2)
The Relational Model
30 (24)
Chapter Objectives
30 (1)
Relations
31 (2)
A Sample Relation and Two Nonrelations
31 (1)
A Note on Terminology
32 (1)
Types of Keys
33 (8)
Composite Keys
34 (1)
Primary and Candidate Keys
34 (1)
Foreign Keys and Referential Integrity
34 (4)
Surrogate Keys
38 (3)
Functional Dependencies and Normalization
41 (6)
Functional Dependencies
41 (1)
Primary and Candidate Keys Revisited
42 (1)
Normalization
43 (1)
Relational Design Principles
44 (1)
Normalization Examples
44 (3)
The Problem of Null Values
47 (1)
Summary
48 (1)
Review Questions
49 (1)
Exercises
50 (1)
Garden Glory Project Questions
51 (1)
James River Jewelry Project Questions
52 (2)
Structured Query Language
54 (31)
Chapter Objectives
54 (1)
A Sample Database
55 (2)
SQL for Data Definition
57 (4)
Defining Primary Keys with the ALTER TABLE Statement
59 (1)
Defining Foreign Keys with the ALTER TABLE Statement
59 (1)
Submitting SQL to the DBMS
59 (1)
DROP Statements
60 (1)
SQL for Relational Query
61 (14)
Reading Specified Columns from a Single Table
62 (1)
Reading Specified Rows from a Single Table
62 (2)
Reading Specified Columns and Specified Rows from a Single Table
64 (1)
Ranges, Wildcards, and Nulls in WHERE Clauses
65 (1)
Sorting the Results
66 (1)
SQL Built-In Functions
67 (2)
Built-In Functions and Groupings
69 (1)
Querying Multiple Tables with Subqueries
70 (1)
Querying Multiple Tables with Joins
71 (3)
Outer Joins
74 (1)
SQL for Relational Data Modification
75 (3)
Inserting Data
75 (1)
Modifying Data
76 (1)
Deleting Data
77 (1)
Summary
78 (1)
Review Questions
79 (2)
Exercises
81 (1)
Garden Glory Project Questions
81 (1)
James River Jewelry Project Questions
82 (3)
PART 2 DATABASE DESIGN AND MANAGEMENT 85 (80)
Data Modeling and the Entity-Relationship Model
86 (24)
Chapter Objectives
86 (1)
The Requirements Stage
87 (1)
The Entity-Relationship Data Model
88 (6)
Entities
88 (1)
Attributes
89 (1)
Identifiers
89 (1)
Relationships
90 (1)
Three Types of Binary Relationships
90 (1)
Recursive Relationships
91 (1)
Entity-Relationship Diagrams
92 (1)
Weak Entities
92 (2)
Unified Modeling Language Entity-Relationship Diagrams
94 (2)
UML Entities and Relationships
94 (1)
UML Representation of Weak Entities
95 (1)
An Example
96 (10)
Heather Sweeney Designs
96 (1)
The Seminar Customer List
97 (1)
The Customer Form Letter
98 (3)
The Sales Invoice
101 (2)
Attribute Specifications
103 (1)
Business Rules
103 (1)
Validating the Data Model
104 (2)
Summary
106 (1)
Review Questions
107 (1)
Exercises
108 (1)
Garden Glory Project Questions
108 (1)
James River Jewelry Project Questions
109 (1)
Database Design
110 (25)
Chapter Objectives
110 (1)
Representing Entities with the Relational Model
111 (6)
Normalization, Second Verse
112 (1)
Normal Forms
113 (1)
Domain/Key Normal Form
113 (1)
Using Normalization Criteria
114 (1)
Denormalization
115 (1)
Representing Weak Entities
115 (2)
Representing Relationships
117 (10)
Representing One-to-One Relationships
117 (2)
Questionable One-to-One Relationships
119 (1)
Representing One-to-Many Relationships
119 (2)
Representing Many-to-Many Relationships
121 (2)
Representing Recursive Relationships
123 (4)
Database Design at Heather Sweeney Designs
127 (4)
Weak Entities
128 (1)
Relationships
128 (1)
Enforcing Referential Integrity
129 (2)
Summary
131 (1)
Review Questions
131 (2)
Exercises
133 (1)
Garden Glory Project Questions
133 (1)
James River Jewelry Project Questions
134 (1)
Database Administration
135 (30)
Chapter Objectives
135 (1)
The Database Processing Environment
136 (4)
Queries, Forms, and Reports
136 (1)
Internet Application Processing
137 (1)
Client/Server and Traditional Application Processing
138 (1)
Stored Procedures and Triggers
138 (1)
The Need for Control, Security and Reliability
139 (1)
Concurrency Control
140 (10)
The Need for Atomic Transactions
140 (1)
Concurrent Transaction Processing
141 (2)
The Lost Update Problem
143 (1)
Concurrency Problems: Dirty Reads, Inconsistent Reads, Phantom Reads
143 (1)
Resource Locking
144 (1)
Lock Terminology
144 (1)
Serializable Transactions
145 (1)
Deadlock
145 (1)
Optimistic Versus Pessimistic Locking
146 (1)
Declaring Lock Characteristics
147 (1)
Consistent Transactions
148 (1)
Transaction Isolation Level
149 (1)
Database Security
150 (3)
Processing Rights and Responsibilities
150 (1)
DBMS Security
151 (1)
Application Security
152 (1)
Database Backup and Recovery
153 (4)
Recovery via Reprocessing
153 (1)
Recovery via Rollback and Rollforward
154 (3)
Additional DBA Responsibilities
157 (1)
Summary
158 (1)
Review Questions
159 (2)
Exercises
161 (1)
Garden Glory Project Questions
162 (1)
James River Jewelry Project Questions
163 (2)
Appendix Database Processing with Microsoft Access 165 (40)
Appendix Objectives
165 (1)
Database Schema for Carbon River Construction
166 (2)
Carbon River Schema Data Structure Diagram
167 (1)
Column Design
167 (1)
Creating Tables and Relationships Using Access
168 (7)
Creating Tables
170 (1)
Creating Relationships
171 (4)
Creating Queries and SQL Statements
175 (6)
Creating Simple Queries with the Graphical Tool
175 (5)
Action Queries
180 (1)
Creating Access Data Entry Forms
181 (9)
Creating a Simple Form
181 (2)
Using Default Values and Combo Boxes with Forms
183 (5)
Looking Up Nonkey Data
188 (2)
Creating Access Reports
190 (7)
Banded Report Writers
190 (2)
Computations in Reports
192 (1)
Parameterized Reports
193 (4)
Summary
197 (1)
Review Questions
198 (2)
Exercises
200 (1)
Garden Glory Project Questions
201 (1)
James River Jewelry Project Questions
202 (3)
Glossary 205 (9)
Index 214

eng