thevipulvats

-- Database Normalization: 1NF, 2NF, and 3NF Demonstration
-- This SQL script demonstrates the process of normalizing a database through 
-- First, Second, and Third Normal Forms using a bookstore database example.

-- Create and use bookstore database
CREATE DATABASE bookstore;
USE bookstore;

-- Original denormalized table
CREATE TABLE book_orders (