Database Normalization in SQL: Detecting Anomalies & Applying Normal Forms (1NF, 2NF, 3NF)
Website: https://www.cristianduque.com/
Timeline:
Intro - 0:00
Demo: 0:18
Anomalies: 0:51
1NF: 2:24
2NF: 4:12
3NF: 5:24
Benefits: 6:50
Drawbacks: 7:09
SQL Query Demo:
CREATE TABLE Customer (
[Name] VARCHAR(64),
[Coupon] VARCHAR(4),
[ProductName1] VARCHAR(256),
[ProductName2] VARCHAR(256),
[GenderAge] VARCHAR(32),
[ZipCode] INT,
[City] VARCHAR(16));
INSERT INTO Customer values ('Bob', null, 'Shoe', 'Jacket', 'M, 18', '39', 'NY'),
('Anna', 'AF8R', 'Jacket', 'Hat', 'F, 23', '12', 'WA');