-
Notifications
You must be signed in to change notification settings - Fork 0
/
layout.txt
31 lines (30 loc) · 1.16 KB
/
layout.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Database: Restaurant Management System
- Table Menu
- dish name
- dish id
- cuisine
- no of dishes sold
- dish price
- chef's special (yes/no)
> id,dish_name,cuisine,price,num_sold,chef_special
> id char(20) not null , dish_name char(20) , cuisine char(20) , price int, num_sold int, chef_special boolean, primary key (id))
- Table Inventory
- (raw) material name
- material code
- material type
- cost
- quantity
- date of purchase
> id, material_name, material_type, cost, quantity, date_purchase
> id char(20) not null , material_name char(20) , material_type char(20) , cost int, quantity int, date_purchase DATE, primary key (id)
- Table financials (aggregate)
- total Sales (from table menu)
- total expense (from table inventory + table salary)
- total profit
- Table Employees
- employee name
- employee code
- employee hours
- salary
> code, e_name, e_hours, e_salary
> code char(20) not null , e_name char(20) , e_hours int, e_salary int, primary key (code)