Scribd
Upload
26 views14 pages

DB Assignment 9

The document outlines a database schema for a restaurant management system, detailing various tables including categories, restaurants, states, outlets, dishes, and orders. Each table includes primary keys and foreign keys to establish relationships between the data. It also includes information on menu items, customer details, order types, and ratings.

Uploaded by

nikhilmyself8
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
26 views14 pages

DB Assignment 9

The document outlines a database schema for a restaurant management system, detailing various tables including categories, restaurants, states, outlets, dishes, and orders. Each table includes primary keys and foreign keys to establish relationships between the data. It also includes information on menu items, customer details, order types, and ratings.

Uploaded by

nikhilmyself8
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

CATEGORY_TAB

CATEGORY_ID NAME
1 Buffet
2 Café
3 Fast Food
4 Pizza
5 Quick Bites
6 Fine Dine
Primary key

RESTAURANT_TAB
RESTAURANT_ID NAME
1 Barbeque Nation
2 Dominos
3 Starbucks
4 McDonald
5 Urban Chai
6 Pizza Hut
7 CCD
8 Biryani by Kilo
9 Burger King
10 Pirates of Grill
Primary key

STATES_TAB
STATE_ID STATE
1 Delhi
2 Haryana
3 Maharashtra
4 Punjab
5 Himachal Pradesh
6 Madhya Pradesh
7 Uttar Pradesh
Primary key

OUTLETS_TAB
OUTLET_ID RESTAURANT_ID
1 4
2 2
3 7
4 4
5 2
6 8
7 9
8 3
9 1
10 5
11 7
12 4
13 2
Primary Key Foreign key (RESTAURANT_TAB)

DISH_CATEGORY_TAB
CATEGORY_ID TYPE
1 Starter
2 Main Course
3 Dessert
4 Breads
5 Beverages
Primary key

DISH_TYPE_TAB
DISH_TYPE_ID CATEGORY
1 VEG
2 NON-VEG
Primary key

DISHES_TAB
DISH_ID DISH
1 Tandoori Paneer Tikka
2 Crispy Corn
3 Dahi Ke Kabab
4 Murgh Tikka
5 Chicken Seekh Kabab
6 Chilli Chicken
7 Honey Chilli Potato
8 Dal Makhani
9 Kofta Curry
10 Paneer Butter Masala
11 Gulab Jamun
12 Moong Dal Halwa
13 Kheer
14 Butter Naan
15 Butter Roti
16 Missi Roti
17 Egg Curry
18 Mutton Roghan Josh
19 Chicken Biryani
20 Jeera Rice
21 Cheese Corn Pizza
22 Veg Extraveganza Pizza
23 Cheese Garlic Bread
24 Chicken Exotica Pizza
25 Americano
26 Caffe Latte
27 Cappuccinos
28 Espresso Shots
29 Caffe Mocha
30 Cold Coffee
31 Spicy Guava
32 Fruit Punch
33 Hyderabadi Biryani
34 Lucknowi Biryani
35 Cheese Burger
36 Aloo Tikki Burger
37 Chicken Burger
38 Ginger Elaichi Tea
39 Aloo Patty
40 Veg Maggi
Primary key

MENU_TAB
MENU_ITEM_ID OUTLET_ID
1 1
2 1
3 1
4 1
5 4
6 4
7 12
8 12
9 12
10 2
11 2
12 2
13 5
14 5
15 13
16 13
17 7
18 7
19 7
20 3
21 3
22 3
23 11
24 11
25 11
26 11
27 6
28 6
29 6
30 6
31 6
32 6
33 8
34 8
35 8
36 8
37 8
38 8
39 9
40 9
41 9
42 9
43 9
44 9
45 9
46 9
47 9
48 10
49 10
50 10
Primary key Foreign Key (OUTLETS_TAB)

CUSTOMERS_TAB
CUSTOMER_ID NAME
1 Sonali Khanna
2 Rajesh Kumar
3 Dev Kiran
4 Piyush Ahuja
5 Arun Kumar
6 Simranjeet Kaur
7 Payal Mehra
8 Rajendra Singh
9 Aarti Sharma
Primary Key

