Food Ordering System

1
Food Ordering System
2
Group members

• Lai Chung Shun(08)
• Liu Hiu Po(12)
• Sin Pak Cheung(16)
• Wong Kin Wai(18)
• Yuen Chen Hong(20)

3
Updated Requirements

• System Requirements
• Functional Requirements
• PDA functions
• System functions

4
System Requirements

• Palm devices for remote data entry
• Supporting multi-users
• Data Synchronization between Palm and PC
• PC and network availability and reliability
• Network security and regulation setting

5
PDA functions

• Menu information can be retrieved from the device
• Menu orders can entered /changed /deleted in the
  device
• Menu orders can be transmitted from the device

6
System functions

• Table reservation
• Food ordering
• Serving status
• Billing
• Internet Services
• Data Processing and report generation
• Management functions

7
System Outline

• Divide into 8 main processes

8
System Outline

• Process 1 (Booking Process)
• Process 2 (Arranging Process)
• Process 3 (Ordering Process)
• Process 4 (Billing Process)

9
System Outline

• Process 5 (Analysis Process)
• Process 6 (Maintaining Process)
• Process 7 (Monitoring Process)
• Process 8 (Internet Process)

10
DATA FLOW DIAGRAM
11
(No Transcript)
12
(No Transcript)
13
Process 1 (Booking Process)

• Process 1.1 (Enter Bookings)
• enter the booking to the system
• Process 1.2 (Change Bookings)
• change the existing booking, whether allow
  changing or not

14
(No Transcript)
15
Process 2 (Arranging Process)

• Process 2.1 (Arrange Table)
• arrange table from customer request, Booking and
  Queue
• Process 2.2 (Make Queue)
• ranking the people who are waiting for tables

16
Process 2 (Arranging Process)

• Process 2.3 (Schedule Bookings and Queue)
• ranking the booking and queue, and then send to
  process 2.1 sequentially
• Process 2.4 (Change Table)
• changing table and check whether can change table
  or not

17
Process 2 (Arranging Process)

• Process 2.5 (Check Reserved Table)
• checking the table, which is reserved by booking
  or queue, whether over the expire time for
  arrival

18
(No Transcript)
19
Process 3 (Ordering Process)

• Process 3.1 (Enter Order)
• For the Customer to enter their orders and check
  if the orders are accepted or not.
• Process 3.2 (Change Order)
• For the Customer to change their needs.

20
Process 3 (Ordering Process)

• Process 3.3 (Print Order Paper)
• for the Bartender to get the new order
• Process 3.4 (Reject the food)
• for the Customer unsatisfied the delivered foods
  to reject.

21
(No Transcript)
22
Process 3.1 (Enter Order)

• Process 3.1.1 (Check Material Stock)
• for check how many stock
• Process 3.1.2 (Check Dishes Type)
• for check the dishes Type
• Process 3.1.3 (Check Last Order Time)
• for check the last order time

23
(No Transcript)
24
Process 4 (Billing Process)

• Process 4.1 (Count Bill)
• for counting of bills
• Process 4.2 (Print Bill)
• for printing of bills to customer

25
(No Transcript)
26
Process 5 (Analysis Process)

• Process 5.1 (Calculate menu-order ratio)
• calculate the amount of each dish have ordered
• Process 5.2 (Show Peak Hour Record)
• show the Peak hour of the restaurant
• Process 5.3 (Calculate Seasonal Favour)
• for show the seasonal favour of each season or
  within a particular time period

27
Process 5 (Analysis Process)

• Process 5.4 (Show Employee Performance)
• show the employee performance, include their
  amount of late, leave early, absent, and their
  performance in different field
• Process 5.5 (Calculate Internet Time)
• calculate the total time of using Internet in the
  restaurant

28
Process 5 (Analysis Process)

• Process 5.6 (Print Monthly Report)
• get information from process 5.1 to Process 5.5
  and make a print out of the report for the
  monthly report use

