Distribution System: Analyzing and Designing Information System

This project analyzes and designs a distribution management information system for the EGO Company, focusing on addressing the company's current manual record-keeping limitations. The project encompasses a comprehensive analysis, including systems justification, business cases and benefits, and a detailed cost and schedule analysis. It includes the creation of various diagrams such as use-case diagrams, sequence diagrams, data flow diagrams (DFD level-0 and context diagram), and an entities relationship diagram. Furthermore, the project provides three screen interfaces (main menu, input screen, and reports) and a Gantt chart for project management. The solution also provides a detailed breakdown of the system's requirements, design, implementation, and testing phases, along with relevant references.

Distribution system Analyzing and Designing 1
DISTRIBUTION SYSTEM ANALYZING AND DESIGNING
[Student name]
[University name]
[Professor Name]
[Date]

2Distribution Managements Information Systems Analysis and Designs
Table of Contents
1 Systems justification................................................................................................................3
2 Business’s cases and justifications about the business’s benefits...........................................3
2.1 Business’s cases................................................................................................................3
2.2 Business’s benefit..............................................................................................................4
3 Project scopes, brief costs and schedules analysis..................................................................4
3.1 Scopes...............................................................................................................................4
3.2 Costs..................................................................................................................................5
3.3 Schedules..........................................................................................................................5
4 Use-case diagrams and sequences diagram............................................................................6
4.1 Use-cases diagram............................................................................................................6
4.2 Sequence-diagram............................................................................................................7
4.2.1 Purchasing order sequences diagram........................................................................7
5 Data flows diagrams (D.F.D level-0 and context-diagram).......................................................8
5.1 Context-diagram................................................................................................................8
5.2 D.F.D level-0.......................................................................................................................9
5.2.1 Customers registrations processes level-0 D.F.D diagrams........................................9
6 Entities relationships diagram...............................................................................................10
7 3 screens interfaces (main-menu, input-screen and reports)...............................................11
7.1 Main-menus....................................................................................................................11
7.2 Inputs screens.................................................................................................................12
7.3 Reports............................................................................................................................13
8 Gantt chart.............................................................................................................................13
9 Reference...............................................................................................................................15

3Distribution Managements Information Systems Analysis and Designs
1 Systems justifications
This distribution information system is proposed by the EGO Company limited and it is designed
to keep record of their sales made the purchases and the various workers information.
The company at the moment has no any existing system and they tend to record their transaction
information in the manual files and therefore there are a lot of limitations that they face in their
dairy operations like saving, retrieving, analyzing and updating the data that is involved in the
entire business operations.
As a result the leader had opted adopt a new system and following are the justifications:
i. The company lacks any data system.
ii. The company lacks any information’s management system.
iii. The company lacks computerized information systems.
iv. The company lacks any installed network and infrastructure.
v. The company uses manual method of storing their records.
vi. The company lacks information backing up facilities.
vii. The company had consistently been losing the operations records.
viii. The company had not been able to save the records effectively as they use manual
system.
ix. The company had been facing issues in retrieval of the records.
x. The company had not been able to do business analysis easily to make businesses
decision.
2 Business’s cases and justifications about the business’s benefits
2.1 Business’s cases
For the proposed system the below are main business cases.
i. Capturing the purchasing orders.
ii. Capturing the supplying data.
iii. Capturing selling data.
iv. Analysis for businesses profit.
v. Capturing the workers details.
vi. Capturing the clients placed orders.

4Distribution Managements Information Systems Analysis and Designs
2.2 Business’s benefit
After implementing the proposed system below the major business benefits:
i. Proposed system shall facilitate storage of the operations record.
ii. Proposed system shall facilitate easy retrieving of the operations record.
iii. Proposed system shall facilitate analyzing data.
iv. Proposed system shall facilitate the leaders to make decision.
v. Proposed system shall facilitate backup data.
vi. Proposed system shall restore lost-data when the system crashes.
3 Project scopes, brief costs and schedules analysis
3.1 Scopes
In the preparation of the entire system project the following is the scope to be covered:
i. Performing system’s requirements analysis.
ii. Identifying the proposed system’s requirements.
iii. Preparing a system designing.
iv. Preparing the system databases design.
v. Preparing the systems interfacing.
vi. To make a data flow diagram.
vii. To make the use case diagrams.
viii. To make a sequence-diagram.
ix. To make a project Gantt’s charts diagrams.
x. To make a system database entity’s relationships diagrams.
xi. To do the implementation of the system interface using chosen programming
language.
xii. To implement the system databases through the proposed databases system (Tycho,
2014).
3.2 Costs
To implement the proposed system the following are the items required and the respective cost:

