DESIGN AND IMPLEMENTATION OF AN ONLINE SUPERMARKET SALES RECORDING AND REPORT MANAGEMENT SYSTEM
CHAPTER ONE
Introduction
A sales recording and reporting management system for supermarket is a computerized system that will aid the easy management of financial and inventory aspects of the supermarket so that reports can be presented when needed. The range of items and materials which might be held in supermarkets is huge. The variety and quantity of items and materials held in a supermarket will depend on its size and on its range of activities. Since the items in a supermarket are meant for sales, there is therefore need for a sales recording and report management system. Every item in a supermarket constitutes to the generality of the stock in the supermarket. As sales are being made, the stock levels of the items are reducing thereby making stock control a vital aspect of supermarket sales management.
Stock control in supermarket comprises mainly the clerical and administrative functions of stock control involves the following: Ensuring that the right types and qualities of items needed for production, sale and distribution, are always available when required, ensuring that stock is issued in the correct sequence, that is, “first in first out”, so that “older” stock is not allowed to deteriorate by being kept too long in the Store, for instance because it has been hidden from view by more recently received stock, maintaining records showing the “movement” of items into and out of the Store, controlling and monitoring those movements and maintaining full records of the items in the Store, ensuring that the correct “stock levels” of the various items are set and are maintained, that orders and reorders are made (or requested to be made) in good time, and that what is ordered is received, checking, counting or otherwise measuring stock to ensure that records are accurate and that no losses are occurring due to pilfering, theft, damage or poor storage, pricing and valuing the items in the Store.
For optimal supermarket sales and inventory management process, robust functionality is needed for managing the stocks in the supermarket. This will enable the management of the supermarket to easily record and keep track of sales made, the items sold and other valuable report needed to monitor the income and expenses in the supermarket daily.
1.1 Statement of the Problem
The following problems were identified in the existing system at Bonanza supermarket in Ikot Ekpene:
- It is difficult to obtain reports about the financial details of the sales made daily.
- There is error most times in the computation of items sold.
- The stock level of items cannot be easily monitored as they are being sold.
1.2 Aim and Objectives of the Study
The aim of the study is to develop a sales recording and report management system for supermarket. The following are the specific objectives of the study:
- To design a software system. To accurately compute sales record.
- To implement a system that will save sales record to database for future reports purpose
- To design a system that will update inventory level of the items sold to database.
1.3 Scope of the Study
This research work covers Sales recording and report management system for supermarket a case study of Bonanza supermarket, Ikot Ekpene. It is limited to the recording of daily sales and managing of the stock level (inventory) of items sold
1.4 Significance of the Study
The significance of the study are:
- It will provide a system that will facilitate accurate recording of sales in a supermarket.
- It will help in monitoring the daily sales record of the supermarket through querying of the database records.
- It will provide a system that can be used to perform computation of the items sold in the supermarket.
- It will serve as a useful reference material to other scholars.
1.5 Organization of the Research
This research work is organized into five chapters.
Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.
Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.
Chapter three is concerned with the system analysis and design. It analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.
Chapter four presents the system implementation and documentation. The choice of programming language, analysis of modules, choice of programming language and system requirements for implementation.
Chapter five focuses on the summary, conclusion and recommendations are provided in this chapter based on the study carried out.
1.6 Definition of terms
Sales Management:
Sales management is a business discipline which is focused on the practical application of sales techniques and the management of a firm’s sales operations. It is an important business function as net sales through the sale of products and services and resulting profit drive most commercial business.
Inventory:
Inventory is the raw materials, work-in-process products and finished goods that are considered to be the portion of a business’s assets that are ready or will be ready for sale.
Stock:
The goods or merchandise kept on the premises of a shop or warehouse and available for sale or distribution.
CHAPTER TWO
2.0 Literature Review
2.1 Introduction
The review of relevant literature is the main topic of this chapter. A literature review covers theoretical and methodological contributions to a certain issue in addition to the state of knowledge at the time of writing. It provides information about the state of the art in relation to the subject you are writing about. It examines the body of work on the chosen subject. The literature evaluation in this study comprises the …
Procedure for Downloading the PDF (Docx) Material
Design and Implementation of an Online Supermarket Sales Recording and Report Management System can be downloaded by requesting the full set of materials at the project or seminar cost. The document will be sent via Microsoft Word (MS-Word) format via WhatsApp (e-mail) following payment confirmation.
| Seminar Material Cost ₦3,000 | Project Material Cost ₦5,000 |
Request Complete Material
 | Click here to request the Complete Material via WhatsApp including;
