Abc Assignment Help

Automating Order Collection Process of M&J chickens


Information System Requirements Specification Document

1. Introduction

1.1 Organisation/Department Under Study

This section describes the organization/Department under study, its business and function.

1.2 Purpose 

This section describes the purpose of this report, and explains the new Information System very briefly, and notes if it is the whole system or part of a larger system. 

1.3 Existing (Manual) System

This section describes how the processes are currently operated in the organization under study. It also explains the manual system, and the business processes currently in place. 

1.4 Proposed New Information System

This section describes the proposed new IS, and its associated business processes.

2. Analysis of the Existing System

2.1 Data Flow Diagrams

Draw DFDs for the existing system.

2.2 Describe Data Handling 

Describe how data is currently captured, stored, processed and disseminated in the existing (manual) system (eg., forms, folders, cabinets, reports etc).

3. Design of the New IS

3.1 Overview

Explain the aim of the new IS. What you would like to achieve through the new IS which wasn’t achievable in the existing manual system. Who are the actors of the new system.

3.2 Use Cases

Draw the overall use case diagram followed by diagrams for all use cases.

  1. Overall Use Case

  2. Use Case 1 

  3. Use Case 2 

  4. Use Case 3

3.3 Data Flow Diagrams

Draw the overall DFD (also called context diagram) followed by diagrams for all DFDs as required.

  1. Overall DFD

  2. DFD 1 (Name)

  3. DFD 2 (Name)

  4. DFD 3 (Name)

3.4 Data Modelling

  1. Entity Relationship Diagram

Draw the ERD for your system using the notation introduced in the class (include entity names, attributes, PK/FK, relationship names, relationship types (connectivities)).

  1. Data Dictionary

Provide the data dictionary for your ERD.

  1. Relational Schema (database design)

Draw the relational schema for your ERD.

3.5 User Interfaces

Provide the text description of each user interface your new system has (eg, main menu, data entry forms, adding/editing/deleting etc). If you would like to include figures, you can insert in appendices.

3.6 Managerial reports

List and explain various managerial reports (and queries) that your new IS is able to produce. Managerial reports are very important as they provide input which inform managers’ decisions. The more useful, and innovative your reports are, the higher your mark for this assessment (also the more the reports, the better). You can use the following sub-headings, if you want, to explain your reports in a more structured way:

  1. Report 1 (Name)

  2. Report 2 (Name)

  3. Report 3 (Name)

  4. Report 4 (Name)

4. Plan for Implementation

This section explains your plan for implementing the proposed IS (final report and presentation due in week 11). It should include project schedule (eg, using Gantt chart, PERT, CERT, or at least a table listing activities/timing/persons assigned to do).

Appendix: 

If you would like to include any text, figure, table as side information, you can inset here (example, user interfaces if you have already created).

Answer

Introduction 

2.1 Organization Under Study 

M&J chickens is a growing business in Sydney. It is located in the Marrickville. The business offers customers raw and cooked chicken. The customers are mainly shops, pubs, restaurants etc. Currently, they are using a manual process to take and process orders. That is leading to errors in the order processing system and poos customer service. The result is loss of and trust in the market. The customer service manager of M&J Chicken has decided to design, develop, and implement an online order taking system to automate the order collection process and to allow customers in accessing their dedicated customer portal and to take online payments. 

2.2 Purpose 

The purpose of the system is to help the business in automating their order collection process and to make their workflow error-free. It will also help to improve the customer services and to retain customers. Other than that, the system will also help to reduce the staffing cost and staffs will be able to be more productive. 

2.3 Existing (Manual) System 

In the existing system, a customer comes in person or calls M&J Chickens to place an order or to inquire. There are six staffs who attends the calls and take orders manually. That is leading to dissatisfaction among the customers, errors in orders, and bad customer services.

2.4 Proposed New Information System 

The proposed new system is an online web based system. It will automate the order collection, online payment and customer service processes. It will introduce an order form, an inquiry form, and a customer portal. The order form will help to take orders online along with online payment. The inquiry form is there to allow the customers to send queries and the staffs may reply to the queries. 

The customers will be able to set their collection date and delivery option. The business will deliver the orders to the customers. 

Analysis of the Existing System 

3.1 Data Flow Diagrams 

The context diagram of the existing manual process is, 

context diagram of the existing manual process


The data flow diagram of the manual process is, 

data flow diagram of the manual process

3.2 Describe Data Handling 

In the existing system all data are handled using pen and paper. The order details are taken over the phone. The details of the customers, orders, products, stocks etc. are managed using manual data entry and data handling processes. 

Design of the New IS

4.1 Overview 

The proposed new information system will be a web based system that the users can access from their computers and / or mobiles. A customer needs to make a profile first. Then the customer will be able to place an order for raw or cooked chicken. The customers can check in real-time whether the order is accepted or not. If the order is not accepted then one of the staff will call and take care of the order. If the order is accepted, the customer will be redirected to a payment page and must pay for the order. Once the customer makes payment, the order confirmation number will be sent to the customer. The customer can use that for further reference to the order. The customer will provide information about collection or delivery of the order. The staffs will process and prepare the order and then either will keep that for collection or deliver to the customer’s address. 

Customers can place an enquiry and staffs will reply to that. Other than that, customers can check their past order details and current order details from their customer portals. 

4.2 Use Cases 

4.2.1 Overall Use Case

The overall use case diagram is, 

The overall use case diagram

4.2.2 Use Case 1: Create Account

A New customer can create a profile. The system will save the profile details and generate a unique username for the customer. The customer can set his/her own password. 

Creating Account

4.2.3 Use Case 2: Check Profile