5Distribution Managements Information Systems Analysis and Designs
Item-no Resource name Units Cost-price
1. Computer-laptop system 2 $200
2. Networking Router 4 $200
3. Networking switch 2 $100
4. System Printers 2 $100
5. System Data servers 1 $500
6. System Web servers 1 $500
Total =$1600
3.3 Schedules
The following are the major tasks that shall be carried out while implementing the proposed
system’s projects:
No Task-name Start time End time
1. System plan 01-04-2019 15-04-2019
2. Systems analysis 16-04-2019 30-04-2019
3. system’s requirements identification 01-05-2019 15-05-2019
4. System’s designing 16-05-2019 30-05-2019
5. System implementing 01-06-2019 15-06-2019
6. System’s testing 16-06-2019 30-06-2019
7. System’s documenting 01-07-2019 15-07-2019
8. System’s installation 16-07-2019 30-07-2019
9. System’s maintenance and supports 01-08-2019 15-8-2019
(Michael, 2017).

6Distribution Managements Information Systems Analysis and Designs
DISTRIBUTION MANAGEMENTS SYSTEM’S USE-CASE DIAGRAMS
Sign-up systems
Sign-in systems
Capturing client’s records
Making purchases orders
Capturing supplies order
Updating store
Capturing selling order
Capturing distributed selling orders
Receiving the pay
Admins
Suppliers
Clients
Cashiers
Distributor officers
Store officer
Purchasing officer
4 Use-case diagrams and sequences diagram
4.1 Use-cases diagram
(Specialist, 2018).

7Distribution Managements Information Systems Analysis and Designs
4.2 Sequence-diagram
4.2.1 Purchasing order sequences diagram
(Paige, 2015).

8Distribution Managements Information Systems Analysis and Designs
DISRIBUTIONS MANAGEMENTS
SYSTEMS
CLIENT
ADMIN
SUPPLIERS
CASHIER PURCHASES OFFICER
STORE OFFICER
DISTRIBUTOR OFFI
Make purchase
Sign-in
Register client
Receiving supply
Update stocks
Sending invoice
Pay suppliers
Receive sales pay
Buy-item
Make-payment
Receive-item Supply-items
Receive-payments
Deliver -item
5 Data flows diagrams (D.F.D level-0 and context-diagram)
5.1 Context-diagram
(Stephen, 2014).

9Distribution Managements Information Systems Analysis and Designs
5.2 D.F.D level-0
5.2.1 Customers registrations processes level-0 D.F.D diagrams
(Thomas, 2013).

10Distribution Managements Information Systems Analysis and Designs
6 Entities relationships diagram
(Shamkant, 2015).
WORKER
workerid :{PK} INT(15)
Names : VARCHAR1(15)
Phone: VARCHAR1(15)
Addr : VARCHAR1(15)
E-mail : VARCHAR1(15)
Duty : VARCHAR1(15)
SUPPLIERS
Supplierid :{PK} INT(15)
Name : VARCHAR1(15)
Phone: VARCHAR1(15)
Addr : VARCHAR1(15)
E-mail : VARCHAR1(15)
Town : VARCHAR1(15)
CLIENT
Clientid :{PK} INT(15)
Names : VARCHAR1(15)
Phone: VARCHAR1(15)
Addr : VARCHAR1(15)
E-mail : VARCHAR1(15)
Town : VARCHAR1(15)
Cardtype : VARCHAR1(15)
STORE
storeid :{PK} INT(15)
Item : VARCHAR1(15)
Qty : VARCHAR1(15)
Time : DATE
Workerid :{FK} INT(15)
PURCHASESORDER
Orderid :{PK} INT(15)
Item : VARCHAR1(15)
Qty : VARCHAR1(15)
Price : INT(15)
Supplierid :{FK} INT(15)
Storeid :{FK} INT(15)
SALESORDER
Saleid :{PK} INT(15)
Item : VARCHAR1(15)
Qty : VARCHAR1(15)
price : INT(15)
workerid :{FK} INT(15)
Storeid :{FK} INT(15)

11Distribution Managements Information Systems Analysis and Designs
7 3 screens interfaces (main-menu, input-screen and reports)
7.1 Main-menus
(Ramez, 2015).
HOMES||CLIENT||SUPPLIER||PURCHASE||SALE||DISTRIBUTE
DISTRIBUTION SYSTEM

12Distribution Managements Information Systems Analysis and Designs
REGISTERING CLIENTS
CUST_ID:
NAMES :
PHONE :
ADDR :
E-MAIL :
TOWN :
CARD_TYPE :
HOMES
SUBMIT EDITING UPDATING CANCELING
7.2 Inputs screens