ABSTRACT
In this day and age the process of buying and selling of commodities are usually done not physically but virtually, with the current situation that the world is in at the moment the process of going to the market to buy groceries is a major risk to both the seller and the buyer. But not only that, some people are often skeptical when buying things of that sort (i.e., groceries) in a supermarket where the guidelines of the novel- Covid19 are followed, they then to feel safer and more comfortable going to the traditional market where they are able to get prices direct from the sellers themselves there’s a comforting feeling in doing things the old ways. Now, Home of Groceries trader App is an app that is developed to tackle the aforementioned.
The purpose of the website is to enable users to surf through and find all their necessary needs from all part of the nation. Also, to tackle the issue of the trust, buyers are given prices straight from the market sellers, because on our platform everything is done and controlled by the clients including insertion, delete and editing of the products are all done by the seller, so the users get the way he normally buys groceries with the help of technology. The application also helps the customers track previous transactions include the price of that product and from which seller the product was gotten from for future reference. Also, a user can have a detailed search of a vendor by entering the name of that product in the search bar, the user can also choose to select the category of the product which will give him access to all the product that fall under that category, also, a user can choose to search a user based on the location which the user is. The main idea of developing Home of Groceries trader App is to give the users a free and fair market space where both the party of the seller and the customer can enjoy a seamless experience at the same time making their lives easier and safer. The Methodologies that will be adopted in the development of this project will be the Waterfall methodology and the Agile methodology. The waterfall methodology was chosen because when developing the application, the best way to follow was systematic approach which means all the processes involved lead to one another just like in the waterfall method. Although, since they are some unknowns the Agile method was adopted to design those processes. The Application was implemented using JavaScript for the logic and SQL for the backend.
TABLE OF CONTENTS
ABSTRACT……………………………………………………………………………………………………………………. VI
CHAPTER 1: INTRODUCTION…………………………………………………………………………………………. 1
THE AIM OF THE PROJECT IS TO………………………………………………………………………………………………………………………… 2
- RECOGNIZE THE PRESENT CHALLENGES FACE BY GROCERIES TRADERS IN NIGERIA………………… 2
- DESIGN AND IMPLEMENT AN ONLINE PLATFORM FOR THE GROCERIES TRADERS TO SHOWCASE THEIR PRODUCTS ONLINE TO THE VAST MAJORITY OF INTERESTED BUYERS 3
- MAKE IT EASIER FOR BUYER TO BUY GROCERIES JUST LIKE BEFORE BUY BETTER AND WITH ADDED FEATURES 3
CHAPTER 2: LITERATURE REVIEW……………………………………………………………………………….. 8
CHAPTER 3: REQUIREMENTS ANALYSIS AND DESIGN…………………………………………………. 14
3.3.2 Agile Development Methodology………………………………………………………………………… 15
- APPROACH TO CHOSEN METHODOLOGY/METHODS…………………………………………………………………… 16
- WATERFALL METHODOLOGY APPROACH………………………………………………………… 17
- AGILE METHODOLOGY APPROACH…………………………………………………………………. 18
- TOOLS AND TECHNIQUES………………………………………………………………………………………………………………… 20
- ETHICAL CONSIDERATION……………………………………………………………………………………………………………….. 21
- REQUIREMENT ANALYSIS………………………………………………………………………………………………………………… 21
- REQUIREMENTS SPECIFICATIONS……………………………………………………………………………………………………. 23
- SYSTEM DESIGN………………………………………………………………………………………………………………………………… 25
- Application Architecture………………………………………………………………………………… 25
- Use Case……………………………………………………………………………………………………… 28
- Sequence Diagram………………………………………………………………………………………… 30
- Dataflow Diagram………………………………………………………………………………………… 30
………………………………………………………………………………………………………………………………………………………………………………..32
- Entity-Relationship Diagram (ERD)…………………………………………………………………. 33
CHAPTER 4: IMPLEMENTATION AND TESTING……………………………………………………………. 34
USER INTERFACE…………………………………………………………………………………………………… 34
- IMPLEMENTATION PROBLEMS…………………………………………………………………………………………………………. 43
- OVERCOMING IMPLEMENTATION PROBLEMS……………………………………………………………………………….. 44
- TESTING………………………………………………………………………………………………………………………………………………. 44
- Tests Plans (for Unit Testing, Integration Testing, and System Testing)………………….. 44
- Test Suite (for Unit Testing, Integration Testing, and System Testing)……………………. 45
- Test Traceability Matrix…………………………………………………………………………………. 46
………………………………………………………………………………………………………………………………………………………………………………..49
………………………………………………………………………………………………………………………………………………………………………………..50
………………………………………………………………………………………………………………………………………………………………………………..52
- Test Report Summary (for Unit Testing, Integration Testing, and System Testing)……………. 54ERROR REPORTS AND CORRECTIONS…………………………………………………………………………………………….. 54
………………………………………………………………………………………………………………………………………………………………………………..57
CHAPTER 5: DISCUSSION, CONCLUSION, AND RECOMMENDATIONS…………………………. 59
- OVERVIEW………………………………………………………………………………………………………………………………………………… 59
- OBJECTIVE ASSESSMENT………………………………………………………………………………………………………………………… 59
- LIMITATIONS AND CHALLENGES…………………………………………………………………………………………………………… 60
- FUTURE ENHANCEMENTS……………………………………………………………………………………………………………………….. 60
- RECOMMENDATIONS………………………………………………………………………………………………………………………………. 60
- SUMMARY…………………………………………………………………………………………………………………………………………………. 61
REFERENCES……………………………………………………………………………………………………………….. 62
APPENDICES………………………………………………………………………………………………………………… 64
LIST OF TABLES
TABLE 1.1: RISK AND ASSESSMENT OF PROJECT……………………………………………………………………………………………………….. 3
TABLE 1.2: RISK ASSESSMENT MATRIX…………………………………………………………………………………………………………………….. 4
TABLE 1.3: SWOT ANALYSIS……………………………………………………………………………………………………………………………………… 6
TABLE 3.1: RESPONSIBILITY MATRIX………………………………………………………………………………………………………………………. 22
TABLE 3.2: FUNCTIONAL REQUIREMENT SPECIFICATIONS……………………………………………………………………………………… 23
TABLE 3.2: NON-FUNCTIONAL REQUIREMENT SPECIFICATIONS…………………………………………………………………………….. 24
TABLE 4.1: TEST PLAN TREE……………………………………………………………………………………………………………………………………. 44
TABLE 4.2: TEST PLAN TREE……………………………………………………………………………………………………………………………………. 44
TABLE 4.3 TEST SUITE PERFORMED……………………………………………………………………………………………………………………….. 45
TABLE 4.4: TEST TRACEABILITY MATRIX……………………………………………………………………………………………………………….. 45
TABLE 4.5: TEST SUMMARY REPORT……………………………………………………………………………………………………………………….. 53
LIST OF FIGURES
FIGURE 2. 1: GLOBALDATA CONSUMER RESEARCH (1ST FEBRUARY 2018)……………………………………………………………….. 9
FIGURE 2. 2: FRESH DIRECT APPLICATION (WWW.FRESHDIRECT.COM)……………………………………………………………………. 10
FIGURE 2. 3: JUMIA GROUP APPLICATION(WWW.JUMIA.NG)……………………………………………………………………………………. 12
FIGURE 3. 1: TECH TARGET (JUNE, 2009)…………………………………………………………………………………………………………………. 15
FIGURE 3. 1: TECH TARGET (JUNE, 2009)…………………………………………………………………. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 2: AGILE METHOD (GOOGLE, 2020)………………………………………………………………………………………………………… 16
FIGURE 3. 2: AGILE METHOD (GOOGLE, 2020)………………………………………………………… ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 3: APPLICATION ARCHITECTURE FOR HOMEPAGE………………………………………………………………………………….. 26
FIGURE 3. 3: APPLICATION ARCHITECTURE FOR HOMEPAGE………………………………….. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 4: APPLICATION ARCHITECTURE FOR ADMIN PAGE………………………………………………………………………………… 27
FIGURE 3. 4: APPLICATION ARCHITECTURE FOR ADMIN PAGE………………………………… ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 5: APPLICATION ARCHITECTURE FOR SELLER PAGE……………………………………………………………………………….. 27
FIGURE 3. 5: APPLICATION ARCHITECTURE FOR SELLER PAGE……………………………….. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 6: APPLICATION ARCHITECTURE FOR CUSTOMER PAGE…………………………. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 6: APPLICATION ARCHITECTURE FOR CUSTOMER PAGE…………………………………………………………………………. 27
FIGURE 3. 7: APPLICATION ARCHITECTURE FOR FINDING A VENDOR……………………………………………………………………… 28
FIGURE 3. 7: APPLICATION ARCHITECTURE FOR FINDING A VENDOR……………………… ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 8: USE CASE DIAGRAM…………………………………………………………………………………………………………………………….. 29
FIGURE 3. 8: USE CASE DIAGRAM…………………………………………………………………………….. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 9: SEQUENCE DIAGRAM…………………………………………………………………………………………………………………………… 30
FIGURE 3. 9: SEQUENCE DIAGRAM…………………………………………………………………………… ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 10: DATAFLOW DIAGRAM LEVEL 0…………………………………………………………………………………………………………. 31
FIGURE 3. 10: DATAFLOW DIAGRAM LEVEL 0…………………………………………………………. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 11: DATAFLOW DIAGRAM LEVEL 1…………………………………………………………………………………………………………. 32
FIGURE 3. 11: DATAFLOW DIAGRAM LEVEL 1…………………………………………………………. ERROR! BOOKMARK NOT DEFINED.
FIGURE 3. 12: ENTITY RELATIONSHIP DIAGRAM…………………………………………………………………………………………………….. 33
FIGURE 4 1: HOME……………………………………………………………………………………………………………………………………………………. 35
FIGURE 4 2: CART PAGE…………………………………………………………………………………………………………………………………………… 36
FIGURE 4 3: REGISTRATION PAGE……………………………………………………………………………………………………………………………. 37
FIGURE 4 4: ADMIN CUSTOMER UPDATE FORM PAGE……………………………………………………………………………………………… 37
FIGURE 4 5: ADMIN CUSTOMER UPDATE FORM PAGE……………………………………………………………………………………………… 38
FIGURE 4 6: AVAILABLE PRODUCT PAGE FOR A SELLER…………………………………………………………………………………………. 38
FIGURE 4 7: CUSTOMER PROFILE PAGE……………………………………………………………………………………………………………………. 39
FIGURE 4 8: RECENT PURCHASES HISTORY PAGE……………………………………………………………………………………………………. 40
FIGURE 4 9: USER ACCOUNT UPDATE FORM……………………………………………………………………………………………………………. 40
FIGURE 4 10: PAYMENT PAGE………………………………………………………………………………………………………………………………….. 41
FIGURE 4 11: ADD PRODUCT PAGE…………………………………………………………………………………………………………………………… 42
FIGURE 4 12: UPDATE MESSAGE PAGE……………………………………………………………………………………………………………………. 42
FIGURE 4 13: ABOUT PAGE………………………………………………………………………………………………………………………………………. 43
FIGURE 4 14: INCORRECT REGISTRATION ERROR MESSAGE……………………………………………………………………………………. 47
FIGURE 4 15: INCORRECT LOGIN INFORMATION……………………………………………………………………………………………………… 48
FIGURE 4 16: SUCCESSFUL REGISTRATION OF A NEW USER……………………………………………………………………………………. 49
FIGURE 4 17: ACCOUNT UPDATE SUCCESSFUL………………………………………………………………………………………………………… 50
FIGURE 4 18: ADDING A NEW PRODUCT TO THE INVENTORY…………………………………………………………………………………… 51
FIGURE 4 19: PAYSTACK CONNECTION TEST…………………………………………………………………………………………………………. 52
FIGURE 4 20: SUCCESSFUL PAYMENT USING PAYSTACK………………………………………………………………………………………. 53
FIGURE 4 21: INSTALL VISUAL STUDIO CODE 2013 ABOVE WITH MICROSOFT SQL SERVER………………………………… 55
FIGURE 4 22: OPEN THE APPLICATION USING HOME OF GROCERIES………………………………………………………………………. 56
FIGURE 4 23: RUN THE APPLICATION USING INTERNET EXPLORER………………………………………………………………………… 57
FIGURE 4 24: SERVER DIRECTORY (DATABASE)………………………………………………………………………………………………………. 57
FIGURE 4 25: SURF THROUGH THE PAGES WITH SOLUTION EXPLORER……………………………………………………………………. 58
LIST OF ABBREVIATIONS
CPU Central Processing Unit
ERD Entity Relationship Diagram
IT Information Technology
CHAPTER 1: INTRODUCTION
Overview
The process of buying and selling of commodities has longed changed over the past decades with new ways emerging from different cultures to different views it has now been transformed into a different platform in the form of E commerce,
Home of Groceries trader App is as the name implies, it is a platform for buying and selling of groceries online, the website will be created to assist the everyday life of the user in getting one of the necessity of life, when you want to get groceries normally you go to the market and buy and when buying it is normal to check different vendors in the market and when buying what are the basic things and factors that determine which vendor one buys from, simple, some go for the lower price and some might go for the “better” ones which they presume more healthier or organic. And what Home of Groceries trader App is designed to do covers all that and more, it gives a free market space to both the customer and the seller just like before and with added functions, the Home of Groceries trader App will be able to perform deliveries to the door step so you can be at home and eat healthy.
Many merchants in wuse2 market acknowledged that on a normal day they get a lot of customers that request delivery to their personal homes due to the conjunction and the stress that is required to go to the market regularly and with the current situation the world is in at the moment there’s no better time to avoid crowds, social distancing is the way the world works now and Home of Groceries trader App will be there to ease people’s stress.
Background and Motivation
Going to the market to buy groceries is something that people hold as a norm, some people still prefer to be there and ask the prices of a few merchants to compare before deciding which to buy from, now what Home of Groceries trader App is designed to do is already being done but with no major audience, the only few of the customers that are able get groceries delivered to them usually get the numbers of
the merchants that they bought products from in the past or some that have an agent that goes to the vendors and buys it for them.
Both those solutions are not really dependable because those that have the agent on ground some may not be actually buying at the fixed price because they are now buying from two people the vendor has his profit and the agent has his to, and those customers that call the vendors directly don’t normally get the products at the desired time because there is no any organized delivery system that works on standby and sometimes time is of the essence. Now what Home of Groceries trader App is designed to do is to provide a better solution for that it will help both the seller and the buyer with a platform that will solve all their problems you can buy from many vendors and with a price that’s monopoly and get the product delivered to your door step, however let’s not forget that the main purpose of grocery trader app is to allow vendors to showcase their product online for easy access to customers. Home of Groceries trader App will tackle the aforementioned problems, hence the motivation behind the development of this app
