DESIGN AND IMPLEMENTATION OF A COMPUTERIZED TRANSACTION PROCESSING AND REPORTING SYSTEM FOR A MODERN SUPERMARKET
ABSTRACT
Modern supermarket is a day-to-day transaction that is carried out, with adequate reports and feedback on the status of the inventory and account. Transaction processing and report system is always very important to managements of the modern shops. The aim of the study is to design and implement A Computerized Transaction Processing and Reporting System for a Modern Supermarket. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will provide more effective, easy to use, cost affection accurate and comprehensive in report generation and monitor the activities of transaction processing and reporting system of Eastern shop. The motivation that led to the implementation of the proposed system is that the manual method of handling the transaction process and report of any modern shop makes the work very tedious and difficult. It wastes a lot of time an does not always produce accurate and reliable reports. The system is also very expensive to maintain. The methodology adopted in this study is the structured system analysis and design methodology (SSADM) which is a technical approach for analyzing and designing an application or system by applying object throughout the software development process. The programming language used is HTML, CSS, JAVASCRIPT, PHP, SQL and JQUERY. The reason why web programming languages was used is because, it is platform independent and it is a web based application. This project will be of benefit to Enterprises and Shopping Malls/Supermarkets. The expected result is A Computerized Transaction Processing and Reporting System for a Modern Supermarket that will process marketers' data inputted into the proposed system, monitor the activities of transaction processing and generate an accurate transactional report for organizational use.
CHAPTER ONE
1.1 Introduction
Modern supermarket is a day-to-day transaction that is carried out, with adequate reports and feedback on the status of the inventory and account. Transaction processing and report system is always very important to managements of the modern shops. The point of sale of every supermarket handle daily transaction and processing, referencing the stock and taking into consideration the expired of products in the stock, from the point of sale, the account status of the general transaction exercise is ascertained. The daily transaction does not just take place without updating the stock to make sure that no product runs out of stock. The expired data of every product is also tested on daily basis with the generated income all these products report, which is submitted to the management’s decision making.
As a prelude to other parts of this study, this chapter will discuss the background upon which this study was initiated, the statement of problems that led to this study, the Aim and Objectives of the study. Others are Significance of the study, Scope of work, Limitations of the Study and Definition of technical terms.
1.2 Background of Study
A supermarket accounting has accounts receivable and accounts payable system. It can be computer implementation, receivables are expected payment for sales and services, the computer system records print customs statement, controls credit and records payment and expenditure. Marketing concentrates primarily on the buyers, or consumers. After determining the customers’ needs and desires, marketers develop strategies that are designed to educate customers about a product’s most important features, persuade them to buy it, and then to enhance their satisfaction with the purchase. Where marketing once stopped with the sale, today businesses believe that it is more profitable to sell to existing customers than to new ones. As a result, marketing now also involves finding ways to turn one-time purchasers into lifelong customers. Marketing includes planning, organizing, directing, and controlling the decision-making regarding product lines, pricing, promotion, and servicing. In most of these areas marketing has overall authority; in others, as in product-line development, its function is primarily advisory. In addition, the marketing department of a business firm is responsible for the physical distribution of the products, determining the channels of distribution that will be used, and supervising the profitable flow of goods from the factory or warehouse.
The challenges encountered that led to the execution of the research work is that, the inefficiency and lack of effectiveness in focus group and individual market research or survey methods by developing a windows based application that uses qualitative (also called subjective or judgmental) survey techniques to report consumers behavior or reaction towards particular product(s) and/or service(s) of company over a reasonable period of time.
There are two types of research: qualitative and quantitative. To gain a general impression of the market, consumers, or the product, companies generally start with qualitative research. This approach asks open-ended rather than yes or no questions in order to enable people to explain their thoughts, feelings, or beliefs in detail. One of the most common qualitative research techniques is the focus group in which a moderator leads a discussion among a small group of consumers who are typical of the target market. The discussion usually involves a particular product, service, or marketing situation. Focus groups can yield insights into consumer perceptions and attitudes, but the findings cannot be applied to the whole market, because the sample size is too small. Focus group results, then, are suggestive rather than definitive.
It is against the background that the developments of this software to enable management to know the task of customers, form the oftenest of request of the particular stock by customers, which will be noted form the transaction file on how to manage a supermarket. At the end of this project, the research work, the software will be able to provide precise and concise logic which aid of computer system will effectively handle operation, which were being manually carried out in the computerization of a modern shop.
1.3 Statement of Problem
Investigation revealed the challenges of the existing system which entails that, the manual method of handling the transaction process and report of any modern shop makes the work very tedious and difficult. It wastes a lot of time an does not always produce accurate and reliable reports. The system is also very expensive to maintain.
The use of manual method causes a lot of people queue up by the cashier’s table waiting. It takes another number of days to make the daily transaction to be update with the stock status and also the use of manual method delays management decision taking because the reports for the management decision making comes very late and not accurate.
1.4 Aim and Objectives of the Study
The aim of the study is to design and implement a computerized transaction processing and reporting system for a modern supermarket. In achieving this aim, the following specific objectives were laid out as follows to develop an application software that will:
- Provide more effective, easy to use, cost affection accurate and comprehensive in report generation;
- Provide documentation of transaction file on how to manage a supermarket;
- Detect the problems marring the smooth operation with a view of providing solution to the problems using a computerized system; and
- Monitor the activities of transaction processing and reporting system of Eastern shop.
1.5 Significance of Study
The project reports consumers’ reactions and how their responses will affect production and sales of the company’s products. Basically, it is helpful for the organization to improve the quality of its relationship management with their customers. This software can organize a comprehensive survey profile of respective products and can use customer information collected into database for effective decision-making. Other benefits of the application include:
- Quality and efficiency in service delivery
- Decision support for effective managerial functions
- Enterprise agility
- Customer attention
This study will be of immense benefit to other researchers who intend to know more on this study and can also be used by non-researchers to build more on their research work. This study contributes to knowledge and could serve as a guide for other study.
1.6 Scope of Study
The study focuses on the design and implementation of a computerized transaction processing and reporting system for a modern supermarket using Eastern Shop Enugu System in Stock Product as a case study. Account and record keeping system treated in this work covered basically the use of computer in a modern supermarket for the effective and smooth management of supermarket inventories of stock and daily sales.
1.7 Limitations of the Study
During the course of this study, many things militated against its completion, some of which are:
- Time Constraint: The time frame given to accomplish this project was very short due to school academic calendar and it was carried out under pressure which made the researcher not to implement some necessary features.
- Establishment Policies: Establishment policies posed a serious limitation as most staffs are not ready to release information needed for this project work. There were lots of information needed from the staffs of this institution to enhance the study which took them time to release or they did not release at all for security purposes, hence the scope was reduced.
- Research material: availability of research material is a major setback to the scope of the study.
- Frequent power failure: This made the researcher append more money on fuel to ensure sustainable power.
- Financial Constraint: Insufficient fund tends to impede the efficiency of the researcher in sourcing for the relevant materials, literature or information and in the process of data collection (internet).
1.8 Definition of Terms
Internet: The Internet is a global wide area network that connects computer systems across the world.
Business: A business is defined as an organization or enterprising entity engaged in commercial, industrial, or professional activities.
Virtual Store: The virtual store is an online store that displays merchandise and an order form.
Marketing: Marketing is the process of teaching consumers why they should choose your product or service over those of your competitors, and is a form of persuasive communication.
Promotion Channels: In marketing, promotion refers to any type of marketing communication used to inform or persuade target audiences of the relative merits of a product, service, brand or issue.
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 a Computerized Transaction Processing and Reporting System for a Modern Supermarket (A Case Study of Eastern Shop Enugu) 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
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of the Problem
- 1.4 Aim and Objective of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Definition of Marketing Transaction and Reporting System
- 2.3 The Strategic Role of the Marketing Transaction and Reporting Systems
- 2.4 The Role of the Internet
- 2.5 Benefits of the Marketing Transaction and Reporting System
- 2.6 Marketing Transaction and Reporting System Functional Components
- 2.7 Marketing Decision Support System
- 2.8 Customer Management Systems
- 2.8.1 Customer Relationship Management
- 2.8.2 Customer Relationship Management Functions
- 2.9 Privacy and the Marketing Transaction and Reporting System
- 2.10 Theoretical Framework
- 2.10.1 Marketing Transaction and Reporting Systems
- 2.10.2 Web Based Marketing Transaction and Reporting Systems
- 2.10.3 Marketing Management
- 2.10.3.1 Marketing Mix
- 2.11 Empirical Studies
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 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
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.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
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 a Computerized Transaction Processing and Reporting System for a Modern Supermarket" 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
- 1.1 Introduction
- 1.2 Background of Study
- 1.3 Statement of the Problem
- 1.4 Aim and Objective of the Study
- 1.5 Significance of Study
- 1.6 Scope of Study
- 1.7 Limitations of the study
- 1.8 Definition of Terms
LITERATURE REVIEW
- 2.1 Introduction
- 2.2 Definition of Marketing Transaction and Reporting System
- 2.3 The Strategic Role of the Marketing Transaction and Reporting Systems
- 2.4 The Role of the Internet
- 2.5 Benefits of the Marketing Transaction and Reporting System
- 2.6 Marketing Transaction and Reporting System Functional Components
- 2.7 Marketing Decision Support System
- 2.8 Customer Management Systems
- 2.8.1 Customer Relationship Management
- 2.8.2 Customer Relationship Management Functions
- 2.9 Privacy and the Marketing Transaction and Reporting System
- 2.10 Theoretical Framework
- 2.10.1 Marketing Transaction and Reporting Systems
- 2.10.2 Web Based Marketing Transaction and Reporting Systems
- 2.10.3 Marketing Management
- 2.10.3.1 Marketing Mix
- 2.11 Empirical Studies
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 Analysis of the Proposed System
- 3.3.1 Data Flow Diagram of the Proposed System
- 3.3.2 Advantages of the Proposed System
- 3.3.3 Justification of the Proposed System
- 3.4 Functional Requirements
- 3.4.1 Use Case Diagram Of The Admin / User Privileges
- 3.5 Data Requirements
- 3.6 High Level Model of the Proposed System
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.8 Programming Module Specification
- 4.8.1 Installation
- 4.8.2 Security Design Specification
- 4.8.3 System Architecture
- 4.9 Computer Hardware Minimum Requirement
- 4.10 Software Requirement
- 4.11 Personnel / User Training
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 a Computerized Transaction Processing and Reporting System for a Modern Supermarket" 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 “Acceptance and Perception of Caesarean Section Among Pregnant Women” be used as a guide for Midwifery Project?
Yes it can be used — Pregnant women who gave birth through Caesarean section are believed to be weak as undergoing a Caesarean section traditionally portrays a sign of failure. The study was carried out to scrutinize the Acceptance and Perception of Caesarean Section among Pregnant Women. Investigation revealed that despite the possibility of a vaginal birth following Caesarean Section and the declining death rate from Caesarean sections, Nigerian women have historically refused to undergo Caesarean Section because to the widespread perception that abdominal delivery represents a reproductive failure on their side. 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 …
Is the topic “Crises Management in an Organization” recommended for Business Administration and Management (BAM) Project?
Yes it is highly recommended — Crises are inherent in any human enceinte and perform an integral part in any be managed. It generates problems between employees and the management, between groups in the organization and affects the society at large. The researcher finds out the causes of crises and management of it in our case study Anammco Plc Emene Enugu chasing the working system, non-payment of wages and salary as at when due, non employees participation on matters affecting them, poor working conditions and management insensitive of employees welfare. These result to poor working morals, low productively on the part of the employees. After analyzing the data collected from both secondary and primary, the researcher suggested or holds that crises can be reduced through two-way communication system, …
Can the material for “An Ecocritical Analysis of Tanure Ojaide’s the Activist and Kaine Agary’s Yellow-Yellow” be used as a guide for English Language Project?
Yes it can be used — Ecocoritical studies intensely show the relationship between man’s environment and literature. In this way, ecocriticism becomes a standpoint that brings environmental discourse to the fore within a literary context; a context that shows the exploitation and decay in man’s environment. Following this assertion, themes that border on environmental degradation are routed in migration, pipeline vandalism, blowouts owing to gas flares and pollution. Most of the analyses on the concept of ecocriticism take the direction of the greenish nature of the environment and the extent of the marginalisation of a people. This research views ecocritism from a different perspective. It depicts ecocritism as a theory that deploys the tools of ecoactivism and resistance in the reading and analyses of Tanure Ojiade’s The …
Can the material for “The Application of Statistical Quality Control Techniques in Industry” be used as a guide for Mathematics and Statistics Project?
Yes it can be used — The study was carried out to examine the Application of Statistical Quality Control Techniques in Industry Using 7up Bottling Company Plc, Aba as a case study. In achieving this aim, the following specific objectives were laid out to determine and identify if there has been significant difference in taste of manufactured product and protect producer from having their product containing low number of detective. The level of technical effort devoted to quality control in the industries in Nigeria is quite low, very few firms carryout two controls measures in production that is, measurement by which risk international specification of ensuring that the product conforms to the specification. It was done by taking a sample rejecting the null hypothesis. Today, this …
Can the material for “The Determinants of Balance of Payment in Nigeria (1983-2007)” be used as a guide for Economics Project?
Yes it can be used — This study aimed at analyzing through econometric methodology the Determinant of Balance of payment in Nigeria. In the work, we capture balance of payment as the dependent variable while trade openness, external debt service and exchange rate as the explanatory variable. In the second page of the regression estimated we observed GDP as the dependent variable while balance of payment, trade openness exchange rate and external debt service being the independent variable. An ordinary least square was used to capture the relationship between the variables been the regression plane. From the result estimated, we observed that all parameters are statistically significant from the t-test statistics. We also realize from the F-test estimation that the model is statistically insignificant because the …
Can this topic “Bank Loan and Credit Collection in Nigeria” be used for Banking and Finance (BF) Project?
Yes it can be utilized for research — The subject of this research works is bank loan and credit collection in Nigeria. Their bank loan develop as an attempt to financials and agricultural sector in the country. And credit collection seems very important because the non repayment of lean or credit has led to so many distressed banks in view of the important roles banks play in economic development of a country it has become a matter of necessity for an in-depth research and the analysis of its help as well as its problems. The objective therefore is to find out the place of loan in banking operation the problem encountered to extent these problems have on banks and possible solution to these problems the research work has three to …
Can the material for “Effective Management of Loans and Advances” be used as a guide for Banking and Finance (BF) Project?
Yes it can be used — This research work on effective management of loans and advances in Nigerian commercial banks is aimed at guiding financial managers in the lending and credit administration of banks in the effort to effectively carry out on their functions. Secondary sources of data were the principal instruments used; the data used were presented, analysed and computed in tables for easy references. This study shows that effective management of loans and advances is the only way for banks to ensure liquidity, profitability as well as their going concern. Therefore appropriate ways and techniques for effective lending are stipulated and explained in the course of this study for easy assessment. Because it is a known fact that banks can only survive when its …
Can the material for “Management of Rural Urban Migration and Economic Development in Nigeria” be used as a guide for Environmental Science Project?
Yes it can be used — This thesis studied the Management of Rural-Urban Migration and Economic Development in Nigeria: The case of Anambra State. Development of a Country or State depends on its ability to manage and deal with challenges that come with development, such as over-population, pressure on facilities (roads, electricity), accommodation problems, environmental pollutions and other implications. In conducting this study, the researcher elicited relevant data from both the primary and secondary sources. Questionnaire was the main instrument for data collection. Three hundred and ninety- nine (399) copies of questionnaire were administered to the respondents of the three local government areas. Subsequently, the collected data were analyzed with simple percentage, and presented in frequency tables for easy comprehension. The hypotheses were also tested through chi-square …
Is the topic “Poverty and Electoral Violence in Nigeria” recommended for Political Science Project?
Yes it is highly recommended — The study was carried out to ascertain the effect of poverty and electoral violence in Nigeria with emphasis on Donga Local Government Area. Investigation revealed that diligence, efficiency, and hard work have all been hampered by election corruption. It has irreparably harmed Nigeria's political and social growth as well as the election process. It undermines a reliable voting process and makes it easier for an unpopular administration to take power. 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 from textbooks, journals, newspapers and …
Can this topic “Design and Implementation of a Web Based System for Administrating Entrance Exams” be used for Computer Science (CS) Project?
Yes it can be utilized for research — Computers are known for their wide range of uses especially in scientific and mathematical fields. However little or no thought has been given to designing a complete and through intelligence test on a computer system in out immediate environment. Although in advanced countries, where computerized games have been developed, computers have proved that they constitute of ways of indirectly testing intelligence. This system is designed in order to implement intelligence test on a computer system. It tries as much as possible to incorporate the important aspect of intelligence on a wide scale. It is designed to test intelligence of secondary school leavers using the Senior School Certificate Examination (SSCE) and the University Matriculation Examination (UME) as a standardized sample, and as …