DESIGN AND IMPLEMENTATION OF SALES RECORD SYSTEM
Need help with a related project topic or New topic? Send Us Your Topic
DOWNLOAD THE COMPLETE PROJECT MATERIAL
DESIGN AND IMPLEMENTATION OF SALES RECORD SYSTEM
ABSTRACT
The process of gathering, entering, storing, categorising, summarising, and analysing data is known as the Computerised Sales Record System. The application’s goal is to provide a tool that can be used to track sales and money earned or spent, as well as to advertise effective and high-quality services to clients.
The specific goals of the study to design and develop a system that will help achieve this goal are as follows: establish a database to store sales records; record sales and inventory activities; automate sales and inventory tasks and activities; guarantee account consistency and minimise errors due to damage; and ensure document and record safety because the system will be passworded to limit access.
In order to lessen the issue of erroneous record keeping in sales and recording, the researcher was inspired to concentrate on this topic. The structured system analysis and design methodology (SSADM), a technical strategy for employing objects throughout the software development process to analyse and design a system or application, is the methodology used in this study.
The programming languages that are utilised are PHP, SQL, HTML, CSS, JavaScript, and JQuery. Because it is a web-based application and is platform independent, web programming languages were employed.
Last but not least, based on the study’s stated goals, there is no reason to question the system’s durability. When printing its output, the system has been able to achieve at least 99% success.
The following businesses will benefit from this project: supermarkets and shopping centres. The anticipated outcome is an electronic sales record management system that processes the things that customers have chosen at a supermarket or shopping centre and produces a precise invoice for payment.
Chapter One
1.1: Introduction
Sales through computers The process of gathering, entering, storing, categorising, summarising, and analysing data is known as the record system. Financial and management record keeping are the two facets of record keeping. We were able to create a computerised sales record system in this study that managers of all kinds of businesses—in fact, the entire business community—will find acceptable. Improved understanding of the most popular products is made possible by computerised sales.
Because it is simple to confirm the amount of money and the time that transactions occurred, this promotes employee accountability and confidence in accounting. Additionally, they enable consistent customer service experiences.
People are aware that there is a consistent process at the register that necessitates payment tendering, receipt taking, and the transfer of ownership of goods and services.
This fosters trust in a company and guarantees enduring customer relationships. In retail markets, the most popular way to handle sales and monitor inventory is using computerised systems.
The backdrop that motivated this investigation, the challenges that prompted it, and the study’s aim and objectives will all be covered in this chapter as an introduction to later sections of the research. Other factors include the study’s significance, scope, limitations, and definition of technical words.
1.2 Background of the Study
The business The owner is the only person in charge of the tiny Beverly Hills Supermarket. The company sells a variety of goods, such as groceries, drinks, household appliances, and other things that are seen everywhere. The company physically counts its inventory by hand, just like other convenience stores.
Technically, Beverly Hills Supermarket only has a manual system, which could result in redundant effort and duplicate documentation.
The company only relies on human product listings and data entry, both of which are prone to error. The company is unable to access its accurate sales and revenue figures for a specific period of the year.
Additionally, it lacks appropriate product listings. In such cases, the owner just ignores lost property. There are no additional employees at Beverly Hills Supermarket today.
However, the company only had one cashier at the time. In essence, it introduced the revenue and the power to fire workers. How, all of the work in the company is done by the proprietor.
Financial and management record keeping are the two facets of record keeping. Financial records are primarily used to help decision makers assess a company’s financial health, profitability, and prospects for the future. On the other hand, managerial record keeping is customised to meet the requirements of a certain business.
It assists executives in measuring the success of their strategies, identifying issues that need executive attention, and achieving organisational goals.
Producing reliable records and financial statements regarding a company entity is the goal of record keeping. Thus, we focused our investigation on the record-keeping system used by a Port Harcourt business centre.
With computer technology, almost all of the jobs that were formerly completed by hand by humans may now be completed in a matter of seconds. The manual technique of performing some activities has been replaced with a quicker and more dependable computerised method since the creation of the “wonder machine.”
It makes sense that if a supermarket struggles to maintain proper records of financial transactions, employee files, and managerial documents accumulated for planning, accuracy, timely data processing, and security, they will do so manually, which comes with risks of insecurity, high operating costs, and lengthy data processing times.
The issues with the manual system of record keeping will undoubtedly be greatly alleviated by the design and development of the supermarket’s computerised system.
Thus, the goal of the project is to create an effective computer software program that can manage the supermarket’s record-keeping system (Rubin, 2007).
1.3 Statement of the Problem
Among the issues with the study are:
The ledger, which looks rough, is used to manually record sales and monies received.
It might be challenging to determine whether specific items require restocking.
The manual inventory approach is time-consuming and frustrating.
flaws in documentation brought on by human error.
1.4 The Aims and Objectives of the study
The application’s goal is to provide a tool that can be used to track sales and money earned or spent, as well as to advertise effective and high-quality services to clients. The exact goals of the research to create a system that will accomplish this goal are as follows:
Build a database to aid in the storage of sales records.
Record the activities related to sales and inventory.
Automate tasks and operations related to inventory and sales.
Assure account consistency and minimise damage-related errors.
Because the system will be password-protected to limit access, make sure the documents and records are safe.
1.5 Significance of the Research
This study is important because it will give Beverly Hills a system that is simple to use and accessible, making transactions more dependable and quicker and removing the need to pay a third party to complete the work.
It provides more secure and accurate sales and product list records. It will facilitate the supermarket line-up process in a number of ways. Additionally, this will support accurate record-keeping. The study will specifically be pertinent to the following:
Admin: oversees inventory updates, stock additions, and system user identification.
After making a purchase, customers can take use of the printed receipts.
Researchers in the future would examine the potential for system upgrades.
Through a comprehensive document, researchers, students, teachers, programmers, and web developers can all profit from this method.
1.6 Scope of the Study
Using the Beverly Hills supermarket in Port Harcourt as a case study, the study focusses on the Sales Record System.
1.7 Limitations of The Study
Numerous factors hindered the completion of this investigation, including the following:
Time Restraint: Because of the school academic schedule, the researcher had a very small amount of time to complete this project. Additionally, the project was completed under pressure, which prevented the researcher from implementing some essential elements.
Establishment Policies: Because most staff members are not prepared to give information required for this project task, establishment policies presented a significant limitation.
The scope was limited because the institution’s staff needed to provide a lot of material to improve the study, which they either took a long time to disclose or didn’t release at all for security reasons.
Research material: One significant obstacle to the study’s scope is the availability of research material.
High programming technique: This project’s programming component presented numerous challenging bugs that required several days to resolve. Issues like database connections using PHP and MySQL presented several difficulties.
Financial Restraint: A lack of funds often makes it more difficult for the researcher to find pertinent literature, materials, or information and to collect data online.
1.8 Definition of Terms
Automation is the act of controlling and processing data without the need for human intervention by using a control system, such as a computer (Rubin, 2007).
Computerised: The process of transforming a system into one that uses a computer system to manage, plan, and automate tasks (Rubin, 2007).
A database is a sizable collection of connected data that is accessible and editable by the user on a computer (Rubin, 2007).
To gain access to a computer or its apps, a user needs input a password, which is a secret code. This is composed of letters, numbers, special characters, or a mix of the aforementioned types.
Record System: The process of systematically updating and storing data on a computer system to maintain file security (Rubin, 2007).
Research: A thorough examination of a subject, particularly with the goal of learning new facts or details (Rubin, 2007).
System: A collection of computer parts that work together, including peripherals, software, and hardware.
Customers are those who purchase products or services from a store or company.
Hardware refers to a computer’s actual, physical components, including the motherboard, speakers, central processor unit, and enclosure.
Inventory is the products and supplies that a company keeps on hand with the intention of reselling them.
The discipline of inventory management is mostly concerned with defining the location and form of stocked items.
An inventory management system is a set of procedures, processes, and technology (hardware and software) that manages the upkeep and monitoring of stocked goods.
Sales are when products or services are traded for cash or credit.
… CHAPTER TWO
2.0 Literature Review
2.1 Introduction
This chapter’s primary focus is the review of pertinent literature. A literature review discusses the level of knowledge at the time of writing as well as theoretical and methodological contributions to a particular topic.
It gives you details about the current state of the art regarding the topic of your essay. It looks at the corpus of research on the selected topic.
Need help with a related project topic or New topic? Send Us Your Topic