DESIGN AND IMPLEMENTATION OF A CONFECTIONERY BUSINESS DATABASE MANAGEMENT SOFTWARE
ABSTRACT
This study was made to ascertain the implementation of Database Management Software for a confectionery Business i.e. The problems of database management is a life long problem in companies for accurate and effective communication between the buyer and the staffs of the business or establishment.
The findings of the study will help to make recommendation and suggestion for future improvement and solution of the present situation.
Data relevant to the objectives of the study were from secondary source and an empirical study done by me. Ora I interview was conducted on selected persons and observations was made and references to relevant materials was also conducted.
Those randomly selected are based at Mr. Bigg’s Enugu and composed of both literate and illiterate staffs. All those interviewed that provide me with relevant materials and gave directive measure are literate and specialist in their job.
CHAPTER ONE
Introduction
Database management software can be described as software used by an organization or firm to store data’s or particulars of workers for reference purpose. This database management software for a confectionery business simply means design a software that will store data’s of all the things produced or sold by the company.
These things are something like sweet, cake, meat pie and so on. This software is a kind of software that is going to hold data’s of all the things that are sold and store in the company or business firm.
This database should be able to allow staff’s to access what they have in the database so as to know which one is available for the customer and also know what is needed at point in time. Only registered staff must have access to the database. Foe the software to work, the business or company has to engage in a small network system known as Internet.
This connection of two or more computers in an office or business firm require what is called a Server but this time the server will not be the one used for wide area network but the server to be used now is known as the personal web server (PWS)
This personal web server will allow you to be able to transfer file from one computer to the other but the information that will be transfer cannot be seen by anybody outside that networks of computer so it is well secure. This software will be working as that use banks when they have not yet connected to the internet which is a wide area network so that they can make report of what happen on that days activities.
1.1 Statement Of The Problem
After I have study the manual system of running this business in Mr. Bigg’s Enugu, a lot of problems were discovered
These problems are:
- Delay in attending to customer request
- Delay in processing of payment mostly when the customers are many.
Communication gaps between the buyer and the sever. In order for this problem to be solved, a management database of goods will assist to be able to engage in effective management of the business.
1.2 Purpose Of The Study
After much study of the way this business is being run in Mr. Biggs’s Enugu, there is great need for a computerize database management software that will make the business to run smoothly and so there will be accurate and effective communication between the buyer and the staff of the business.
1.3 Aims And Objectives
The aims and objectives of carrying out this study are as follows:
- Minimize order time and response time between buyers and sellers.
- Bridge the communication gaps that exist between the staffs and the customers.
- Provide a more secured, faster and more accurate means of buying the product.
- Provide a faster, more reliable, less cumbersome and more efficient means of payment.
1.4 Scope Of Study
The design is focused on Mr. Biggs’s Enugu but the software can be used in similar business anywhere in the world.
1.5 Limitations Of The Study
During my research on this project, I had some constrain like the inability to get the manager on sit to release some vital information for me to actualize my dream of developing this software and also, during this period transportation to and fro was difficult and money and time was also added to the stress I faced.
1.6 Assumptions
I assumed that the information given to me by case study Mr. Biggs’s was true. There is also assumption that they have operated on manual system. It was also assumed that Mr. Biggs’s will accept the new software that will design for them.
1.7 Definitions Of Terms
Computer:
Computer can be defined as an electronic device that accept data as input, process, store and retrieve data and produce final result as output.
Database Management:
This is a computer program (or more typically a suite of them) designed to manage a database.
Internet:
This can be described as a small area network where few computers have to be connected together in a building or office to be able to communicate with one another and be able to transfer files to update the databases.
System:
System is defined as an organized set of procedures and sub-units, which are functionally interrelated in the achievement of a centrally defined goal.
Program:
This is a set of logical instruction given to a computer in other for it to solve the user’s need.
System Analysis:
This is the use of systematic procedures to study an existing system for one purpose or the other as may satisfy the requirements of those initiating the study.
Inch Floppy Disk Or Diskettes:
This is a secondary storage device; it stores data or information magnetically. Floppy disk are enclosed in plastic cover to protect the sensitive surface from being scratched or contaminates by dust.
Database:
This is an orderly, usually very large body of data, which allows you to process, access and retrieve information.
Software:
Software is a set of logical instructions, which dictates the operations of the hardware.
Hardware:
Hardware is the physical component of the computer system and its peripherals.
Hard Disk:
This is the temporary storage part of the computer system. It stores information’s temporarily.
Monitor:
This is a visual electronic machine it is responsible for displaying the output of processed data in a softcopy form.
Virus:
Computer virus is a set of program responsible for deletes or record and information in the computer system.
Flowchart:
This is a diagrammatic representation of the step-by-step approach in finding a solution to a problem.
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 Confectionery Business Database Management Software 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 a Confectionery Business Database Management Software" 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 a Confectionery Business Database Management Software" 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 “A Web Based System for Distance Learning” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Distance Learning is a web-based environment that allows students to participate in live teaching and learning events without the need to travel. The aim of the study is to develop a Web Based System for Distance Learning using National Open University of Nigeria as a case study. In achieving this aim, the following specific objectives were laid out as follows to design an application that will provide alternative way of attaining education, facilitate the development of information technology and reveal the use and technology of wireless network to the user. The motivation that led to the implementation of the proposed system is that tertiary education suffers a lot of setbacks in external exams due to the primitive nature of teaching …
Can the material for “The Implications of Street Children on Security” be used as a guide for Sociology Project?
Yes it can be used — Security challenges are one of the major social problems confronting not only Sokoto Metropolis or Nigeria in general, but most of the third world countries and some other parts of the world. Street children are often found to be active participants in most of the social uprisings that were witnessed in some parts of Nigeria, particularly Sokoto metropolis. The quest to find out why and how the number of street children is increasing and how it affects the level of security prompted the conduct of this research work. In the course of the research, qualitative research technique was adopted. Focus Group Discussion and key informant Interviews were the methods through which data were gathered. The data were presented in narrative …
Can the material for “Knowledge, Accessibility and Use of Information Communication Technology (ICT) Among Students and Teachers” be used as a guide for Nursing (Science) Project?
Yes it can be used — People over time, have devised various techniques for communicating their thoughts, needs and desires to others in every aspect of life. The emergence of ICT has affected all aspects of human life, including education at all levels. ICT knowledge, accessibility and use are linked with higher efficiency and higher productivity. Undergraduate nursing students and their teachers occupy a central position in both educational and health care systems of any country. This study was carried out to investigate the knowledge, accessibility and use of ICT among students and teachers in the Department of Nursing Sciences, University of Nigeria, Enugu Campus. A descriptive cross sectional survey design was used. All the 454 undergraduate students in the Department of Nursing and 23 teachers comprised …
Can the material for “Information Sources and Services Awareness Creation Among Users of Health Information System” be used as a guide for Public Health Project?
Yes it can be used — Health information access is the patients’ ability to identify and obtain relevant, accurate and suitable information to satisfy health information needs. The study was carried out to examine the impact of Information Sources and Services Awareness Creation among Users of Health Information System in Takum, Taraba State. In achieving this aim, the following specific objectives were laid out to ascertain the level of awareness of information sources and services among the Users of Health Information System and assess the impact of information sources and services on the academic performance of the Health Information System users in the area under study. One major problem medical practitioner’s face in the process of searching for information is the challenge of locating good citations …
Can this topic “The Effect of Ethanol Extract of Desmodium Velutinum Stem on Some Marker Enzyme in Liver of Albino Rats” be used for Linguistics and Communication Project?
Yes it can be utilized for research — Present investigations were carried out on the effect of ethanol extract of Desmodium velutinum stem on some liver enzymes of albino wistar rats fed with high fat from cow”Ÿs brain. Twelve healthy albino wistar rats were divided into four groups. Group I rats were fed with balanced diet (normal feed, that is grower”Ÿs mash) and tap water. Group II rats were fed with fat diet (cow”Ÿs brain) (3.6g/day) alone. Group III rats received combined mixture of 70% fat diet (cow”Ÿs brain) with 30% ethanol extract of Desmoduim elutinum stem (2.7g/day), Group IV rats were fed with fat diet (cow”Ÿs brain) and were administered with a drug atorvastatin (5mg/rat/day). The rats were sacrificed at the end of the experimental (two weeks) …
Is the topic “Companies Income Tax and the Nigeria Economy; Challenges and Prospects” recommended for Economics Project?
Yes it is highly recommended — The major objective of this research is to explore the relationship between company income tax in Nigeria and economic development of the Nation. The researcher proposed three hypotheses towards addressing the study’s objectives and both primary and secondary sources of data are used in generating the necessary data for that purpose. These data are presented and analyzed by the use of tables, chi-square and regression model of analysis. The findings reveal that there is a significant relationship between companies’ income tax in Nigeria and economic development of the Nation and that tax evasion, tax avoidance and corruption are major hindrances to revenue generation. The study also reveal that perceived government failure to effectively provide basic infrastructural facilities discourages companies from willingly …
Can the material for “Evaluation of Microorganisms on Garri” be used as a guide for Public Health Project?
Yes it can be used — In the work, samples of Garri obtained from Ogbete market were evaluated for microbial contamination. Four sample of Garri from different sources of supple were collected from Ogbete main market Enugu Okwo, Nkalagu, Emene, and Abakaliki respectively. The sample were extracted using equal volume of sterile distilled water and serially diluted appropriately and the cultured for the growth of microben. The growth were further suspected to biochemical tests, characterization for confirmatory diagnosis organism isolated include staphylococcus aureus, clostridium perferingens, Clostridium botulism and vibroi parahamolyticus. The evaluation show that Abakaliki Garri have more microbial spores than others. This can be because of handler or jute bag or moisture which help in the increase of the microbial load. This was involve the microbial …
Can the material for “Impact of Broken Home on Academic Performance and Psychosocial Adjustment of Secondary School Students” be used as a guide for Guidance and Counselling Project?
Yes it can be used — This study examined the impact of broken homes on academic performance and psychosocial adjustment of secondary school students in Kosofe Local Government Area of Lagos State. The descriptive survey design was used in this study. The research instrument used for this study was a questionnaire tagged (BHAP) which was adapted by the researcher. The population of this study covered the teachers in selected secondary schools at Kosofe Local Government, area Lagos State where data was collected using simple random sampling. Collected data was analyzed using chi-square and descriptive statistics. Demographic data such as gender, age, and qualification were used. Findings showed that broken homes has a significance on student’s academic performance. It was concluded that there is a significance difference between …
Can the material for “Medical Expert System for Diagnosis and Prescription” be used as a guide for Computer Science (CS) Project?
Yes it can be used — This project work focuses on computerization of medical diagnosis and prescription system to increase medical services and enhancement of logistic efficiency. The aim is to produce approach which through computer programs and files carefully created, written, designed and integrated from an application package that accepts both physical states of patients. Disease symptoms (input data) and as such one which is able to store, access, manipulates as much information as possible. The ease and speed of processing, storage and versatility of the computer make it possible for easy diagnosis and prescription interestingly; the end results is the ability analysis of the disease by producing the input data and provide summaries of the total treatment bill, lab result and other disease investigation and confirmation …
Can the material for “Design and Implementation of a Computerized Hotel Management System” be used as a guide for Computer Science (CS) Project?
Yes it can be used — Hotel Management System is a site user will be able to search room’s availability with an online booking reservations system. The aim of the study is to develop a Computerized Hotel Management System that will ease the stress associated with the existing manual system as earlier stated. In achieving this aim, the following specific objectives were laid out to design and develop an application that will: manage fast access to the guest files and provide better data management facilities, enable fast and easy retrieval of guest records and data for fast reference activities, provide security measures to access the hotel’s information lowering data security threats, reduce paper usage at the hotel, data entry and processing errors, and create a database …