|
TABLE OF CONTENTSPRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- ⋮
LITERATURE REVIEW
- 2.1 Introduction
- ⋮
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Feasibility Study
- 3.3.1 Economic Feasibility
- 3.3.2 Technical Feasibility
- 3.3.3 Operational Feasibility
- 3.4 Analysis of the Proposed System
- 3.4.1 Data Flow Diagram of the Proposed System
- 3.4.2 Advantages of the Proposed System
- 3.4.3 Justification of the Proposed System
- 3.5 Functional Requirements
- 3.5.1 Use Case Diagram Of The Admin / User Privileges
- 3.6 Data Requirements
- 3.7 High Level Model of the Proposed System
CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.7.1 System Testing
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
- 4.12 File Maintenance Module
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of an Online Supermarket Sales Recording and Report Management System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
PRELIMINARY PAGES
- Title page
- Approval page
- Dedication
- Acknowledgement
- Table of Contents
- Abstract
INTRODUCTION
- ⋮
LITERATURE REVIEW
- 2.1 Introduction
- ⋮
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
- 3.1 Methodology Adopted
- 3.1.1 Problem Identification Using SSADM
- 3.2 Analysis of the Existing System
- 3.2.1 Dataflow of the Existing System
- 3.2.2 Disadvantages Of The Existing System
- 3.2.3 Weakness of the existing System
- 3.3 Feasibility Study
- 3.3.1 Economic Feasibility
- 3.3.2 Technical Feasibility
- 3.3.3 Operational Feasibility
- 3.4 Analysis of the Proposed System
- 3.4.1 Data Flow Diagram of the Proposed System
- 3.4.2 Advantages of the Proposed System
- 3.4.3 Justification of the Proposed System
- 3.5 Functional Requirements
- 3.5.1 Use Case Diagram Of The Admin / User Privileges
- 3.6 Data Requirements
- 3.7 High Level Model of the Proposed System
CHAPTER FOUR
SYSTEM DESIGN AND IMPLEMENTATION
- 4.1 Objectives of the Design
- 4.2 Cohesion and Decomposition High level Model
- 4.3 Control Center / Overall Dataflow Diagram
- 4.3.1 Proposed System Operation Flowchart
- 4.4 System Specification and Design
- 4.4.1 Input and Output Specification
- 4.4.2 Database Specification and Design
- 4.4.3 Data Dictionary
- 4.5 Choice and Justification of Programming Language
- 4.6 Program Documentation
- 4.7 Implementation Techniques
- 4.7.1 System Testing
- 4.8 Programming Module Specification
- 4.8.1 Installation
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
- 4.12 File Maintenance Module
CHAPTER FIVE
SUMMARY, CONCLUSION AND RECOMMENDATION
- 5.1 Introduction
- 5.2 Summary
- 5.3 Conclusion
- 5.4 Recommendation
REFERENCES
APPENDIX A - “SOURCE CODE”
APPENDIX B - “OBJECT PROGRAM”
Disclaimer for Complete Material Utilization
The displayed research work titled "Design and Implementation of an Online Supermarket Sales Recording and Report Management System" is stated as a research guideline towards accomplishing your assigned project / seminar research work. All the research materials on this website are ONLY for research purposes and should be used as a guideline in developing your research work. For no reason should you copy word for word as projectlist.com.ng will not be liable for any who copied the material. By ordering the complete research guideline, it signifies that you've accepted our terms of service.
Frequently Asked Questions (FAQ)
Can the material for “Design and Implementation of Student Attendance Monitoring System Using Fingerprint” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Student Attendance Monitoring System Using Fingerprint is a software developed for daily student attendance in schools and institutions. The ability to compute the attendance percentage becomes a major task as manual computation produces errors, and also wastes a lot of time. The aim of the study is to design and develop a reliable, scalable and cost effective Fingerprint based Student Attendance monitoring system. In achieving this aim, the following specific objectives were laid out to develop a fingerprint students’ attendance capturing system and compare it with manual system and carry out the analysis of manual processes involved in class attendance and examination attendance. The motivation that led to the implementation of the proposed system is that the traditional system is …
Can the material for “The Impact of Student-Generated Analogies on Students Achievement in Biology” be used as a guide for Education Project?
Yes it can be used — The purpose of this research work was to investigate the impact of student-generated analogies on student’s achievement in biology. To achieve this two research questions was raised the first one was, what is the impact of student- generated analogy on student’s achievement in Biology? The second question was what is the difference in performance between male and female students taught using student generated analogy. Two hypotheses were also formulated. Hypothesis (1) states that there will be no significant difference in performance between students taught using student-generated analogy and those taught without student- generated analogy. Hypothesis 2 states that there will be no significant difference in performance between male and female students taught using student-generated analogy. The sample size for this …
Is the topic “Occupational Hazards Among Hawkers” recommended for Sociology Project?
Yes it is highly recommended — This research project tends to examine Occupational Hazards among Hawkers in Pen Cinema Area of Agege, Lagos State. Survey design was employed with the use of a well structured questionnaire. Respondents were selected based on simple random sampling technique. Sample size of One Hundred (100) respondents were selected from the staff of 7up Bottling Company Plc. Three hypotheses were formulated and tested with the use of Chi-Square analysis. The analysis resulted to rejecting all null hypotheses and hence accepting the three alternate hypotheses. Based on decisions of the tested hypotheses conclusions were reached that; there is significant relationship between occupational hazards and hawking; there is relationship between physical environments in which hawker’s workand lack of proper infrastructure like dean running water. It was …
Can the material for “Influence of Conflict Management on Organizational Productivity” be used as a guide for Industrial Relations and Personnel Management (IRPM) Project?
Yes it can be used — Conflict Resolution is a skill any organization requires, as no organizations actually exist without the existence of conflict. The study was carried to investigate the Influence of Conflict Management on Organizational Productivity using Seven-Up Bottling Company as a case study. In achieving this aim, the following specific objectives were laid out to examine the impact of conflict on organizational productivity, find the means of managing conflict with the organization and emphasized the relationship between conflict and the organizational productivity. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. A total of 150 (one hundred and fifty) respondents were selected for this study to represent the entire population …
Can the material for “African Traditional Medical Health Practices: Beliefs and Concepts in Ihiala L.G.A of Anambra State” be used as a guide for Philosophy Project?
Yes it can be used — Medical health practice is one of religious practice in African Tradition. It is a means of securing the lives of the individuals. Among all communities in Africa, life is regarded as sacred. Each individual’s life is seen as a gift from God to the community and to the family. Ihiala Local Government Area which is located in Anambra State is a community of people who hare and believe in African traditional World view and Institutions. The research design used in this report is descriptive design, utilizing questionnaire method to obtain information from the respondents for this project. Primary data were collected from the primary source which questionnaire was used as an instrument of data collection while secondary data were sources …
Can the material for “Landlord and Tenant Relationship, It’s Effects on Property Values” be used as a guide for Estate Management (EM) Project?
Yes it can be used — In long-term business relationships the customer experience is affected by how the customer perceives the quality of customer relationship. The purpose of this paper is to understand the customer relationship quality construct in tenant relationships in a business-to-business environment. Methodology / Approach: The theoretical framework is adapted from relationship marketing literature and this is then applied in case study settings to five customer companies in a landlord and tenant relationship. The paper framework of 13 relationship quality attributes and applies these to the case companies. Findings: The results suggest that some of the suggested relationship quality attributes have an importance in a landlord relationship while some suggested attributes have less value. Research Limitations / Implications:- The case studies were conducted in companies that occupy …
Can the material for “A Study on Co-Operative Thrift and Loan Society” be used as a guide for Economics Project?
Yes it can be used — This research project titled “Co-operative Thrift and Loan Society of Federal Ministry of Industry and Technology, Owerri, Imo state. The study was motivated by the necessity of requirement for the award of Higher National Diploma in Co-operative Economics and Management of Institute of Management and Technology (IMT), Enugu. It aimed at identifying the causes of the study of co-operative thrift and loan society in Owerri, Imo State. To solve the research problems both primary and secondary data were collected. The research instruments used in collecting the data were questionnaire and oral interview. The respondents comprised of members of the society its employees and some members of staff of Federal Ministry of Commerce and Industry, Owerri, Imo State. In organizing and presenting data …
Can this topic “Optimization of Productivity in Rice Cultivation and Processing through Value Addition” be used for Agricultural Economics and Extension Project?
Yes it can be utilized for research — Rice is the most important staple food for a large part of the world’s population providing more than one fifth of the calories consumed worldwide by the humans. The study was carried out to examine the Optimization of Productivity in Rice Cultivation and Processing through Value Addition in Afikpo North Local Government Area of Ebonyi State. In achieving this aim, the following specific objectives were laid out to determine the available technology that affects value addition in rice business and examine the various value chains in the production and processing of rice in the area under study. Investigation revealed that the rate of rice importation is high due to insufficient production and lack of value addition to enhance the productivity …
Can the material for “Ethnic Conflict and National Stability in Nigeria” be used as a guide for Public Administration (PA) Project?
Yes it can be used — For the country Nigeria, the years 1999-2003 was years of great suffering caused by ethic crises. In the Northern part of the country, the ethnic conflict between the Muslims and Christians was climaxed with the introduction of shaira law in some Northern States. At the Southern part of Nigeria also a lot of ethic crisis has been witnesses among the various ethic conflict that blew across Nigeria between 1999 − 2003, which has left in its trail unprecedented human, economic, social and ecological disasters. Exacerbating this is the public perception that the government has been insensitive and slow in addressing fundamental issues affecting Nigeria, such as poverty alleviation, resource distribution, infrastructural development and security. An air of anxiety and uncertainty continues …
Is the topic “Impact of Interest Rate Policy on Investment in the Nigeria Economy” recommended for Economics Project?
Yes it is highly recommended — The focus of this research work is based on the impact of interest rate policy on investment in the Nigerian economy between the period of 1981 − 2009. because interest rate and investment is at core of economic stabilization. The objective of this study is to examine the impact of interest rate policy on Nigeria prior to interest rate regulation in 1987 and to serve as a guide on how interest rate can be fixed to enhance effective accumulation of savings that can be channeled to investment. The study employed the ordinary least square technique which also employ. Secondary data obtained from the central bank of Nigeria (CBN) statistical bulletin. The main findings revealed that there is a negative relationship …