University Project: System Analysis and Design of Marketing System

This project presents a comprehensive system analysis and design for a marketing management system tailored for the XYZ Company, which currently relies on manual record-keeping for its electronic product sales. The project encompasses a system justification, business case, and benefits analysis, emphasizing the need for a database management system. It outlines the project's scope, cost, and schedule, including the analysis of system requirements, design, implementation, and testing phases. The solution includes essential diagrams such as use case diagrams, sequence diagrams, data flow diagrams (DFD level 0 and context diagram), and an entity-relationship diagram (ERD). Furthermore, the project showcases three screen interfaces: a main menu, an input screen for customer registration, and a customer report. A Gantt chart illustrates the project timeline, and a reference list of sources is provided. The project aims to improve data storage, retrieval, analysis, and decision-making within the company.

System Analysis and Design 1
SYSTEM ANALYSIS AND DESIGN
[Student name]
[University name]
[Professor Name]
[Date]

2System Analysis and Design
Table of Contents
1 System justification...................................................................................................................3
2 Business case and justification about business benefits..........................................................3
2.1 Business case.....................................................................................................................3
2.2 Business benefits...............................................................................................................3
3 Project scope, brief cost and schedule analysis.......................................................................3
3.1 Scope.................................................................................................................................3
3.2 Cost....................................................................................................................................3
3.3 Schedule............................................................................................................................3
4 Use case diagram and sequence diagram................................................................................3
4.1 Use case diagram..............................................................................................................3
4.2 Sequence diagram.............................................................................................................3
5 Data flow diagram (DFD level 0 and context diagram).............................................................3
5.1 Context diagram................................................................................................................3
5.2 DFD level 0........................................................................................................................3
6 Entity relationship diagram......................................................................................................3
7 3 screen interfaces (main menu, input screen and report).....................................................3
7.1 Main menu........................................................................................................................3
7.2 Input screen......................................................................................................................3
7.3 Report................................................................................................................................3
8 Gantt chart................................................................................................................................3
9 Reference..................................................................................................................................4

3System Analysis and Design
1 System justification
The marketing management system is a sales system that had been adopted by the XYZ
Company to manage the sales made in their business and the company mainly deals with the sale
of various electronic products.
Currently the company has no database management system to manage their records and they
keep the records manually where they face allot of challenges in storage, retrieval and analysis of
the business transactions.
The management had however opted to adopt a business system to run their daily business
transactions and below is justification for implementing the proposed marketing management
system.
i. The organization does not have existing database system.
ii. The organization does not have existing management system.
iii. The organization has no existing computer systems.
iv. The organization has no installed network management system.
v. The organization stores the information manually.
vi. The organization has no information backup system.
vii. The organization has been losing information which is manually saved.
viii. The organization had been facing change while recording the marketing information.
ix. The organization had been facing challenge in retrieving the stored information from
the manual files.
x. The organization had been facing challenge in analyzing the business transactions and
making business decisions.
2 Business case and justification about business benefits
2.1 Business case
The following are the various business cases for the proposed management system.
i. Recording the purchase orders.
ii. Recording the supplied orders.
iii. Recording sales orders.
iv. Analyzing the business profits.
v. Recording the staff’s details.

4System Analysis and Design
vi. Recording the customer’s orders.
2.2 Business benefits
The following are the various business benefits that will be associated with the introduction of
the marketing management system.
i. The system will enable easy storage of business records.
ii. The system will enable easy retrieval of the business records.
iii. The system will enable easy business analysis.
iv. The system will enable the management in making business decisions.
v. The system will enable easy backup of the business records.
vi. The system will enable the restoration of the lost data in case of system failure.
3 Project scope, brief cost and schedule analysis
3.1 Scope
The implementation of the proposed system will cover large number of aspects according to the
business scope as follows:
i. The analysis of system requirements.
ii. The identification of proposed system requirements.
iii. The preparation of the system design.
iv. The preparation of the database design.
v. The preparation of the system interfaces.
vi. The drawing of the system data flow diagrams.
vii. The drawing of the use case diagrams.
viii. The drawing of the sequence diagrams.
ix. The drawing of the project Gantt chart diagram.
x. The preparation of the system database entity relationship diagrams.
xi. The implementation of the system interfaces using selected programming language.
xii. The implementation of the system database using the selected database system
(Tycho, 2014).

5System Analysis and Design
3.2 Cost
During the implementation of the system project there is some expense that will be incurred
according to the system requirements which includes the following:
No Resources Units Cost
1. Computer system 5 $2000
2. Network Routers 3 $1500
3. Network switch 3 $1500
4. Printer 2 $1000
5. Database server 1 $1000
6. Web server 1 $1500
Total =$8500
3.3 Schedule
Below is the schedule for the various tasks that will be conducted during the implementation of
the entire project.
Task
no
Task Start time End time
1. System planning 04/01/2019 04/15/2019 01/04/2019 15/04/2019
2. System analysis 04/16/2019 04/30/2019 16/04/2019 30/04/2019
3. Identification of system
requirements
05/01/2019 05/15/2019 01/05/2019 15/05/2019
4. System design 05/16/2019 05/30/2019 16/05/2019 30/05/2019
5. System implementation 06/01/2019 06/15/2019 01/06/2019 15/06/2019
6. System testing 06/16/2019 06/30/2019 16/06/2019 30/06/2019
7. System documentation 07/01/2019 07/15/2019 01/07/2019 15/07/2019
8. System installation 07/16/2019 07/30/2019 16/07/2019 30/07/2019
9. System maintenance and support 08/01/2019 08/15/2019 01/08/2019 15/08/2019
(Michael, 2017).

