Database Design

Normalization

• normalization eliminates data redundancy

Norm ensures better data integrity

1. Enforces data consistency
2. Safer updating, removing, and inserting
3. Easier to redesign by extending

OLTP and OLAP

OLTP : typically highly normalized

• write-intensive
• prioritize quicker and safer insertion of data

OLAP : less normalized

• read-intensive
• prioritize quicker queries for analytics

Normal forms

Data Anomalies

1. update anomaly
2. insertion anomaly
3. deletion anomaly