databse project $($Please don$$t tell me you can do or you will do I will rate dislike I want solution$)$ : An international Restaurant has several branches around the world!

Wants to make its own web affpplication.

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

inv:entory, 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, don$$t forget to cover types of attributes, entities and relationships $$ choose suitable attributes for each entity as you like $$ make sure you cover the scenario in the ER$-$Diagram $$ Draw the relational schema by Mapping the previous ER$-$diagram $$ Build your relational schema using SQL server. $$ The required constraints are Primary Key and Foreign Key $$ Add to each table $4$ suitable records and display the result.