目錄
Database Management Systems
Why Normalization?
Definitions
Keys
Notation
Identifying Key Columns
Common Order System
Client Billing Example
Client Billing--Different Rules
Client Billing--New Assumptions
Sample: Video Database
Initial Objects
Initial Form Evaluation
Problems with Repeating Sections
Problems with Repeating Sections
First Normal Form
Nested Repeating Sections
First Normal Form Problems (Data)
Second Normal Form Definition
Second Normal Form Example
Second Normal Form Example (Data)
Second Normal Form Problems (Data)
Third Normal Form Definition
Third Normal Form Example
Third Normal Form Example Data
Third Normal Form Tables (3NF)
Checking Your Work (Quality Control)
Boyce-Codd Normal Form (BCNF)
Fourth Normal Form (Keys)
No Hidden Dependencies
Data Rules and Integrity
SQL Foreign Key (Oracle)
Domain-Key Normal Form (DKNF)
DKNF Examples
DKNF Examples
Effect of Business Rules
Business Rules 1
Business Rules 2
Business Rules 2: Normalized
Converting a Class Diagram to Normalized Tables
One-to-Many Relationships
One-to-Many Sample Data
Many-to-Many Relationships
Many-to-Many Sample Data
N-ary Associations
Composition
Generalization or Subtypes
Subtypes Sample Data
Recursive Relationships
Normalization Examples
Multiple Views & View Integration
The PetStore: Sales Form
The PetStore: Purchase Animals
The PetStore: Purchase Merchandise
PetStore Normalization
PetStore View Integration
PetStore ERD
Rolling Thunder Integration Example
Initial Tables for Bicycle Assembly
Rolling Thunder: Purchase Order
RT Purchase Order: Initial Tables
Rolling Thunder: Transactions
RT Transactions: Initial Tables
Rolling Thunder: Components
RT Components: Initial Tables
RT: Integrating Tables
RT Example: Integrated Tables
Rolling Thunder Tables
View Integration (FEMA Example 1)
View Integration (FEMA Example 2)
View Integration (FEMA Example 3)
View Integration (FEMA Example 3a)
View Integration (FEMA Example 4)
View Integration (FEMA Example 4a)
DBMS Table Definition
Data Volume
Data Volume Example
|