Client relation information system for Shana Lacs Beauty and Wellness for Life

Abstract

This study was conducted to investigate the slow processes of doing business transactions of The Shana Lacs Beauty and Wellness for Life and to effectively and efficiently address this problem. Thus, the Client Relation Information System was highly conceptualized, specifically designed, and carefully tested to speed up the existing manual process of the organizations business transactions so that the manual method of doing their business transactions such as sales, payroll, employee time clock, and improper storage and monitoring of transaction files would be properly addressed through a new and efficient way of data handling. Basically, most of the processes were be done by the help of a barcode scanner and every successful transaction was saved in the database. Whenever a certain transaction record was needed, it could be automatically generated through reports. Logically, this would greatly benefit the management and the employees as described herein. The Modified Iterative Waterfall Method was used by the developers in the system where every stage was cautiously carried out. This was implemented through the Transaction Processing System, Management Information System, and Relational Database Management System. The system’s front end was developed through Microsoft Visual Basic 6.0, while its back end used MySQL Server. CRIS (Client Relation Information System) graphical interface was enhanced by the use of Adobe Photoshop and Corel Draw. In addition to Corel draw’s usage, the barcode samples for testing were created. Windows XP was used as the main operating system during the development as well as with the implementation. It was concluded that the design of the proposed system was able to eliminate or minimize the problems existing currently, and it was recommended that necessary upgrades of the system should be implemented to cope with the needs of the organization in the future.