Restaurants Database
Problem Description/Scenario
A small new company is looking forward to launching a website for restaurants in Bahrain. You need
to analyze the company data requirements described below and develop a database system.
The website visitors should be able to search for restaurants using different options, including:
- The name of the restaurant,
- The type of the restaurant (e.g. Italian, Indian, Vegetarian, etc.). Note that the same
restaurant could have different types at the same time,
- Specific dishes that are available at the restaurant branches (lasagna, burgers, ..),
- The location of the restaurant.
Each restaurant has a unique name and unique ID. We need also to record the details of the
restaurant's owner that includes first and last name, CPR, and telephone number. A restaurant may
have many branches, and each branch has an ID that is unique for the restaurant only. The branch ID
is composed of a branch number and the city name. In addition, we need to record the following
information: the telephone number of the branch, the employee who manages the branch, the
number and details of the employees working in each branch. Each employee has a CPR, name, job
role and can work in one branch only.
The website visitors can view the different dishes offered by each branch. The website should show
for each dish: the name, ingredients, and price. The same dish name can be available in different
branches but it should be unique for the branch. Once the visitor decides to make an order, the visitor
should first register in the website using a valid email address (will be used as username), password,
name, and telephone number. When the registration is completed, then the customer can proceed
with the order and a unique order number will be provided. In addition, it is important to record the
order date, time, and whether the order was delivered on time. After the delivery, the customer can
login to the website and post a comment on that specific order.
Deadline: Monday 3 May 2021 (11:00 am)
Tasks to be done:
Task No.
Description
1.
Use the above information to build an E-R diagram. Note that there is some
missing information in the scenario. To complete the task, you can make
reasonable assumptions about the missing information. All the assumption
made by you must clearly be mentioned in the report before making the ER
diagram.
2.
Map the ERD to relations. Identify the primary and foreign keys for each
relation.
1
