Scribd
Upload
62 views9 pages

Order Summary and Dish Details

The document outlines the steps to normalize a restaurant order data from the first normal form (1NF) to the third normal form (3NF). It starts with the original data containing repeating groups and progresses through removing repeating groups in 1NF, removing partial dependencies in 2NF and removing transitive dependencies in 3NF. The resulting normalized tables include separate tables for order data, dish data, restaurant data and the relationship between them.

Uploaded by

THE HOWDAY COMPANY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
62 views9 pages

Order Summary and Dish Details

The document outlines the steps to normalize a restaurant order data from the first normal form (1NF) to the third normal form (3NF). It starts with the original data containing repeating groups and progresses through removing repeating groups in 1NF, removing partial dependencies in 2NF and removing transitive dependencies in 3NF. The resulting normalized tables include separate tables for order data, dish data, restaurant data and the relationship between them.

Uploaded by

THE HOWDAY COMPANY
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Step 1: UNF

Data
SN Date/Time Order Number Order Amount
9th November
2020-09-223334 09-00231 2750
2020/14:30
9th November
2020-09-223374 09-00345 700
2020/15:20
9th November
2020-09-223334 09-00360 5000
2020/14:40
9th November
2020-09-223334 09-09000 3450
2020/16:50

Data(SN, Date/Time,
Order Number , Order
Amount, Delivery Point,
Status,{ Dish code,
Dish Name, Order Unit,
Dish Rate, Line Total,
Restuarent})

Step 2: 1NF (Removing


Repeating group)
Data(SN, Date/Time, Order Number , Order Amount, Delivery Point, Status)

Dish( Dish code, Order


Number, Dish Name,
Order Unit, Dish Rate,
Line Total, Restuarent)

Data
SN Date/Time Order Number Order Amount
9 November
th
2020-09-223334 09-00231 2750
2020/14:30
9th November
2020-09-223374 09-00345 700
2020/15:20
9th November
2020-09-223334 09-00360 5000
2020/14:40
9th November
2020-09-223334 09-09000 3450
2020/16:50

Dish
Dish Code Order Number Dish Name Order Unit

CHKMO 09-00231 Chicken Momo 6 Plates

MIXCHT 09-00231 Mixed Chatamari 2 Plate

CHKMO 09-00345 Chicken Momo 2 Plates

Step3: 2NF (removing partial dependency)


dish code, order number->orderunit, linetotal,restaurant
dish code -> dish name, dish rate

Data(SN, Date/Time, Order Number , Order Amount, Delivery Point, Status)


Orderdish(dish code, order number, orderunit, linetotal, restaurent name, restuarentid)
Totaldish( dish code, dish name, dish rate)

Orderdish
Dish Code Order Number Order Unit Line Total

CHKMO 09-00231 6 Plates 2100

MIXCHT 09-00231 2 Plate 650

CHKMO 09-00345 2 Plates 700

Totaldish
Dish Code Dish Name Dish Rate
CHKMO Chicken Momo 350
MIXCHT Mixed Chatamari 325

Step4: 3NF(removing tranistive dependency)


dish code, order number -> restauraentid, restuarent name, order unit, line total
restuarentid -> restuarent name
dish code, order number -> restauraentid - > restuarent name

Data(SN, Date/Time, Order Number , Order Amount, Delivery Point, Status)


Orderdish(dish code, order number, orderunit, linetotal, restuarentid)
Totaldish( dish code, dish name, dish rate)
Restaurent(Restaurentid, Restaurent name)

Orderdish
Dish Code Order Number Order Unit Line Total

CHKMO 09-00231 6 Plates 2100

MIXCHT 09-00231 2 Plate 650

CHKMO 09-00345 2 Plates 700

Totaldish
Dish Code Dish Name Dish Rate
CHKMO Chicken Momo 350
MIXCHT Mixed Chatamari 325

Restaurent
Restaurentid Restaurent name

R1 Taste Buds
R2 Local Foodie
Delivery Point Status Dish Code Dish Name Order Unit

Baneshwor On Time CHKMO Chicken Momo 6 Plates

Kalanki Early MIXCHT Mixed Chatamari 2 Plate

Baluwatar On Time CHKMO Chicken Momo 2 Plates

Kalanki Late

Delivery Point Status

Baneshwor On Time

Kalanki Early

Baluwatar On Time
Kalanki Late

Dish Rate Line Total Restaurent

350 2100 Taste Buds

325 650 Local Foodie

350 700 Taste Buds

Data
Restaurent name Restaurentid SN Date/Time

9th November
Taste Buds R1 2020-09-223334
2020/14:30
9th November
Local Foodie R2 2020-09-223374
2020/15:20
9th November
Taste Buds R1 2020-09-223334
2020/14:40
9th November
2020-09-223334
2020/16:50
Restaurentid Data
R1 SN Date/Time Order Number

2020-09- 9th November


R2 09-00231
223334 2020/14:30
2020-09- 9th November
R1 09-00345
223374 2020/15:20
2020-09- 9th November
09-00360
223334 2020/14:40
2020-09- 9th November
09-09000
223334 2020/16:50
Dish Rate Line Total Restaurent

350 2100 Taste Buds

325 650 Local Foodie

350 700 Taste Buds


Order Order Delivery
Status
Number Amount Point

09-00231 2750 Baneshwor On Time

09-00345 700 Kalanki Early

09-00360 5000 Baluwatar On Time

09-09000 3450 Kalanki Late


Order Delivery
Status
Amount Point

2750 Baneshwor On Time

700 Kalanki Early

5000 Baluwatar On Time

3450 Kalanki Late

You might also like