A registered customer can login using valid credentials like username and password and check his/ her profile. The customer can make changes in the phone number, address etc. of the profile. 

Check Profile

4.2.4 Use Case 3: Search Catalog

A registered customer will be able to select an option to order. The catalog contains the details of the items, descriptions and the prices. It will also show information about whether the product is available or not. 

Search Catalog

4.2.5 Use Case 4: Place Order

A register customer gives order details and proceed to payment. The order details include, the unique order number generated by the system, data of order, items ordered, quantity of each ordered item, total price etc. 

Place Order

4.2.6 Use Case 5: Make Payment

A registered customer places an order and makes payment using credit card. System will save the order details and forward it to the order processing staff. And system will return a confirmed order no. and the same order number will be used to prepare and deliver the order.  

 Make Payment

4.2.7 Use Case 6: Order Tracking Company 

Once an order is confirmed, a customer can track order, system will response with the tracking details. There is an external system called ‘Logistic Company’ connected to the use case. It further expands the use case into two other use cases within the boundary of the ‘Logistic Company’. Those two use cases are,

4.2.7.1 Order Status 

The user can check the status of an order by entering the order number. 

Order Status

4.2.7.2 Update Order Status 

The system will automatically update the status of the order based on data collected from other actors and the process running within the system. 

Update Order Status

4.2.8 Use Case 7: Ask Question

A registered customer can place a query, system will forward the query to a staff. Once a staff replies on it, the system will return the answer to the customer. 

Ask Question

4.2.9 Use Case 8: Generate Reports

Manager will be able to generate reports under different conditions and requirements. The system will generate all reports.

Generate Reports

4.2.10 Use Case 9: Check Orders

A staff gets notification about new order and opens it to view the details. The staff will be able to see the delivery details and item details of the orders. The staff will also see the customer details for the order. The staff can communicate with the customer for the order if required. 


 Check Orders

4.3 Data Flow Diagrams 


4.3.1 Overall DFD 

The context diagram is, 

 Overall DFD

4.3.2 DFD 1

The DFD 1 is, 

DFD 1

4.4 Data Modelling 

4.4.1 Entity Relationship Diagram 

The ER diagram is, 

The ER diagram

4.4.2 Data Dictionary

TableAttributeDate typeKey
CustomerCustIDINTPrimary key

FullNameText

AddressText

PhoneText

EmailText

CreditCardText
StaffStaffIDINTPrimary key

FullNameText

JoiningDateDate

RoleText
ProductProdIDINTPrimary key

ProdDescText

StockBoolean

UnitPriceDecimal(5,2)
OrderOrderIDINTPrimary key

OrderDateDate 

NeedDeliveryBoolean

DeliveryDateDate 

StaffIDINTForeign Key

CustIDINTForeign Key
OrderLineOrderIDINTPrimary key, Foreign Key

ProdIDINTPrimary key, Foreign Key

QuantityDecimal(5,2)
PaymentPaymentIDINTPrimary key

AmountDecimal(7,2)

PaymentDateDate 

OrderIDINTForeign Key
QueryQueryIDINTPrimary key

CustIDINTForeign Key

DateDate 

StatusText

DetailsText 

StaffIDINTForeign Key


4.4.3 Relationship Schema 


Customer (CustID, FullName, Address, Phone, Email, CreditCard)

Staff (StaffID, FullName, JoiningDate, Role)

Product (ProdID, ProdDesc, Stock, UnitPrice)

Order (OrderID, OrderDate, NeedDelivery, DeliveryDate, StaffID, CustID)

OrderLine (OrderID, ProdID, Quantity)

Payment (PaymentID, Amount, PaymentDate, OrderID)

Query (QueryID, CustID, Date, Status, Details, StaffID)

4.5 User Interfaces 

Login Interface

Login Interface

Once a customer is logged in, the home page will be, 

Homepage

A customer can do any of the five functionalities. When a customer clicks on the ‘Place New Order’ button, then the next screen will be, 

Pace new order screen

The customer will select product, quantity, and the delivery date. Then it will proceed to the next screen that is the payment screen. 

Payment screen

Here, the customer will enter credit card details and can save the card for future. Once payment is made, there will be a popped up dialog box saying the order is confirmed and with an order number, 

Card details

Once order is confirmed and payment is completed, within 3 minutes, the portal will be back to the home screen automatically. Within the time, the customer can note down the order ID for further reference. 

From the home screen, a customer can select ‘Track order’ button and can track a confirmed order on the following screen. 

Track order screen

Once the tracking details is shown. The customer can go back to the home menu again. From there, the customer can choose to ‘View Past Orders’ and will go to the next screen. From there a customer can come back to the home screen. 


From the home screen, a customer can select to ‘Update Profile’ and update either address or phone number from the next screen. 

Update profile screen

Once completed, customer can go back to the home menu and may select to place a query. The next screen will be, 

Place a query screen

A customer can check FAQ while placing a query.  

4.6 Managerial Reports 

4.6.1 Report 1: Customer Report 

Manager will be able to generate a customer report, it will show the details of the customers. The manager can sort the report using different columns and may filter data. For example, a manager can ask to generate the report on the customers who have not placed any order yet. 

4.6.2 Report 2: Order Report 

Manager can generated order summary report sorted and filtered by different conditions. 

4.6.3 Report 3: Pending Orders Report 

A manager can produce the pending order report and distribute to the staffs. 

4.6.4 Report 4: Delivery Report 

Manage can generate a report containing the delivery details of the orders scheduled for delivery on the same date. 

4.6.5 Report 5: Sales Report 

Manage can generate detailed sales report to assess performance of the sales department.

Customer Testimonials