restourant pos system diagram by InfluX Design & Software

restourant pos system diagram

1. Restaurant ERD
Entities

1. Manager
 Manager id
 Manager name
 Manager address
 Phone numbers
 Email
 NIC
 Date_of_Birth
2. Customer
 Customer id
 Customer name
 Customer NIC
 Contact number
 email
3. Receptionist
 Receptionist id
 Receptionist name
 Receptionist address
 Receptionist numbers
 Email
 NIC

4. Chef
 Chef id
 Chef name
 Chef address
 Chef numbers
 Email
 NIC

5. Order
 Order id
 Order date and time
6. Bill
 Bill id
 Bill date and time
7. Ingredients
 Ingredient id
 Ingredient name
 Available quantity
8. Supplier
 Supplier number
 Supplier name
 Supplier phone
 Supplier email
 Supplier address

2. 9. Reports
 Daily_reports
 Monthly_Reports
 Report_ID

10. Recipe
 ingredients
 Recipe_ID

Normalization


Manager


Supplier


Ingredient


Reports


Order


Chef


Recipe


Receptionist


Bill


Manager_ID First_Name Middle_Name Last_Name NIC_NO Street_Addres City Date_Of_Birth Email
Supplier_ID Email Street_Addres City name Manager_ID
Ingredient_ID Name Quantity
Reporrt_ID Daily_Report Monthly_Report Manager_ID
Order_ID Date/Time Receptionist_ID Chef_ID
Chef_ID First_Name Middle_Name Last_Name NIC_NO Street_Addres City Date_Of_Birth Email
Recipe_ID Ingredients
Receptionist_ID First_Name Middle_Name Last_Name NIC_NO Street_Addres City Date_Of_Birth Email
Bill_Id Date/Time Receptionist_ID

3. Customer



Manager_Phone


Supplier_Phone


Chef_Phone


Receptionist_Phone


Customer_Phone


Supplier_Engredients


Reports_Bill


Order_recipe


Ingredient_Recipe










Customer_ID First_Name Middle_Name Last_Name NIC_NO Date_Of_Birth Email Receptionist_ID
Manager_ID Phone_Number
Supplier_ID Phone_Number
Chef_ID Phone_Number
Receptionist_ID Phone_Number
Customer_ID Phone_Number
Supplier_ID Ingredient_ID
Report_ID Bill_ID
Order_ID Recipe_ID
Ingredient_ID Recipe_ID

4. Relationships







Manager
Supplier
Customer
Receptionist
Chef
Recipe
Reports
Ingredients
Bill
City
Address
Name
Middle_Name
Last_Name
Street_Addres
s
First_Name
Manager_ID
NIC
Email
Date_Of_Birth
Phone_Number
Name
Phone_Number
Email
Address
Street_Addres
s
City
Supplier_ID
Quantity
Name
Ingredient_ID
Daily_Report
Monthly_Report
Reporrt_ID
Bill_ID
Date/Time
Date/Time
Recipe_ID
Chef_ID Name
First_Name
Middle_Name
Last_Name
Address
Street_Addres
s
City Phone_Number
Date_Of_-Birth
Email
NIC
Receptionist
_ID
Name
First_Name Middle_Name
Last_Name
Email
NIC
Date_Of_-Birth
Address
Street_Addres
s
City
Phone_Number
Customer_ID
Email
Phone_Number
Name
NIC
First_Name
Middle_Name
Last_Name
Inform
ed by
supply
has
Order
Order_ID
Ingredients
placed by
create
has
pay
Prep
ared
by
add
Are
had
by
m
1
n m
m
n
m
1
m
1
m
n
1
m
m
n
1
m
1
m