Chapter 1: The Role of Databases in Electronic Business
Learning Objectives
Introduction
Components of an Organizational System
Network
Hardware
Software
Content
What Is a Database?
Why Are Databases Important to Business?
General Business Example
E-business Example
Organization of the Text
Summary
Key Terms
Exercises
Review
Discuss
Practice
Chapter 2: Relational Theory
Learning Objectives
Introduction
Relational Model
Relational Databa.se Management System (RDBMS)
Database Administrator (DBA)
Entity Relationship Diagrams
Primary Keys
Creating Relationships: Foreign Keys
Data Integrity
First Normal Form
Types of Database Systems
Relational Advantages
Logical Rather Than Physical Links
Fourth-Generation Language (4GL)
Data Independence
Summary
Key Terms
Exercises
Review
Discuss
Practice
References
Chapter 3：Conceptual Design
Learning Objectives
Introduction
Step 1：Represent Entities as Tables
Step 2：Determine Relationships
Step 3：Lisl Fields
step 4：Identify Keys
Step 5：Determining Data mypes
Designing a Single?Table Database
Problem Statemenl
Process
Designing a Database with a One-to-Many Relationstip
Problem Statemenl
Process
Database with Many-to-Many Relationships
Problem Statement
Other Multitable Database Examples
The HospitaI Database
The ACME Database
The Amazon Database
Summary
KeyTerms
Exercises
Review
Discuss
Practice
Chapter 4：Normalization
Learning Objectives
Introduction
NormaI Forms
Denormalized Designs
Normalizing the Arcade Database
Update Problem
lnsert Problem
The Normal Forms
First NormaI Form 1 NF)
Determinants
Second Normal Form(2NF)
Third NormaI Form f3NF)
Boyce-Codd NormaI Form(BCNF)
Fourth NormaI Form(4NF)
Detecting Normaiization Violations
Summary
……
Chapter 5:Advanced Database Designs
Chapter 6:Creating Databased with Oracle Using SQL
Chapter 7:Retrieving Data with Oracle
Chapter 8:Creating Databases with Microsoft Acccess
Chapter 9:Retrieving Data with Microsoft Access
Chapter 10:Creating Databases with Microsoft SQL Server
Chapter 11:Retrieving Data with SQL Server
Chapter 12:Accessing Databases from Web Applecetions with Microsoft AST.NET
Chapter 13:Maintaining Databases from Web Applections with Microsoft ASP.NET
