Restaurant Management System Analysis

Running head: RESTAURANT MANAGEMENT SYSTEM
RESTAURANT MANAGEMENT SYSTEM
Name of the Student
Name of the University
Author note

RESTAURANT MANAGEMENT SYSTEM1
Table of Contents
Business Rules.................................................................................................................................2
Conceptual EERD (Enhanced entity relationship diagram)............................................................3
Logical Schema...............................................................................................................................4
Table’s Description..........................................................................................................................5
Index create (Unique)......................................................................................................................9
Queries...........................................................................................................................................10
Query 1......................................................................................................................................10
Query 2......................................................................................................................................10
Query 3......................................................................................................................................11
Query 4......................................................................................................................................12
Query 5......................................................................................................................................12
Bibliography..................................................................................................................................14

RESTAURANT MANAGEMENT SYSTEM2
Business Rules
Business Rules of an organization can represents the business process and functionality
of the company and how it works. In developing the, System design for the organization it also
helps in the modelling. Here the Entity relationship diagram is developed using the business
rules and assumptions. The business rules for the restaurant management system can be
described as follows:
i. The restaurant has many products which it servers and delivers to their customers.
ii. The restaurant has multiple type and cuisines in their menu.
iii. The restaurant has multiple employees for receiving orders and serving food to their
customers.
iv. Each Food product is associated with one and only one category.
v. Each category can have multiple food products.
vi. Each customer can order one or more orders selecting products from the menu.
vii. Each order can have one or more than one product items.
viii. Each product can also be associated with one or more than one orders.
ix. One order can only be associated with only one customer. Customer can select the mode
of delivery or eat on the location.
x. The delivery types are either home delivery or pickup.
xi. Each employee can receive one or more than one order requests.
xii. All the basic details of the employees and customers are stored in the system. For
example name, address, city, contact for both and salary details for the employees.
xiii. Customers can pay for their order by cash, debit card, credit card or using PayPal.
xiv. Each payment details is associated with one on only one order records.

RESTAURANT MANAGEMENT SYSTEM3
Conceptual EERD (Enhanced entity relationship diagram)
Figure 1: Conceptual Diagram
Source: created by author