i have project in database : Restaurant

Project Requirements Document

$2$

Problem statementProject Evaluation

The work on the project wh be dare an praupu with $1$ mambern par group.

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

$3$

$1.$ Workflow

$$ 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.

$2.$ Project Upload Requirements

$$ One student from the group will upload the files with writing the names of

the group and their section :

$$ Upload your ER$-$diagram as image.

$$ Upload relational schema as image

$$ Upload query code as $.$SQL file

$4$

$3.$ Project Evaluation

$$ The work on the project will be done as groups with $3$ members per group.

$$ The group members will explain their work with a presentation and based

on the explanation a discussion will take place and a mark will be given