PART 1 • GETTING STARTED 1
Chapter 1: Introduction 2
Chapter Objectives 2
The Characteristics of Databases 3
ANote on Naming Conventions 3 • ADatabase Has Data and Relationships 4 •
Databases Create Information 5
Database Examples 6
Single-User Database Applications 6 • Multiuser Database Applications 6
E-Commerce Database Applications 7 • Reporting and Data Mining Database
Applications 7
The Components of a Database System 8
Database Applications and SQL 9 • The DBMS 11 • The Database 12
Personal Versus Enterprise-Class Database Systems 13
What Is Microsoft Access? 13 • What Is an Enterprise-Class Database System? 15
Database Design 16
Database Design from Existing Data 17 • Database Design for New Systems
Development 17 • Database Redesign 18
What You Need to Learn 19
A Brief History of Database Processing 20
The Early Years 20 • The Emergence and Dominance of the Relational
Model 22 • Post-Relational Developments 23
Summary 25 • Key Terms 26 • Review Questions 26 • Project
Questions 28
Chapter 2: Introduction to Structured Query Language 31
Chapter Objectives 31
Components of a Data Warehouse 32
Cape Codd Outdoor Sports 33
The Extracted Retail Sales Data 33 • RETAIL_ORDER Data 35 • ORDER_ITEM
Data 35 • SKU_DATATable 36 • The Complete Cape Codd Data Extract
Schema 36 • Data Extracts Are Common 37
SQL Background 37
The SQL SELECT/FROM/WHERE Framework 38
Reading Specified Columns from a Single Table 38 • Specifying Column Order in
SQL Queries from a Single Table 39 • Reading Specified Rows from a Single
Table 41 • Reading Specified Columns and Rows from a Single Table 42
Submitting SQL Statements to the DBMS 43
Using SQL in Microsoft Access 2010 43 • Using SQL in Microsoft SQL Server
2008 R2 48 • Using SQL in Oracle Database 11g 51 • Using SQL in Oracle