NYCOLE’S WINES AND SPIRITS GENERAL MERCHANDISE
COMPUTERIZED INVENTORY AND SALES SYSTEM
Submitted to the Faculty and Staff
of AIE College International – Laoag Campus
In Partial Fulfilment of the Requirements for the
Course in Computer Programming NC IV
ESTABILLO, ELBERT C.
GARCIA, ANGELINE E.
ILDEFONSO, JERICK RYAN G.
RAMOS, JOHNABELLE MAE A.
UNGRIA, ERICSON G.
MAY 2012
APPROVAL SHEET
This system analysis and design project titled, “NYCOLE’S WINES
AND SPIRITS GENERAL MERCHANDISE COMPUTERIZED
INVENTORY AND SALES SYSTEM,” prepared by Elbert C. Estabillo has
been examined and passed by the System Analysis and Design
Committee on March 22, 2012 composed of the following:
LOUIE J. UBAY
Adviser
RENIER C. RUMBAOA RICHARD LEE R. MARTIN
Member Member
BARMIE M. CALUZA Ph.D
Chairman
Accepted and approved in partial fulfillment of the requirements
for the Course Computer Programming NC IV.
MELVIN A. LORENZO
College Dean
JENNIFER O. ANDRES BARMIE M. CALUZA Ph.D
School Director Academic Affairs Director
ACKNOWLEDGMENTS
This work is the product of the undying supports and concerned
efforts of many loving people who generously shared their knowledge,
time, efforts, understanding, love and resources in the accomplishment
of this study. Thus, the researchers wish to express their sincerest
gratitude and heartfelt appreciation to the following:
The AIE College International Administration, Faculty and
Staff, who helped hone the researchers’ potential to the fullest;
Mr. Melvin Lorenzo, for his constant support and unselfish
assistance in sharing his worthy time and skill, for without him, this
piece of work could not be success;
Mr. Aldrich Pajarillo, for generously sharing his precious time
towards the accomplishment of this study and for his encouragement
and insights;
Mr. Louie J. Ubay, for his unending guidance and support as
research adviser and continuous supervision for the betterment of the
manuscript;
Mr. Conrado Galam, for allowing the researchers to conduct their
study in his owned business establishment as their locale of study;
Loving families, especially their parents, for their understanding,
unconditional love, moral and financial support;
Friends and classmates for their unsolicited support and prayers;
And most importantly to God, for the wisdom that he had
bestowed upon the researchers. This SAD Project wouldn’t be made
possible without Him.
With much love, the researchers extend their warm and heartfelt
THANKS!
The Researchers
DEDICATION
The researchers would like to dedicate this simple masterpiece to
their families and relatives for their supports and love who encourage
them all the way;
Also, to those who believe in their ability and prayer for them to be
able to accomplish the study;
Finally, the God the Father, who give and help them bear their
problems in their lives.
The Researchers
Abstract
ESTABILLO, ELBERT, C. “Nycole’s Wines and Spirits General
Merchandise Computerized Inventory and Sales System.” System Analysis
and Design II. Computer Programming NC IV. AIE College International,
Laoag City.
Adviser: LOUIE J. UBAY
The purpose of the study is to develop a computerized inventory
and sales system for Nycole’s Wines and Spirits General Merchandise.
The system would be advantageous to the proprietor, manager and
cashier for their inventory and sales records.
The study conducted an interview as a methodology in gathering
data from two respondents composed of proprietor/operation manager
and cashier. In the formulation of the proposed inventory system,
responses were put into analysis. Visual Basic 6.0 programming
language was used.
Findings showed that the manual system utilized by the said
business establishment has problems in terms of efficiency. The
performance of the proposed system’s processes data, programming
language and other transactions like recording, storing and saving, and
updating of data into the system will be a great indication for Nycole’s
Wines and Spirits General Merchandise to utilize and adopt the proposed
computerized inventory and sales system.
It can be noted that in the development of computerized inventory
and sales system will be used as guide by other researchers and
students who will conduct the same studies in the future, and it must be
used by the said business establishment as an alternative technology
in inventory and sales management and the proposed system must be
enhanced and maintained for utilization by the business establishment
and other business enterprises.
Table of Contents
Contents Page
Title Page…………………………………………………………………......... i
Approval Sheet………………………………………………………………… ii
Acknowledgement…………………………………………………………….. iii
Dedication………………………………………………………………………. v
Abstract………………………………………………………………………….. vi
Table of Contents…………………………………………………………….. viii
List of Tables…………………………………………………………………… x
List of Figures................................................................................ xi
Chapter I - Introduction…………………………………..………………... 1
Background of the Study…………………………………………….. 1
Statement of the Objectives………………………………………….. 2
Significance of the Study……………………………………………... 3
Scope and Delimitation……………………………………………….. 4
Definition of Terms…………………………………………………….. 4
Chapter II - Review of Literature……………………………................ 6
Related Literature………………………………………………………. 6
Related Studies…………………………………………………………. 9
Chapter III – Methodology…………………………………………………. 11
Research Design………………………………………………………… 11
Locale and Respondents of the Study…………...………………… 11
Instrumentation………………………………………………………… 13
Data Gathering Procedure……………………………………………. 13
Data Analysis……………………………………………………………. 15
Formulation of the Proposed Library System……………………. 16
Chapter IV – Presentation and Interpretation of Data……………. 17
Current System Flow………………………………………………….. 17
Existing System Data Flow Diagram………………………………. 19
Proposed System……………………………………………………….. 20
Proposed System Data Flow Diagram………………..……………. 21
Data Dictionary…………………………………………………………. 28
Graphical User Interfaces…………………………………………….. 29
Computer Programmer’s Validation of the Developed System. 37
Chapter V – Summary, Conclusions and Recommendations……. 40
Summary…………………………………………………………………. 40
Conclusions……………………………………………………………… 41
Recommendations……………………………………………………… 42
Bibliography……………………………………………………………………. 43
Appendices……………………………………………………………………… 45
Appendix A………………………………………………………………. 46
Appendix B………………………………………………………………. 48
Appendix C………………………………………………………………. 50
Appendix D………………………………………………………………. 51
Appendix E………………………………………………………………. 55
Appendix F………………………………………………………………. 57
About the Researcher 92
List of Tables
Table Page
Table 1 Main………………………………………………………………….. 28
Table 2 Reports………………………………………………………………. 28
Table 3 Secure……………………………………………………………….. 29
Table 4 Result of the computer programmer’s validation of the
system……………………………………………………………….. 37
List of Figures
Figure Page
Figure 1 Five phases of the System Development Life Cycle……...... 15
Figure 2 Flow of current system operation………………………………. 17
Figure 3 Existing system data flow diagram…………………………..... 19
Figure 4 Proposed system data flow diagram…………………………… 21
Figure 5 Proposed computerized inventory and sales system………. 22
Figure 5.1 Manager’s menu………….………………………….…… 23
Figure 5.2 Cashier’s menu…...……………………………………… 24
Figure 5.3 Sales menu………………………………………………… 25
Figure 5.4 Inventory menu…………………………………………… 26
Figure 5.5 Reports menu………………………………................... 27
Figure 6 NWSGM Log in form………………………………………………. 29
Figure 7 NWSGM Main form………………………………………………… 30
Figure 8 NWSGM Sales form………………………………………………... 31
Figure 9 NWSGM Inventory form…………………………….................. 32
Figure 10 NWSGM Reports form…………………………………………… 33
Figure 11 NWSGM Sample report form………………......................... 34
Figure 12 NWSGM Log out form…………………………………………… 35