ORDER_TYPE_TAB
ORDER_TYPE_ID TYPE
1 TAKE_AWAY
2 DINE_IN
Primary Key
ORDERS_TAB
ORDER_ID CUSTOMER_ID
1 5
2 8
3 4
4 1
5 4
6 1
7 9
8 7
9 6
10 1
11 1
12 6
13 9
14 2
15 3
Primary Key Foreign Key (CUSTOMERS_TAB)

DISHES_ORDERED_TAB
DISH_ORDERED_ID ORDER_ID
1 1
2 1
3 3
4 3
5 3
6 5
7 5
8 6
9 7
10 7
11 7
12 15
13 15
14 12
15 12
16 10
17 10
18 10
19 13
20 13
21 8
22 8
23 8
24 14
25 14
Primary key Foreign Key (ORDERS_TAB)
CATEGORY_ID YEAR_OF_ESTABLISH NO_OF_OUTLETS
1 2006 200
4 1960 2100
2 1971 300
3 1955 500
5 2020 4
4 1958 400
2 1996 600
6 2015 40
3 1954 320
1 2009 15
Foreign Key(CATEGORY_TAB)

STATE_ID DINE_IN TAKE_AWAY


2Y Y
1Y Y
3Y N
2Y Y
1Y Y
4Y Y
5N Y
4Y N
6Y N
7Y N
3Y Y
3Y N
1Y Y
Foreign Key (STATES_TAB)

CATEGORY_ID DISH_TYPE_ID COOKING_TIME_IN_MIN


1 1 30
1 1 20
1 1 40
1 2 45
1 2 60
1 2 35
1 1 15
2 1 120
2 1 25
2 1 30
3 1 90
3 1 150
3 1 240
4 1 10
4 1 3
4 1 5
2 2 23
2 2 90
2 2 120
2 1 10
2 1 15
2 1 15
4 1 10
2 2 15
5 1 7
5 1 10
5 1 5
5 1 8
5 1 10
5 1 15
5 1 10
5 1 10
2 2 140
2 2 90
1 1 15
1 1 15
1 2 25
5 1 10
1 1 10
1 1 15
Foreign Key(DISH_CATEGORY_TAB) Foreign Key(DISH_TYPE_TAB)

DISH_ID PRICE
30 150
37 250
35 175
36 165
30 160
35 180
30 150
37 240
36 180
21 250
22 450
24 750
21 250
23 120
22 450
24 750
35 210
36 220
37 250
25 115
28 125
30 150
26 170
27 140
30 150
29 160
19 250
30 130
31 240
32 270
33 450
34 530
30 160
25 180
26 230
27 190
28 150
29 140
1 300
3 400
5 700
7 200
10 240
12 130
16 90
17 240
18 800
38 10
39 20
40 60
Foreign Key (DISHES_TAB)

STATE_ID DATE_OF_BIRTH GENDER


1 4-Jan-95 F
3 19-Apr-91 M
7 23-Aug-01 M
2 11-Oct-70 M
6 20-May-88 M
4 30-Sep-97 F
1 15-Jan-99 M
4 3-Feb-83 M
4 23-Apr-98 F
Foreign Key (STATES_TAB)
OUTLET_ID ORDER_TYPE_ID ORDER_DATE
4 2 9-Jan-22
9 2 7-Mar-19
3 2 21-Jun-21
6 1 5-Apr-19
10 2 4-Jan-23
2 1 14-Nov-22
6 2 6-Sep-19
8 2 12-Aug-21
13 1 30-Sep-21
11 2 5-Oct-22
7 2 14-May-21
7 2 14-Feb-22
3 2 25-Jul-21
10 1 7-Dec-21
2 2 31-Dec-22
Foreign Key (OUTLETS_TAB) Foreign Key (ORDER_TYPE_TAB)

MENU_ITEM_ID QUANTITY
6 2
5 1
20 2
21 1
22 3
48 4
50 2
12 1
28 3
29 1
30 4
10 2
11 1
18 3
19 5
23 3
24 2
25 1
20 6
21 2
33 1
34 4
35 3
48 4
50 7
Foreign Key (MENU_TAB)
USER_RATING SERVICE_TAX
4.8
3.6
4.9
3.2 10%
4.4
3.1 8%
2.5
4.7
3.6 12%
1.3
3.2
4.5 15%
4.4

You might also like