DESIGN AND IMPLEMENTATION OF AN ONLINE SUPERMARKET'S STOCK MANAGEMENT SYSTEM
CHAPTER ONE
1.0 Introduction
The range of items and materials − stocks − which might be held in Stores is huge. The variety and quantity of items and materials held in the Store of a particular enterprise will depend on its size and on its range of activities [1]. What we refer to as stock control 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 sales and inventory management process, robust functionality is needed for managing stocks. Warehouse management functions for inventory control cover internal warehouse movements and storage and its support helps in the recording and tracking of materials on basis of both quantity and value [1].
1.1 Theoretical Background
The technology used for the development of the system is database management technology.. Visual Basic 6.0 programming language was used for the interface. Below is an example of source code and rendering:
Private Sub Command1_Click()
‘Add new record code
Adodc1.Recordset.AddNew
Text1.Text = Date$
End Sub
Private Sub Command2_Click()
‘save record
Adodc1.Recordset.Update
MsgBox “SAVED”
Adodc1.Recordset.MoveFirst
End Sub
Private Sub Command3_Click()
‘delete record
On Error GoTo AB
Adodc1.Recordset.Delete
AB:
End Sub
Private Sub Command4_Click()
‘move to next record
On Error GoTo AB
Adodc1.Recordset.MoveNext
AB:
End Sub
Private Sub Command5_Click()
‘Move to previous record
On Error GoTo AB
Adodc1.Recordset.MovePrevious
AB:
End Sub
Private Sub Command6_Click()
‘close form
Unload Me
End Sub
Fig 1.1: Stock Registration form
1.2 Statement of the Problem
Beverly Hill supermarket in Ikot Ekpene does not have an automated system to manage stock and this raises a number of problems such as:
- The recording of sales and cash received are done manually on a book that appears rough.
- It is difficult to know when certain items need to be re-stocked. Thus, the books are exposed to physical damage, information can be lost.
- There is a long list of stock orders waiting to be attended to on daily basis.
1.3 Aim and Objectives of the Study
The aim of the study is to design and implement a stock management system that will aid track inventory level as stocks are being sold.
The following are the objectives of the study:
- To track stocks as they are being sold so as to know when to re-order or re-stock
- To update stock level on a daily basis
- To generate daily report of inventory when needed.
1.4 Significance of the Study
The significance of the study are:
- It will help in monitoring stock level so that the firm does not run out of stock.
- It will aid easy updating of inventory.
- It will serve as a useful reference material to other scholars.
1.5 Scope of the Study
This research work covers design and implementation of stock management system for supermarket using Beverly Hills super market Ikot Ekpene as a case study.
1.6 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 presents the research methodology used in the development of the system, 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, constraints of the study, conclusion and recommendations are provided in this chapter based on the study carried out.
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’s Stock 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
- 1.0 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's Stock 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
- 1.0 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's Stock 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 “The Influence of Multi-National Co-Oporation in the Economic Development of Nigeria” be used as a guide for Public Administration (PA) Project?
Yes it can be used — The main focus of this research work is to examine the influence of multi-national co-operations in the economic development of Nigeria. MNC’s are agent of development in the sense that they constitute the source of capital investment, employment for the people, technological transfer etc. However, many detest their existence because they are agents of exploitation of the people they came to develop. In this regard, the objectives of this work is to ascertain the extent of involvement of multi-national co-operations in the economic development of Nigeria using indices like employment provision, transfer of technology and to determine the political, socio-economic implications of their existence in Nigeria. All these were discussed in the chapter one. In chapter two, related literatures were …
Can the material for “The Challenges of Entrepreneurship Development in Nigeria” be used as a guide for Business Administration and Management (BAM) Project?
Yes it can be used — The study examined the critically the challenges entrepreneurship development is facing in Nigeria using Elens Consult as a study. The study adopted survey design using primary source of data with questionnaire as instrument of data collection. A total of 55questionnaires were administered to the staff within Elens consult out of which 50 were duly filled and returned. Chi-square statistical method was used to verify the degree of significance of entrepreneurship development. The result of the findings shows that market men and women lack access to constant power supply. It was also noted that local traders do not have access to fund to support their businesses. More so, in terms of factors that encourage entrepreneurship development, it was discovered that skill …
Can this topic “Financial Management and Control: A Key to Management Efficiency” be used for Banking and Finance (BF) Project?
Yes it can be utilized for research — Financial planning and control when properly employed can assist management to achieve its objectives effectively. The objective of this study is to develop a realistic picture on how financial planning and control can help to make efficient and effective success in business organization which where properly addressed. The researcher make use of questionnaire, interview and chi square method. The researcher recommends that there should be coordination of functional management in planning and controlling the operations of the company. This will help to achieve maximum profitability and efficiency. …
Can the material for “Management of Local Government Finance” be used as a guide for Public Administration (PA) Project?
Yes it can be used — This research is aimed at examining ‘’The Management of Local Government Finance With particular reference to Kabba/Bunu Local Government Area of Kogi State’’ The research work is divided into five chapters. The researcher used both primary and secondary sources of data collection. In analyzing the data, the use of simple percentage method was adopted for easy understanding. It was revealed that despite the statutory allocation from both federal and state governments as well as internally generated revenue, the local government still experienced persistent inadequate finance. In view of this, the researcher recommended that the local government management should try to be more inward looking by focusing attention on the possibility of exploiting various abandoned means of raising fund. This will …
Can the material for “The Role of Credit Risk Management in the Liquidity Position of Banks in Nigeria” be used as a guide for Banking and Finance (BF) Project?
Yes it can be used — The study examined the role of credit risk management in the liquidity position of banks in Nigeria, Fifteen selected commercial banks in Osogbo, the Osun state capital was used as a study, which are (Access Bank, Diamond Bank, Ecobank Nigeria, Fidelity Bank Nigeria, First Bank of Nigeria, First City, Guaranty Trust Bank, Keystone Bank Limited, Skye Bank, Stanbic IBTC Bank, Sterling Bank, Union Bank, United Bank for Africa (UBA), Unity Bank plc, Wema Bank, Zenith Bank). The study employed the survey design and the purposive sampling technique to select 135 staffs across all fifteen banks. The data obtained through the administration of the questionnaires was analyzed using the descriptive statistics techniques such as tables, percentage, frequency and mean. Furthermore, the mixed model …
Can the material for “Garbage Collection Robot Using Wireless Communication Technology” be used as a guide for Communication Technology and Wireless Technology Project?
Yes it can be used — Robot is an automatic operated machine that replaces human effort, though it may not resemble human beings in appearance or perform functions in a humanlike manner. Garbage (solid waste) management poses a huge challenge both in industry and in urban areas for most countries over the world. The aim of the study is to design a Garbage Collection Robot System using Wireless Communication Technology. In achieving this aim, the following specific objectives were laid out to collect the garbage and monitor the garbage level as well as the moisture content present in the bin, and substantially reduce the cost, so as to make the implementation on a large scale feasible, including implementation through government bodies. Data were collected from the …
Can the material for “The Contributions of Accounting Information on Non-Profit Makings Business Organization” be used as a guide for Accountancy / Accounting Project?
Yes it can be used — This research project concerned a study of the impacts of accounting information on non-profit makings organization: A Case Study of Grace of God Mission. A sample of sixty-three members were made from the district. Investigations were carried on their financial control used both internally and externally, the accounting system and financial decisions/reporting adopted. This showed whether there was an efficient and effective financial record keeping in the church. Since the research aimed at investigating existing financial record keeping or practice the employment of descriptive method of research was found adequate. The main instruments used for the collection of primary data were the structured libraries and other research units served as secondary data. The researcher ensured that the questionnaire possessed to …
Can the material for “Financial Management and Accountability” be used as a guide for Accounting and Finance Project?
Yes it can be used — The local Government is an indivisible agent of federal State government in carrying out this Administrative work in rural places in selected local government. The theme of this research is “financial management and Accountability in selected local government Area of Imo State personally considered this inevitable because of the numerous roles played in the urban areas in the country. There is no existence of any local government without rural development Nigeria is a rich nation blessed with many natural resources is through which they generate a lot of money half of this money is embezzled by the government in Nigeria there was then the sharing of allocation from the federal government to the local government. The local government therefore contributes …
Can the material for “Our Husband Has Gone Mad Again by Ola Rotimi: A Critical Discourse Analysis” be used as a guide for Linguistics and Communication Project?
Yes it can be used — Analysis on a discourse level has been used in the analysis of texts, but this study attempts to carry out a Critical Discourse Analysis of Ola Rotimi’s Our Husband Has Gone Mad Again. The Norman Fairclough theory has been applied in this approach, paying more attention on the socio cultural and political issues in the text. The text, is a social drama which the author has used to expose some societal ills in the society, gender inequality and power relations in the text. …
Is the topic “Microbial Assessment and Mineral Elements Composition of Waste Effluents from Brewery Company in Ibadan Oyo State” recommended for Microbiology Project?
Yes it is highly recommended — The study assesses the Mineral Elements Composition of Waste Effluents from Brewery Company in Ibadan Oyo State. In achieving this aim, the following specific objectives were laid out to screen ground water and surface water in Brewery Company area of Ibadan, Oyo state, and evaluate the toxicological potential of brewery effluent and the pollution factors on water quality in Brewery Company, Ibadan, Southwestern Nigeria. Brewery wastewater effluent is highly variable in quality and composition. Effluents from individual process steps are variable. For example bottle washing produces large volume of effluent that, however, contains only a minor part of total organics discharged from brewery. Brewery effluents are high in carbohydrates; nitrogen and the cleaning and washing reagents have been proved water …