ABSTRACT
With the intention of upgrading the current manual system to a web-based system, the work reported in this project has been proposed to aid effective and efficient management of vehicle sales. The proposed system is for Sansani Motors (Our real case study). The new system manages and keeps track of stock and sales of vehicles for effective customer service delivery and profit maximization. The current management of vehicle stock and sales at the company is handled manually. The business process relies heavily on paper-work for manual information processing. There is no well-organized system to manage stock levels and sales. The current manual system was therefore found not suitable for continuous usage as it does not meet the current needs of the fast-growing company. The initiative to create a new system that is web-based will help the company to boost customer service delivery and profit. Business information can be stored and managed efficiently and in a more organized manner. The new system was developed following the Analysis and Design Method (SSADM) which structures a project into small, well-defined activities and specifies the sequence and interaction of these activities. This method enables the user of the system and the developer to better comprehend the problem and the proposed solution. This new system, if deployed, will enable Sansani Motors to better manage its business operations.
vi
Table of Contents
TITLE PAGE…………………………………………………………………………….i
DECLARATION ……………………………………………………………………………………………….. ii
APPROVAL …………………………………………………………………………………………………….. iii
DEDICATION ………………………………………………………………………………………………….. iv
ABSTRACT ………………………………………………………………………………………………………. v
ACKNOWLEDGEMENT ………………………………………………………………………………….. ix
CHAPTER ONE: INTRODUCTION ……………………………………………………………………. 1
1.1 Background of the Study ………………………………………………………………………… 1
1.2 Problem Statement ………………………………………………………………………………… 2
1.3 Justification of the Study ………………………………………………………………………… 3
1.4 Scope of the Study ………………………………………………………………………………… 3
1.5 Aim and Objective ………………………………………………………………………………… 4
1.6 Limitations of the Study …………………………………………………………………………. 4
CHAPTER TWO: LITERATURE REVIEW …………………………………………………………. 6
2.1 Electronic Commerce (e-commerce) ……………………………………………………….. 6
2.2 Automated Inventory Control System Software ………………………………………… 8
2.3 Car Sales Management System ……………………………………………………………….. 9
2.4 Types of Inventory Control Systems ………………………………………………………. 10
2.4.1 Manual Inventory Management System …………………………………………… 10
2.4.2 Barcode Technology …………………………………………………………………….. 11
2.4.3 Radio Frequency Identification (RFID) ……………………………………………. 11 2.4.4 Warehouse Management System …………………………………………………….. 12
2.5 Definition of Basic Concepts ………………………………………………………………… 14
CHAPTER THREE: RESEARCH METHODOLOGY …………………………………………. 15
3.1 Introduction ………………………………………………………………………………………… 15
3.1.1 Waterfall Model ……………………………………………………………………………….. 15
3.1.2 Prototyping …………………………………………………………………………………………… 18
3.1.3 The Spiral Model ……………………………………………………………………………… 19
3.2 Analysis of the Existing System …………………………………………………………… 20
3.3 Limitation of the Existing System………………………………………………………….. 20
3.4 Input, Process and Output Analysis ………………………………………………………. 21
3.4.1 Inputs Analysis …………………………………………………………………………….. 21
vii
3.4.2 Process Analysis …………………………………………………………………………… 21
3.4.3 Output Analysis ……………………………………………………………………………. 22
3.5 Data Flow Diagrams (DFDs) ………………………………………………………………… 23
3.6 Programming Language Choice …………………………………………………………….. 25
3.7 Use Cases …………………………………………………………………………………………… 26
3.8 Entity Relationship Diagram for Car Sales System ………………………………….. 28
3.9 Requirements Specification ………………………………………………………………….. 29
3.9.1 Software Requirements ………………………………………………………………….. 29
3.9.2 Hardware Requirements ………………………………………………………………… 29
3.9.3 Database Design ………………………………………………………………………………. 29
3.9.4 Normalization of Database …………………………………………………………….. 30
CHAPTER FOUR: RESULTS AND FINDINGS …………………………………………………. 33
4.1 Implementation …………………………………………………………………………………… 33
4.2 Results: ………………………………………………………………………………………………. 33
4.3 Findings ……………………………………………………………………………………………… 33
CHAPTER FIVE: SUMMARY, CONCLUSION AND RECOMMENDATIONS …… 34
5.1 Summary ……………………………………………………………………………………………. 34
5.2 Conclusion………………………………………………………………………………………….. 35
5.3 Recommendation …………………………………………………………………………………. 35
REFERENCES ………………………………………………………………………………………………… 36
APPENDIX A: User Interface ……………………………………………………………………………. 38
APPENDIX B: Source Code ……………………………………………………………………………… 44
viii
List of Figures
Fig 3.0-Program Flowchart for Car Sales Management System……………………….24
Fig 3.1-Usecase diagram for a Car Sales Management System………………………..26
Fig 3.2-Entity Relationship diagram for a Car Sales Management System……………27
ix
ACKNOWLEDGEMENT
Every project big or small is successful largely due to the effort of a number of wonderful people who have always given their valuable advice or lent a helping hand. I sincerely appreciate the inspiration; support and guidance of all those people who have been instrumental in making this project a success. I feel deeply honoured to express my sincere thanks to my project supervisor, Mr Paulinus Ofem for guiding me all through the project and providing valuable insights leading to the successful completion of my project. I am extremely grateful to the department of Computer Science for the confidence bestowed in me and entrusting my project entitled “Online Car sales Management System” with special reference to Sansani Motors Enterprise Ltd. Also, am highly indebted to Sansani Motors Enterprise Ltd for taking their time to provide me with necessary information regarding the project. Last but not the least I wish to express my deep sense of gratitude to my family members; especially my uncle, Mal. Ishaka Ahmad Galadima who has been my sponsor all through, and my friends who have been constant source of inspiration and encouragement during this project work.
1
CHAPTER ONE: INTRODUCTION
1.1 Background of the Study
Today’s world is computer age; Stone Age is replaced with fabulous achievements in science. We are living in the computer age so humans are trying to become automated in each and every field of his need. Basically automation is an act of replacing human labour by machines. Automation is useful because when there are machines in place of humans then the probability of error is minimized.
E-commerce is fast gaining ground as an accepted and used business paradigm. More and more business houses are implementing web sites providing functionality for performing commercial transactions over the web. It is reasonable to say that the process of shopping on the web is becoming commonplace. The objective of this project is to develop a general purpose e-commerce store where cars can be bought from the comfort of home through the Internet (Swapna, 2007). However, for implementation purposes, this paper will deal with an online book store. An online store is a virtual store on the Internet where customers can browse the catalogue and select products of interest. The selected items may be collected in a shopping cart. At checkout time, the items in the shopping cart will be presented as an order. At that time, more information will be needed to complete the transaction. Usually, the customer will be asked to fill or select a billing address, a shipping address, a shipping option, and payment information such as credit card number. An e-mail notification will be sent to the customer as soon as the order is placed.
2
1.2 Problem Statement
In today’s fast paced society, it’s very hard to be competitive without using cutting-edge technology available in market. After years of business, the data has grown much for Sansani Motors. It is becoming a challenge for Sansani Motors to manage that data in an effective way. To be more productive in order processing, Sansani Motors needs a solution which can facilitate their current processes with use of technology. With increased amount of orders, it will be difficult for Sansani Motors to manage orders in an effective and efficient manner. It will be very hard to go through all paper work and back tracking orders. If there is any complain or review of any order, it takes large amount of effort and time to backtrack and fix the problem. This results in loss of resources, increased time, and low output.
All orders are managed using different papers; all information regarding one order is stored in one physical file. This file contains all the documents related to that particular order. Once Sansani Motors receive an order, they assign a unique number to that order/file. Some of the financial details regarding orders are managed in an Excel sheet. Currently in Sansani Motors the work flow followed is not very efficient due to lack of Software and digital media usage. Workflow from order quotes, order to invoice and payments are today made manually without the help of a computerized management system. This means a lot of manual work, which leads to the loss of control over operations. Due to higher workloads and more errors, delay in the whole process is experienced on daily basis. No database exists and thus poor ability to pick out statistics on for example the existing order stock.
3
1.3 Justification of the Study
The car sales System is a java based application that can be accessed easily. It basically provides a tool so as to simplify all the activities involved in cars details. This project primarily focuses on the elimination of hassles and paperwork to maintain the cars records. Generally, the proposed system can help provide users with efficient working environment and more output can be generated through this .This system provide the user with friendly interface resulting in knowing each and every usability feature of the system. The proposed system helps in tracking record so that past record can be verified and one can make decision based on the past records. The system completes the work in a very less time consumption and high level efficiency. The system is developed in such way that even new users can also operate the system easily. The calculations are made quickly and the records are directly saved into the database and can be maintain for longer period of time. Each record can be retrieved and can be verified for future transaction. Also the system provides high level of security of data so as to prevent unauthorized access to the admin modules.
1.4 Scope of the Study
Scope of this project is to investigate and design a software solution which can facilitate Sansani Motors in performing their daily tasks, improving efficiency, and helping them to be more productive. This project will provide a solution through which Sansani Motors can easily manage, handle and generate all required information in their respective format when needed. It will help them to manage order details, financial data, and historical data and also in producing documents of different formats for different customers. This solution will help Sansani Motors in reducing effort spent on managing orders. It will also provide them opportunity to explore possibility of
4
generating documents, managing financial details and analysing historical data with use of digitalized solution.
1.5 Aim and Objective
The aim of this research work is to develop a Car Sales Management System for Sansani Motors. This will aid the management of Sansani Motors in tracking car sales and control. The aim of the proposed Car Sales Management System is to help small scale dealers manage their business with a generic accounting package and extended functionality with plug-in or other bolt-on software. The specific objectives of the research are as follows. To
i. Investigate the related works on Car Sales Management System domains.
ii. Design appropriate representation architecture or the proposed Car Sales Management System.
iii. Develop a system that supports the implementation of the proposed system’s functionality.
iv. Test and validate the system’s performance.
1.6 Limitations of the Study
This project was constrained by the following factors:
a) Financial Constraints Bearing in mind the economic state of the nation, it was found difficult in making both ends meet, because of the exorbitant nature of things nowadays in travelling for the collection of data needed for the project.
b) Time Constraints Looking at the interval between the resumption and vacation of the final semester for the project to be completed, the time given seemed to be short for the collection of required information for better work to be done.
5
c) Non-Availability of Material During this project, it was noticed that the required materials needed for the project are not documented. Those that were documented lacked storage facilities where they can be reached.
DISCLAIMER: All project works, files and documents posted on this website, eProjectTopics.com are the property/copyright of their respective owners. They are for research reference/guidance purposes only and some of the works may be crowd-sourced. Please don’t submit someone’s work as your own to avoid plagiarism and its consequences. Use it as a reference/citation/guidance purpose only and not copy the work word for word (verbatim). The paper should be used as a guide or framework for your own paper. The contents of this paper should be able to help you in generating new ideas and thoughts for your own study. eProjectTopics.com is a repository of research works where works are uploaded for research guidance. Our aim of providing this work is to help you eradicate the stress of going from one school library to another in search of research materials. This is a legal service because all tertiary institutions permit their students to read previous works, projects, books, articles, journals or papers while developing their own works. This is where the need for literature review comes in. “What a good artist understands is that nothing comes from nowhere. The paid subscription on eProjectTopics.com is a means by which the website is maintained to support Open Education. If you see your work posted here by any means, and you want it to be removed/credited, please contact us with the web address link to the work. We will reply to and honour every request. Please notice it may take up to 24 – 48 hours to process your request.
