chap 3.pdf

Schema Desgin & Normalization Schema Design  Components of Database Schema 01 02 03 Types of Schema View(External) Schema Example Logical Schema Example Physical Schema Example Example NORMALIZATION Normalization  Most commonly used normal forms...

Schema Desgin & Normalization Schema Design  Components of Database Schema 01 02 03 Types of Schema View(External) Schema Example Logical Schema Example Physical Schema Example Example NORMALIZATION Normalization  Most commonly used normal forms Example for 1NF ATOMIC VALUE  Example for 1NF 1NF table Example for 2NF Not fully dependent Not fully dependent  Example for 2NF Solution: Step 1 Step 3 Step 2 Step 4  Example for 2NF Table for 2NF  Example for 3NF Transistive dependency Example for 3NF Solution  Example for 3NF Table for 3nf Thank You