Personal Details
16. If the system currently operating has a default or system jammed, how do you overcome the problem?
We managed to use other nearby Pizza hut to help with our problems. But until now only once we had this system problem due to the phone connection failure. But it was functioning well in 1/2 hour.
Systems Analysis and Design
Waiters on Wheels
Summary of findings
Based on the findings using questionnaires, we found out that many people still disagree or not satisfied with the delivery system and the restaurant's delivery hotline. When we make this random questions handout to several people, we get to gather some valuable information about the system. Some of them comment on the late delivery and the restaurant delivery hotline is always busy or unattended. Some even comment about the food, where when it is delivered it is not hot and fresh.
The take-away and dine in is the most preferred. This is because the service is good and the food is served hot and fresh. They don't prefer delivery service because the drivers are normally late and rude. The distance of one randomly selected people home from the restaurant is within 1 km but the driver takes about 30-40 minutes to reach the customer home. This does make sense that the delivery service is poor and need to upgrade to even fast and quicker delivery.
There is a minor group who complains that they can‟t order thru online because of limited restaurant have the access to make online ordering. They also have hassle to have two or more item order because they need to call and list their order in different restaurant. This is actually making the people waiting for so long plus need to make many calls to different restaurant. This minority also prefer to have online ordering that can make orders to many restaurant in just 1 click. This makes them hassle-free and can order different types of food at once.
So we can conclude that people prefers to have a better quality food, better ordering system, quicker delivery and also more reasonable delivery charges. The public opinion we receive is under our project to create a better system. This makes our findings relevant with what our project aim is.
Systems Analysis and Design
Waiters on Wheels
Logical Design
Systems Analysis and Design
Waiters on Wheels
CONTEXT DIAGRAM
• A data flow diagram (DFD) of the scope of an organizational system that shows the system
boundaries, external entities that interact with the system and the major information flows between the entities and the system.
• is a top-level view of the information system
• has one process symbol representing the entire information system • has the external entities around the perimeter of the page
• use data flow to connect the external entities with the process • do not show data store
GOAL
Context diagram is shown to view a simple and top level view of information system and entities. It is easy to understand and not so complicated.
Process Flow
The process is mainly the Food delivery management system where customer, drivers, restaurant, accounts department are the entities. Firstly customer give in registration details, login-password and makes order to the food delivery system. In other hand, the system will produce receipt to the customer in return. Second entity is the restaurant, where it receives the food order from the system and will send an order status to the system. Third entity is the drivers, which they will receive the delivery request from the system and they will sent a delivery status back to the system. The last entity is the accounting department where the system will sent a financial report to the accounts department.
Systems Analysis and Design
Waiters on Wheels
DATA FLOW DIAGRAM LEVEL 0 & 1 (DFD L0 & L1)
Data flow diagram is a versatile diagramming tool. With four symbols, we can use data flow diagram to represent the both physical and logical event. DFD Lo is also known as child diagram which is exploded from parent diagram, DFD L1
GOAL
DFD is a basically shows the connection between inside and outside the business unit. The whole data flow diagram are drawn to ease the user and others to see how each process is done and what are the input and outputs involved. The diagram is levelled and well balanced throughout the diagram.
Process Flow
We begin the process with the child diagram or the DFD L0. The customer begins as a source by login and password. Then the process 1 starts to check the customer‟s account by referring the customer table which is
Systems Analysis and Design
Waiters on Wheels
a data store. If customer registers for the fist time, then the registration details is then sent to customer table via update customer master process. Process 3 start when customer orders food by telephone or thru the net. The item is then refers to the food table which is a data store. Later the list of ordered items then refers to the order table (data store). Process 4, generates order send formatted food orders to the restaurant (source). Process 5 update order status in order table and after order completed is then proceed to the process 6 which is informing the driver. Driver id is done by the drivers table (data store) and the driver is the source. The driver takes the receipt and the food delivered to the customers and report, where process 7 begins. Financial report plus the invoices are then sent to the accounting department.
DFD L1- is actually the explode part of the DFD L0. There is 3 different process is being explode. Process 3.0 is 1 part that explode where orders, customers ID, item id is sent to process3.1 which is select food item from menu. The selected item is then progressed to process 3.2 which is Add food item to list. In this process, list of ordered item is then sent to the restaurant, if not there is add more selection option which is sent to process 3.1.
Process 6 is exploded in into process 6.1 and process 6.2. The drivers ID is sent to the process 6.1 which is identify free driver. When a free driver is available and is alerted, process 6.2 begins which is Generate delivery request. In this process, complete order information is receive and delivery request will take place. Process 7 is then exploded in to process 7.1, 7.2 and 7.3. Process 7.1 which is generates receipt actually receive order details and generates receipt to the customer. The driver then returns the receipt in process 7.2 which is generates financial report. After receiving the receipt and match the order details, it is then sent to the financial report. Process 7.3 is move temporary order table, which has a temporary order list or table stored in an order history database.
Systems Analysis and Design
Waiters on Wheels
DATA FLOW DIAGRAM LEVEL 0 & 1 (DFD L0 & L1)
Data flow diagram is a versatile diagramming tool. With four symbols, we can use data flow diagram to represent the both physical and logical event. DFD Lo is also known as child diagram which is exploded from parent diagram, DFD L1
GOAL
DFD is a basically shows the connection between inside and outside the business unit. The whole data flow diagram are drawn to ease the user and others to see how each process is done and what are the input and outputs involved. The diagram is levelled and well balanced throughout the diagram.
Process Flow
We begin the process with the child diagram or the DFD L0. The customer begins as a source by login and password. Then the process 1 starts to check the customers account by referring the customer table which is a data store. If customer registers for the fist time, then the registration details is then sent to customer table via update customer master process. Process 3 start when customer orders food by telephone or thru the net. The item is then refers to the food table which is a data store. Later the list of ordered items then refers to the order table (data store). Process 4, generates order send formatted food orders to the restaurant (source).
Systems Analysis and Design
Waiters on Wheels
Process 5 update order status in order table and after order completed is then proceed to the process 6 which is informing the driver. Driver id is done by the drivers table (data store) and the driver is the source. The driver takes the receipt and the food delivered to the customers and report, where process 7 begins. Financial report plus the invoices are then sent to the accounting department.
DFD L1- is actually the explode part of the DFD L0. There is 3 different process is being explode. Process 3.0 is 1 part that explode where orders, customers ID, item id is sent to process3.1 which is select food item from menu. The selected item is then progressed to process 3.2 which is Add food item to list. In this process, list of ordered item is then sent to the restaurant, if not there is add more selection option which is sent to process 3.1.
Process 6 is exploded in into process 6.1 and process 6.2. The drivers ID is sent to the process 6.1 which is identify free driver. When a free driver is available and is alerted, process 6.2 begins which is Generate delivery request. In this process, complete order information is receive and delivery request will take place. Process 7 is then exploded in to process 7.1, 7.2 and 7.3. Process 7.1 which is generates receipt actually receive order details and generates receipt to the customer. The driver then returns the receipt in process 7.2 which is generates financial report. After receiving the receipt and match the order details, it is then sent to the financial report. Process 7.3 is move temporary order table, which has a temporary order list or table stored in an order history database.
Systems Analysis and Design
Waiters on Wheels
ENTITY LIFE HISTORY (ELH)
ELH is a diagrammatic technique that provides of all possible biographies for any occurrence of a particular entity in the system. An entity is created-amended-deleted. This 3 process is involved in this whole Entity Life History.
GOAL
To create an Entity which can be clearly viewed the diagram. The process will have and complete flow form the entity creation, entity modification till entity deletion. This data wil much easily understood by user.
Process Flow
Initial identification of events, Constructing the Event / Entity Matrix, Drawing initial Entity Life Histories for all entities, Completion of the Entity Life Histories, Addition of operations, Addition of state indicators. This 6 process is what involved in this ELH. Firstly the events need to be identified. For example like customer‟s event is to log on, placing orders and so on. Secondly is to construct the event and entity. This is the part where we start to list out the entity and also the event. Thirdly, draw initial ELH for all entities. Now the process of drawing the flow chart begins. Completion of the entity comes in next where all the lines are placed or arranged in a proper way. Addition of operation plus the addition of state indicators and the last step involved in this ELH where the process is completed with the symbol of (“0” “*” “1”).
The process begins with customers. Customer is the entity involved and the events are Log on, new account registration, order, customer can modify these events by changing the food item and the registration part. Events are then deleted at the end of the event, such as account deletion and food orders are canceled. Second entity involved is the driver and the events are delivery request, receipt, amount and extra charges, delivery status report.
Third entity involved is Restaurant and the events are orders request, food preparation, invoices issued. The second event which is the food preparation can take place 0 or many times.
Systems Analysis and Design
Waiters on Wheels
USE CASE DIAGRAM (UCD)
UCD is a process of modelling a system‟s functions from the perspective of external users using a tool called use cases.
GOAL
The main thing is to help identify objects and their high-level relationships and responsibilities. It is also an effective communication tool and as a basic for a test plan or user‟s manual.
Systems Analysis and Design
Waiters on Wheels
Process Flow
To begin with the Use Case Diagram, firstly need to identify any additional actors and Use Cases. This can be reviewed in the context model diagram. Secondly construct a Use Case Model. This model is consists of two symbols- the actor and the Use Case symbols (oval shape). Thirdly Document the Use Case Course of event. This is a basic documentation where requirement Use Case is applied. Fourthly define the analysis Use case. Once the requirement is complete, the analyze process begin in which will specify how or implementation specified.
The actors are Customers, Telephone operator, Restaurant worker, Driver, Manager. The customer begins with the online order food and then generates food orders to the restaurant worker. The person then inform driver to pick up the order. The driver will then deliver the food to the customer with receipt. Drivers report back to produce management reports, they hand in the day end receipt. Customers can also orders thru the Telephone Operator. The operator then order food via online and generates food orders to the restaurant worker and the process goes on.
Systems Analysis and Design
Waiters on Wheels
CLASS DIAGRAM
Class diagram depict the system‟s object structure. They show object classes that the system is composed of as well as the relationship between those object class as defined by Whitten (2001).
GOAL
The object the class is said to be persistent if it outlives the execution of the program. This means the object the class describe will be stored in a database. It also shows what classes of objects are required without
Systems Analysis and Design
Waiters on Wheels
showing how the objects might be implemented or how the user might interact with them. This means that user will get a clearer view by looking at the diagram on how the system related together.
Process Flow
The process of class diagram consists of 3 steps- identify associations and Multiplicity, Identify Generalization relationship and aggregation relationship. Each class has 3 parts; name, attributes, Operations.
The numbers and symbols representing cardinality/ multiplicity include a “1” for one and asterisk (*) for many. The process starts with customer where they can attribute and the operation will proceed. This class link to another class where many customers can make many orders. Orders can be made only 1 and that 1 order can have many food items. In that same time, another class is connected which is order and restaurant. Many orders can be taken but only 1 and only 1 restaurant can process at time. The restaurant which is 1 and only 1 can issue many invoices. Invoices are then send to 1 and only 1 driver the drivers can deliver many food but report at 1 and only 1.
Systems Analysis and Design
Waiters on Wheels
Physical design
Webpage
The picture above is a screenshot of our proposed website. This is where customers are able to log in to make an online order. Specifically, the customers will be directed to this main menu of Waiters on Wheels the site address is entered. A more detailed explanation of the layout and functionality of each webpage in the site is described in the individual report of each member. (refer to „Individual Reports‟)
Systems Analysis and Design
Waiters on Wheels
ORDER.table Order _ID ITEM _ID Quant ity Amo unt Tot al Custome r_ID Addr ess Teleph one Preparation_ Status Delivery_S tatus Tim e Date 007F2 4 99RE 1 13 13 070707C 4 addre ss 777777 7 Ready Done 17: 04 4.07. 07 CUSTOMER.table
Customer_ID Name Password Full_Name Last_Name Email Tel_1 Tel_2 Delivry Address 070707C4 Mike JKL90mike Mike Romanson [email protected] 897732 Address
FOOD_ITEMS.table
ITEM_ID DESCRIPTION PRICE RESTAURANT_ID
99RE Baklava 13 R90TR
70FW Mack_Burger 9 BR2M
RESTAURANTS.table
RESTAURANT_ID ADDRESS TEL_1 TEL_2 SKYPE EMAIL SCHEDULE
R90TR Address 77432477 77432577 Arzu [email protected] 9:00-23:00
DRIVERS.table
DRIVER_ID NAME SURNAME Home_ADDRESS HOME_TEL Mob_TEL
DR9001 Farzan Seri Address 77878237 43253567
REPORTS.table
REPORT_ID ORDER_ID INVOICE_ID Date Time DRIVER_ID ITEMS_ID Quantity CUSTOMER_ID R9932123 007F24 IN555BN32 4.07.07 17:38 DR9001 99RE 1 070707C4
The above diagram shows the proposed database table that would be used in the required system. The staff will be given access to view this database that will be updated constantly every minute. Every changes and updates will therefore be synchronised instantly and all staff members would be continuously notified. When an order is placed by a customer, the Order tab would be filled with the summary of the customers‟ order and particular details. The Customer, Food Items, Restaurant, and Drivers tab would then be
automatically filled with the specific details from the Order tab. Once an order and delivery has been successfully made, the Reports tab would than summarize the status of the order and delivery.
Systems Analysis and Design
Waiters on Wheels
Appendix
Technical Specifications
HARDWARE
LIST
SPECIFICATIONS
Company Server
PowerEdge 2900• Quad Core Intel® Xeon® X5355, 2x4MB Cache, 2.66GHz, 1333MHz FSB
Additional Processor:
• Quad Core Intel® Xeon® X5355, 2x4MB Cache, 2.66GHz, 1333MHz FSB
Memory:
• 24GB 667MHz (12x2GB), Dual Ranked DIMMS Primary Controller:
• PERC 5/i, Integrated Controller Card Hard Drive Configuration:
• Integrated SAS/SATA RAID 1, PERC 5/i Integrated • 750GB 7200 RPM SATA II Hard Drive, Universal Carrier • 750GB 7200 RPM SATA II Hard Drive, Universal Carrier Non-Redundant Power Supply
Network Adapter:
• Dual Embedded Broadcom® NetXtreme II 5708 Gigabit Ethernet NIC
Documentation:
• Electronic Documentation and OpenManage CD Kit CD/DVD Drive:
• 48X IDE CD-ROM Keyboard:
• Keyboard, USB Monitor:
• Dell 15 Inch Analog Flat Panel Mouse:
• Mouse Option Hardware Support Services:
• 3Yr BASIC SUPPORT: 5x10 HW-Only, 5x10 NBD Onsite
Cost RM7974
Systems Analysis and Design
Waiters on Wheels
Staff Workstation (12 pcs)
Dimension C521
AMD Sempron™ 3400+ Operating System:
• Genuine Windows Vista™ Home Basic Monitors:
• 15 inch E157FP Analog Flat Panel Memory:
• 512MB Single Channel DDR2 SDRAM at 667MHz Hard Drives:
• 160GB Serial ATA Hard Drive (7200RPM) w/DataBurst Cache™ CD or DVD Drive:
• 48X CD-RW/ DVD Combo Drive Video Cards:
• NVIDIA GeForce 6150 LE Integrated Graphics GPU Sound Cards:
• Integrated 7.1 Channel Audio Keyboard and Mouse Bundles:
• Dell USB Keyboard and Dell 2-button Scroll Mouse Modem:
• 56K PCI Data Fax Modem Mouse
Network Interface:
• Integrated 10/100 Ethernet Miscellaneous:
• Award Winning Service and Support Labels:
• Windows Vista™ Basic Warranty and Service:
• 1Yr In-Home Service, Parts + Labor - Next Business Day Price per Workstation: $500 (x 12 systems)