INFT 6500 System Analysis and Design Report: Maria’s Aquarium

This report details the system analysis and design for Maria’s Aquarium, focusing on developing a new payroll and revenue system. It includes a user requirements list, logical data flow diagrams for both the current and proposed systems, and an Entity-Relationship (ER) diagram illustrating the relationships between system entities. The report also establishes a selection criteria checklist for evaluating potential solutions, comparing products like Gusto, OnPay, and BambooHR. Ultimately, BambooHR is recommended for its ability to connect all stores with the head office and effectively handle payment and reporting issues. The analysis aims to automate processes, improve efficiency, and integrate tax policies for accurate payroll and revenue management.

Running head: SYSTEM ANALYSIS AND DESIGN
System Analysis and Design
Name of the Student
Name of the University

1SYSTEM ANALYSIS AND DESIGN
Table of Contents
User Requirements:....................................................................................................................2
Current Data Flow Diagram:......................................................................................................3
New System Data Flow Diagrams:............................................................................................4
ER Diagram:...............................................................................................................................5
Selection Criteria:.......................................................................................................................5
Evolution Report:.......................................................................................................................6
Bibliography:..............................................................................................................................7

2SYSTEM ANALYSIS AND DESIGN
User Requirements:
Sales Details: All the staff of the store must have a centralized system that can store
the sales details. The system will store and distribute the sales details to all the authorized
users. The sales people and other management executives can easily track sales related
activities.
Digital Price Book: The system will store the price and other details of the products
of Maria’s Aquarium in a digital format. This can be referred to as a database schema
installed in the DBMS. The users will only point out the product and the details will be
automatically shown and copied to the current sub system.
Order Management: The system will be managing the orders and notify the intended
staff or customer of Maria’s Aquarium in accurate time. After the customer makes a
purchase, the system will notify the sales person and selected store manager. The store man
will monitor the delivery process.
Automatic Back Processes: The most essential thing that the users need to avoid
mistakes and concentrate more on core Maria’s Aquarium business activities is automatic
processes. The automatic back processes will check stock availability, generate sales reports,
payroll delivery, invoice creation and more. Basically all the accounts related process can be
automated using the system. One thing must be considered before planning the system of
Maria’s Aquarium is that the system must be organization wide and consist of all the stores
and work in real time.

3SYSTEM ANALYSIS AND DESIGN
Current Data Flow Diagram:
Figure 1: Current Data Flow Diagram
(Source: Created by Author)

4SYSTEM ANALYSIS AND DESIGN
New System Data Flow Diagrams:
Figure 2: New System Data Flow Diagram
(Source: Created by Author)

5SYSTEM ANALYSIS AND DESIGN
ER Diagram:
Figure 3: ER Diagram
(Source: Created by Author)
Selection Criteria:
Number Name Description
1 Efficient
Operation
The system is able to process the payrolls in least time
2 Accuracy The system can execute the processes accurately
3 Tax Payment The payroll system can integrate the tax policies and
pay them properly
4 Report
Customization
The system should be attached to the HR and
accounting department and create customized reports

6SYSTEM ANALYSIS AND DESIGN
for stores and head office
5 Revenue Report
Generation
The system can create revenue reports accurately
6 Automatic Money
Transfer to Bank
The system can automatically transfer the collect
amount for each order to the bank
Evolution Report:
First Product (Gusto): This product makes a collaboration between administrative
features, payroll system and compliance features. This system can efficiently manage and
fulfil the staff member needs.
Second Product (OnPay): The interaction with the system is very user friendly and
consist of various unique features. It is a highly scalable product and perfect for small and
medium sized organization.
Third Product (BambooHR): This product is based on online access and suitable for
mid-sized organizations. The product provide features like high quality customized reports.
The security is also very good.
Selection: As per the need of Maria’s Aquarium, the system must be able to connect
all the stores with the head office. The third option, BambooHR is perfect for this scenario.
Along with the payment and report related issues can be positively handled using this system.

7SYSTEM ANALYSIS AND DESIGN
Bibliography:
Cagiltay, N. E., Ozcelik, E., & Ozcelik, N. S. (2015). The effect of competition on learning in
games. Computers & Education, 87, 35-41.
Haruna, I., Joseph, A., & Samson, A. J. (2015). Integrated Personnel Payroll and Information
System (IPPIS): Panacea for Ghost Workers Syndrome in Nigerian Public Service.
International Journal of Public Administration and Management Research (IJPAMR),
2(5), 55-64.
Jibrin, M. S., Ejura, S. B., & Augustine, N. I. (2015). System of Payroll in the Public Sector
Administration. Asian Development Policy Review, 3(1), 9-19.
Kadam, K. S., & Onkar, V. C. (2015). A review paper on student information supervision
system. International Journal of Research In Science & Engineering, 1, 66-72.
Long, J. E. (2018). Relationships between common graphical representations used in system
engineering. INSIGHT, 21(1), 8-11.
Rusly, F. H., Ahmi, A., Talib, Y. Y. A., & Rosli, K. (2018, September). Payroll system: A
bibliometric analysis of the literature. In AIP Conference Proceedings (Vol. 2016, No.
1, p. 020124). AIP Publishing.
Valacich, J. S., George, J. F., & Valacich, J. S. (2017). Modern systems analysis and design.
Pearson Education Limited.
Wu, P. Y., Igoche, D. A., & Drauss, P. J. (2017). Media versus Message: Choosing The ER
Diagram To Teach ER Modeling. In Proceedings of the EDSIG Conference ISSN
(Vol. 2473, p. 3857).