Database Management System for Gary Café

Running head: DATABASE MANAGEMENT SYSTEM
Database Management System
Name of the System
Name of the University

1DATABASE MANAGEMENT SYSTEM
Table of Contents
1. Current Business Activities:........................................................................................................2
2. Description of Operations:..........................................................................................................2
3. Initial ER Model:.........................................................................................................................3
4. Design Specification:...................................................................................................................3
4.1 Entity Specification:..............................................................................................................3
4.2 Attributes Specification:........................................................................................................6
4.3 Relationship Specification:........................................................................................................8
4.4 Constraints Specification:..........................................................................................................9
5. Business Rules:............................................................................................................................9
6. Normalization:...........................................................................................................................10
7. Entity Relationship Model:........................................................................................................11
8. Critical Appraisal:......................................................................................................................12
Bibliography:.................................................................................................................................13

2DATABASE MANAGEMENT SYSTEM
1. Current Business Activities:
Gary Café is located at National Library in Singapore. This was opened in early of 2014.
The Café server various consumers each day. A person takes orders from the customers. After
the food or café is complete, the order is served to the customer. The organization collects the
information of the consumers for future use. The staff of the organization work in specific days
of a week. A person maintain the information regarding the attendance of staff. The cashier takes
the payment from the customers against their orders. The report generation process is a crucial
activity in the current business process.
2. Description of Operations:
There are mainly three operations at Gary Café. These operations are described in the
following section.
i. Collecting Order: In this operation, the waiter collect orders from the customers.
The customers can order for a single person or a group. The orders can have one
or multiple menu items. The Café will store all the orders against a single person.
ii. Collecting Raw Material: The café will buy raw materials from local farms. The
contact numbers and address of the local farm is an important data to have. The
café will have the relevant information of the raw materials collected.
iii. Maintaining Storage: Maintaining the storage of the Café is a vital operation.
The café will determine how much raw material is required for single day. The
Café will order new stock of raw materials if it is not present in required quantity.

3DATABASE MANAGEMENT SYSTEM
3. Initial ER Model:
Figure 1: The Initial ER Model of Gary Café
(Source: Created by Author)
4. Design Specification:
4.1 Entity Specification:
Owner: