Cyber Caf Management System Analysis Report

1
Cyber CaféManagement SystemAnalysis Report

• Chan Chi Hang(2)
• Lok Chi Hang(15)
• Pang Wing Hong(16)
• Tse Kit Ming(18)
• Yeung Pak Fai(20)

2
Presentation Schedule

• Updated requirement and problem
• Entity and Relational diagram
• Data Flow Diagram
• Conclusion

3
Background

• Develop a effective, efficient and reliable Cyber
  Café Management System
• provide a smooth operation in new system

4
Updated Requirement

• We separate the requirement into two parts
• 1.     System Requirement
• 2.     Functional Requirement

5
System Requirement.

• Palm PDA devices for remote data entry
• Backend system on PC supporting multi-user on
  networked environment
• Pc and network availability and reliability

6
System Requirement

• Network security and regulation setting
• Orders from Internet might be supported

7
Functional Requirement

• PDA Function
• System Function

8
PDA function

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

9
System Function

• Table Reservation
• Food Ordering
• Serving Status
• Billing

10
System Function

• Internet Services
• Data processing and report generation
• Management Function

11
Updated Problem

• Problem of current system
• Inefficient way to transfer draft
• Calculating bill in slow speed
• Confusing counters paper work
• Poor handwriting
• Difficult to manage the staff

12
Updated Problem

• Draft lost or damage
• Difficult to follow,change order
• Difficult to keep records
• Human error

13
Entity and Relational diagram
14
Normalized Entity Relationship Diagram (ERD)
System
Palm
15
System ERD
Reservation
Staff
Table_Type
Invoice
Table
Order
Palm
Computer
Menu
Material
Item
16
Normalized System ERD
Palm
17
Palm ERD
System
Palm_Billing _Request
Palm_Order
Palm_Menu
Palm_Item
18
Normalized Palm ERD
System
Palm_Billing _Request
Palm_Order
Palm_Order _Menu
Palm_Menu
Palm_Menu _Item
Palm_Item
19
Data Flow Diagram
20
Context
21
Functions of Cyber Café System
22
Table Processing
23
Table Reservation
24
Table Allocation
25
Order Processing
26
Taking Order
27
Passing Order
28
Maintain Order
29
Service Status
30
Billing
31
Management
32
Maintain Files
Table Detail
33
Report Generation
34
Accessing Internet
35
Delivery Food
36
Conclusion

• Order by PDA
• Report to help managers decision
• Maintain the food stock
• Security
• Reliable and Efficient

37
The End
38
Reservation

• - Table Reserved Time
• Table Booking Time
• Customer's Additional Requirements

in person
via tel.
39
Table_Type
Type 1
Type 2
40
Table
? occupied
? available
41
Computer

• Login Name
• Password

42
Order
?
Order

• Palm Billing Request No.
• Staff ID
• Table No.

43
Staff

• Salary
• No. of Day-off
• Working Time

44
Invoice

• Invoice No.
• Order No.
• Enter Time
• Leave Time

XXX Enter Time Leave Time
xxxx xxxxx
xx xxxxx xx
xxxxx xx Total
XXX
45
Menu

• Menu No
• Menu Name
• Menu Price

46
Item
- Item No. - Item Name - Item Photo - Item Code
47
Material

• Material No.
• Material Name
• Material Quantity
• Material Re-order Level
• Material Expense