Skip to content

Instantly share code, notes, and snippets.

@f4ww4z

f4ww4z/normalization_exercise.md

Last active November 26, 2019 03:34
Show Gist options
  • Save f4ww4z/7be71bf1200375961005e74a01cbe2f3 to your computer and use it in GitHub Desktop.
Save f4ww4z/7be71bf1200375961005e74a01cbe2f3 to your computer and use it in GitHub Desktop.
Download ZIP
For Database K3 CSF3205
Raw
normalization_exercise.md

Normalization Exercise

Name: Maharaj Faawwaz A Yusran

Matrix No: S52500

Before:

OrderNumber CustomerNumber CustomerName CustomerAddress City Country OrderDate ProductNo Description Quantity UnitPrice
1234 9876 Billy 456 Hightower street Hong-Kong China 11/04/98 A123, B234, C345 Pencil, Eraser, Sharpener 100, 200, 5 3.00, 1.5, 8

After:

Products

ProductNo Description Unit Price
A123 Pencil 3
B234 Eraser 1.5
C345 Sharpener 8

Customers

CustNo CustName CustAddress
9876 Billy 456 HighTower Street

Orders

OrderNo CustNo ProductNo Quantity OrderFormNo
1 9876 A123 100 1234
2 9876 B234 200 1234
3 9876 C345 5 1234

OrderForms

OrderFormNo Date
1234 1998-04-11
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment