Fuel Reporting and Employee Roster Management System

Information System Project 1 0
INDORMATION SYSTEM PROJECT 1
By Name
Course
Instructor
Institution
Location
Date

Information System Project 1 1
Table of Contents
List of Table.....................................................................................................................................4
List of Figures..................................................................................................................................4
1.0 Overview...............................................................................................................................6
1.1 Introduction.......................................................................................................................6
1.2 Document Overview.........................................................................................................7
1.3 Deliverables...........................................................................................................................7
2.0 Software Design Specification.............................................................................................7
2.1 Business Component Design.................................................................................................8
2.1.1 What................................................................................................................................8
2.1.2 Why.................................................................................................................................8
2.1.3 When...............................................................................................................................9
2.1.4 How.................................................................................................................................9
2.1.5 Who.................................................................................................................................9
2.2 Front End Design.................................................................................................................15
2.3 Workflow and Process Design.............................................................................................27
2.3.1 Activity Diagram for Pay Fuel.....................................................................................28
2.3.2 Sequence Diagram........................................................................................................29
2.4 Security and Control Design................................................................................................31

Information System Project 1 2
2.4.1 Handshaking.................................................................................................................31
2.4.2 Authentication...............................................................................................................32
2.4.3 Encryption.....................................................................................................................33
2.4.4 Authorization................................................................................................................34
2.5 Database Design..................................................................................................................35
3.0 Project Management................................................................................................................40
3.1 Requirements Traceability...................................................................................................41
3.2 Risk Management Plan........................................................................................................42
3.3 Monitoring and Control.......................................................................................................42
4.0 Conclusion...............................................................................................................................44
References......................................................................................................................................45

Information System Project 1 3
List of Table
Table 1 Business Processes Description..........................................................................................9
Table 2 Actors................................................................................................................................10
Table 3 Check Fuel Consumption Use Case.................................................................................11
Table 4 Book Fuel Use Case.........................................................................................................11
Table 5 Make Payments Use Case.................................................................................................11
Table 6 Record Fuel Consumption Use Case................................................................................11
Table 7 Manage Customers Use Case...........................................................................................12
Table 8 Manage Employee Use Case............................................................................................12
Table 9 Requirement Traceability Matrix.....................................................................................40
Table 10 Risk Plan.........................................................................................................................41
Table 11 Gannt chart.....................................................................................................................42
List of Figures
Figure 1UML Use Cases...............................................................................................................10
Figure 2 ERD.................................................................................................................................13
Figure 3ERD Cardinality...............................................................................................................14
Figure 4 Login Page Design..........................................................................................................15
Figure 5Admin Welcome Page Design.........................................................................................16
Figure 6 Add Employee Form Design..........................................................................................17
Figure 7 Edit Employee Form Design...........................................................................................18
Figure 8 Disable Employee Form Design.....................................................................................19

Information System Project 1 4
Figure 9 Customer Welcome Page Design....................................................................................20
Figure 10 Pay Fuel Form Design...................................................................................................21
Figure 11 Customer Fuel Consumptions Page..............................................................................22
Figure 12 Customer Payments page design...................................................................................23
Figure 13 Employee Welcome Page..............................................................................................24
Figure 14 Employee Add Payment Form Design..........................................................................25
Figure 15 Employee Sales Page Design........................................................................................26
Figure 16 Activity Diagram...........................................................................................................27
Figure 17 Sequence Diagram.........................................................................................................28
Figure 18 Class Diagram...............................................................................................................29
Figure 19 Authorisation.................................................................................................................31
Figure 20 Encryption.....................................................................................................................32
Figure 21 Form Field Validation...................................................................................................34
Figure 22 database Design ERD....................................................................................................35
Figure 23 Admin Table..................................................................................................................36
Figure 24 Employee Table.............................................................................................................36
Figure 25 Customer Table.............................................................................................................37
Figure 26 Booking Table...............................................................................................................38
Figure 27 Purchase Table..............................................................................................................39

Information System Project 1 5
FUEL REPORTING AND EMPLOYEE
ROSTER MANAGEMENT SYSTEM
1.0 Overview
The main purpose for writing this software design specification is to provide a detailed
architecture and low-level design for the proposed Fuel Consumption Report and Employee
Roster Management hereinafter referred to as FCRERM. This designs will not only be useful to
the developers in achieving the client’s user requirements in a more efficient and effective way
but also enable the developers to have a better understanding of the proposed system which is
facilitated by the good communication the design have and the several views of the system
provided by the designs.
1.1 Introduction
The current fuel consumption management system used by the Dynasoft filling station is
marred with a lot of challenges due to the manual nature of most of its operation especially
recording the fuel consumed by the clients on a daily basis (Anund and Kircher, 2009). Most of
the data is fed into a manual counter book by the attendant, making it difficult for analysis and
forecasting due to its inability to provide a good visual report of the consumption rate. Employee
management of the pump firm is also manually kept in manual HR files and it is difficult to track
employee activities as such things as leave and timesheet are done manually (Urquhart et al.,
2009). It is in this regard that Dynasoft requested an information system to help solve the
situation. The software requirements specifications (SRS) of the proposed system had been
documented and handed over. The detailed design of FCERM is discussed in this document. A
detailed outline of the document is explained below.

Information System Project 1 6
1.2 Document Overview
The chapter following next has described the software design specification which entails
the business component design, front-end design, workflow, and the process designs, security,
and control design and last but not the least, the database design which is key as it provided how
data is designed and relationships among the data entities.
The third chapter which finalizes the document by providing a detailed project
management in terms of requirement traceability from the SRS, the project risks and risk
management plan and project monitoring, evaluation and controls put in place to ensure the
proposed system is a success.
1.3 Deliverables
The SDS seeks to deliver the following items which shall be used during the project
development lifecycle,
 A complete software design specification document detailing the architectural and low-
level designs diagrams such as Use Case, Sequence, activity, database, and class
diagrams for the FCERM proposed a system.
 A risk management document which entails the risk identification, assessment, and
mitigation plans.
 The project schedule which identifies key milestones and deliverables.
2.0 Software Design Specification
This section provides the details of the design from the high level architectural and
business design to very low-level process, workflow, database and user interface design
(Class, 2018). The goal of this section is to provide the visual design details of how the

Information System Project 1 7
system should be. The output of this section is particularly important for the developers as
they do the design into code and implementation (Cooling, 2013)
2.1 Business Component Design
This sections describe the high level design of the business component from the what the
business services the system shall provide, why the service is particularly important, when the
service should be provided and how the service will be completed, to fully design the service, the
table below was used (Laguna and Marklund, 2013).
2.1.1 What
The what question answer what the company seeks to provide the solution
for, Below are the details
i. Design and develop the FCERM system
ii. Test the FCERM system
iii. Deploy the FCERM system
iv. Optimize the FCERM system
2.1.2 Why
The why questions answer the business component design question of why
the organization has endeavored to implement the fuel consumption and
employee records system, The following details the answers to why
i. The Dynasoft seeks to automate the business process of recording
the fuel consumption of their customer usage of fuel