6System Analysis and Design
MARKETING MANAGEMENT SYSTEM USE CASE DIAGRAM
Register in system
Login system
Record customer details
Place purchase order
Record supplied orders
Update inventory
Record sales order
Record delivered sales
Receive payments
Admin
Supplier
Customer
Accountant
Delivery officers
Inventory officer
Purchase officer
4 Use case diagram and sequence diagram
4.1 Use case diagram

7System Analysis and Design
(Specialist, 2018).
4.2 Sequence diagram
4.2.1 Purchase order sequence diagram
(Paige, 2015).

8System Analysis and Design
MARKETING MANAGEMENT SYSTEM
CUSTOMER
ADMIN
SUPPLIER
ACCOUNTANT PURCHASE OFFICER
INVENTORY OFFICER
DELIVERY OFFICER
Place purchase order
Login
Register customers
Receive supplies
Update inventory
Send invoices
Pay suppliers
Receive sales pay
Buy item
Make payment
Receive item Supply items
Receive payments
Deliver item
5 Data flow diagram (DFD level 0 and context diagram)
5.1 Context diagram
(Stephen, 2014).

9System Analysis and Design
5.2 DFD level 0
5.2.1 Customer registration process level 0 DFD diagram
(Thomas, 2013).

10System Analysis and Design
STAFFS
Staffid :{PK} INT(20)
Fullname : VARCHAR(20)
Telephone: VARCHAR(20)
Address : VARCHAR(20)
Email : VARCHAR(20)
Role : VARCHAR(20)
SUPPLIER
Supplierid :{PK} INT(20)
Fullname : VARCHAR(20)
Telephone: VARCHAR(20)
Address : VARCHAR(20)
Email : VARCHAR(20)
Town : VARCHAR(20)
CUSTOMERS
Customerid :{PK} INT(20)
Fullname : VARCHAR(20)
Telephone: VARCHAR(20)
Address : VARCHAR(20)
Email : VARCHAR(20)
Location : VARCHAR(20)
Visa_card : VARCHAR(20)
INVENTORY
Inventoryid :{PK} INT(20)
Itemname : VARCHAR(20)
Units : VARCHAR(20)
Dates : DATE
Staffid :{FK} INT(20)
PURCHASEORDER
Orderid :{PK} INT(20)
Itemname : VARCHAR(20)
Units : VARCHAR(20)
Cost : INT(20)
Supplierid :{FK} INT(20)
Inventoryid :{FK} INT(20)
PURCHASEORDER
Orderid :{PK} INT(20)
Itemname : VARCHAR(20)
Units : VARCHAR(20)
Cost : INT(20)
Supplierid :{FK} INT(20)
Inventoryid :{FK} INT(20)
SALESORDER
Saleid :{PK} INT(20)
Itemname : VARCHAR(20)
Units : VARCHAR(20)
Cost : INT(20)
Customerid :{FK} INT(20)
Inventoryid :{FK} INT(20)
6 Entity relationship diagram
(Shamkant, 2015).

11System Analysis and Design
7 3 screen interfaces (main menu, input screen and report)
7.1 Main menu
(Ramez, 2015).
HOME||ADD CUSTOMER||ADD SUPPLIERS||PURCHASE ORDER||SALE ORDER||HELP
MARKETING INFORMATION MANAGEMENT SYSTEM

12System Analysis and Design
REGISTER CUSTOMER
CUSTOMERID:
FULLNAME :
TELEPHONE :
ADDRESS :
EMAIL :
LOCATION :
VISA_CARD :
HOME||HELP
REGISTER EDIT UPDATE CANCEL
7.2 Input screen

13System Analysis and Design
CUSTOMER REPORT
HOME||HELP
PRINT EXPORT CANCEL
7.3 Report
(Elmasri, 2013).
8 Gantt chart

14System Analysis and Design
(Dick, 2018).

15System Analysis and Design
9 Reference
Dick,B.(2018) IT Project Management Essentials: Information Systems Project Methodology
Kindle Edition.1st edn.New York:Amazon Digital Services LLC.
Elmasri,E.(2013) Database Systems: Models, Languages, Design and Application Programming.
2nd edn India: PEARSON EDUCATION.
Ramez,E.(2015) Database Systems: Models, Languages, Design and Application Programming
- International Edition Paperback.2nd edn. India:PEARSON EDUCATION.
Shamkant, B.(2015) Fundamentals of Database Systems (7th Edition).India:pearson.
Thomas,C.(2013) Database Systems: A Practical Approach to Design, Implementation and
Management: WITH Success in Your Project.1st edn. USA:Addison Wesley.
Stephen,H.(2014) Management Information Systems with student CD and MISource.3rd edn. New
York:McGraw-Hill.
Paige,B.(2015) Business Driven Information Systems with MISource 2007 and Student CD.1st
edn New York: McGraw-Hill.
Specialist,I.(2018) CISSP Certified Information Systems Security Professional Study Guide
2018. 1st edn.New York:Independently published
Michael,J.(2017) Human Resource Information Systems: Basics, Applications, and Future
Directions. 5th edn.New York :SAGE Publications, Inc.
Tycho,p.(2014) Personal Finance Simplified: The Step-By-Step Guide for Smart Money
Management Paperback. 2nd edn.New York:Tycho Press.