Answered step by step
Verified Expert Solution
Question
1 Approved Answer
An international Restaurant has several branches around the world! Wants to make its own web application. This application is used to automate day to day
An international Restaurant has several branches around the world!
Wants to make its own web application.
This application is used to automate day to day activity of a restaurant that serves
people all over the world with ready-made food.
The branch has numbers of waiters, chiefs in addition to manager who is
responsible for the branch and a cashier
Each branch has own inventory which has the required ingredients that
Chiefs needed to make the meals, if the amount of ingredients become low in the
inventory, the suppliers supplies the inventory with required Ingredients.
This application will show the available meals in each branch, each meal will be
under specific category and has a brief description and price.
Any customer can register to the application and put his information like his name,
phone and address and another information.
The customer can book a table in the branch if he wants for a certain period of time
and he can request order from the waiter then pay to the cashier.
The cashier will send the bill with details of the order to the customer
So when the customer arrived, everything will be ready!
The order may it consists many meals or just one
After the customer finishing, he gives a report or feedback which reaches to the
manager of the branch
Draw suitable ER-diagram for the previous scenario, dont forget to cover
types of attributes, entities and relationships
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started