29
(No Transcript)
30
Process 6 (Maintaining Process)

• Process 6.1 (Maintain Bookings)
• maintaining the D1 Bookings database
• Process 6.2 (Maintain Tables)
• maintaining the D2 Tables database
• Process 6.3 (Maintain Bills)
• maintaining the D4 Bills database

31
Process 6 (Maintaining Process)

• Process 6.4 (Maintain Orders)
• maintaining the D5 Order database
• Process 6.5 (Maintain Dishes)
• maintaining the D6 Dishes database
• Process 6.6 (Maintain Materials)
• maintaining the D8 Material database

32
Process 6 (Maintaining Process)

• Process 6.7 (Maintain Types)
• maintaining the D9 Types database
• Process 6.8 (Maintain Employee)
• maintaining the D10 Employees database
• Process 6.9 (Maintain Internet)
• maintaining the D11Internet database

33
Process 6 (Maintaining Process)

• Process 6.10 (Maintain Policies)
• maintaining the D13 Polices database
• Process 6.11 (Maintain Computers)
• maintaining the D12 Computers database
• Process 6.12 (Maintain Queue)
• maintaining the D14 Queue database

34
Process 6 (Maintaining Process)

• Process 6.13 (Maintain Employee_Types)
• maintaining the D15 Employee_Types database

35
(No Transcript)
36
Process 7 (Monitoring Process)

• Process 7.1 (Monitoring Order)
• allow user to update the status of the orders
  when orders are prepared, also it will show the
  time needed to make the dishes
• Process 7.2 (Monitoring Table )
• checks the tables status, e.g. reserve, using,
  booking, etc. Also it can show whether the
  customer has placed order or not

37
Process 7 (Monitoring Process)

• Process 7.3 (Monitoring Internet Service)
• mainly show the status of the Internet service,
  which computer is using or idle.
• Process 7.4 (Monitoring Material)
• monitoring the material stock level

38
(No Transcript)
39
Process 8 (Internet Process)

• Process 8.1 (Internet Service)
• record the login time, date and computer number
  and update the status of that computer

40
(No Transcript)
41
ENTITY RELATIONSHIP DIAGRAM
42
Entity Descriptions

• D1 BOOKINGS
• stored the booking detail from customer
• D2 TABLES
• stored the table detail and status
• D3 BILLS_TABLES
• associative entity to link many to many
  relationships between BILLS and TABLES, storing
  the tables included in each bills

43
Entity Descriptions

• D4 BILLS
• stored the bill detail to calculate the total
  amount
• D5 ORDERS
• stored the dishes ordered by customer
• D6 DISHES
• stored all dishes detail

44
Entity Descriptions

• D7 DISHES_MATERIAL
• stored the materials contained in each dishes
• D8 MATERIAL
• stored the materials detail
• D9 TYPES
• stored the dish types, to show which dishes is
  only available in morning, or afternoon

45
Entity Descriptions

• D10 EMPLOYEE
• stored the employee detail including late,
  absent, early leave times
• D11 INTERNET
• stored the login and logout time of people who
  use the computer
• D12 COMPUTERS
• stored the computer detail including computer
  status and number

46
Entity Descriptions

• D13 POLICIES
• stored the policies of the restaurant or some
  settings of the system
• D14 QUEUE
• stored the queue for arranging table
• D15 EMPLOYEE_TYPES
• stored the employee position and which part of
  the system they can use

47
Entity Relationship Diagram
48
DATA DESCRIPTIONS
49
D1 BOOKINGS
50
D2 TABLES
51
D3 BILLS_TABLES
52
D4 BILLS
53
D5 ORDERS
54
D6 DISHES
55
D7 DISHES_MATERIAL
56
D8 MATERIAL
57
D9 TYPES
58
D10 EMPLOYEE
59
D11 INTERNET
60
D12 COMPUTERS
61
D13 POLICIES
62
D14 QUEUE
63
D15 EMPLOYEE_TYPES
64
THE END