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