LAN-Based Vehicle Information System for Motor Vehicle Registration Office

Vanessa Mae E. Valencia, Jude Israel Regojos, Jet Renz Ferrer and Froilan D. Mobo^*

AMA Computer College, Olongapo City Philippines.

Corresponding author Email: valenciavanessamae@gmail.com

DOI : http://dx.doi.org/10.13005/ojcst11.01.04

ABSTRACT:

The proponents of this study proposed the idea of making a LAN-Based Vehicle Information System to improve the conventional method of record administration for Engine Vehicle Enlistment Office. The illustrative strategy for inquire about was connected to the investigation. Research and meetings were led to fortify the assumption of issues and hidden issues on various zones of the ebb and flow data framework were found in light of the respondent's answers. The LAN-Based Vehicle Data framework won't just evaluate yet will likewise lighten the issue and tedious procedure of the old framework. Also, the proposed framework would yield ongoing procedures and more advantageous. The goal of this examination is to have a data framework that is more proficient and bother free in record administration. The investigation presents advancement of data frameworks from the conventional to the top of the line innovation. Uncovering the mechanics of the said framework and displaying information upheld points of interest that can be picked up utilizing LAN-Based Data Framework. Sorted out interface and usefulness gives speed and productivity, end of problem and lessen of time.

The MVRO (Motor Vehicle Registration Office) is a department that is in charge of regulating the transportation in Subic Bay Freeport Zone. It systematizes the transportation inside the SBFZ and has 275 registered taxis aside to 500 registered shuttle buses, public utility vehicles and company vehicles. According to the Officer-In-Charge of MVRO,  Mrs. Marietta Fe S. Dumlao, their database only reside to excel and not organized to the various categories of the registered vehicles

KEYWORDS: Information System; LAN Vehicle

Copy the following to cite this article: Valencia V. M. E, Regojos J. I, Ferrer J. R. R. F, Mobo F. D. LAN-Based Vehicle Information System for Motor Vehicle Registration Office. Orient.J. Comp. Sci. and Technol;11(1)

Copy the following to cite this URL: Valencia V. M. E, Regojos J. I, Ferrer J. R. R. F, Mobo F. D. LAN-Based Vehicle Information System for Motor Vehicle Registration Office. Orient. J. Comp. Sci. and Technol;11(1). Available from: http://www.computerscijournal.org/?p=7737

Introduction

Information systems are developed for the improvement of the necessities of a company and to provide solutions to their problems in data processing, data presentation, and record-keeping. It supports decision-making activities and statement of the progress of an organization. It produces reliable output by keeping track of records with minimum data redundancy, reduction of paper works, improved data quality, accessibility and responsiveness, and elimination of human errors, which is the main purpose of using information systems. Because of these advantages, the use of information systems will be beneficial to different institutions especially universities and government agencies.^{4,5,6,7,8,9,10,11}

Subic Bay Metropolitan Authority is a government agency that has a big role on uprising of Subic Bay Freeport Zone in Zambales. It has different departments but one of the departments that have a role of regulating the transportation inside the SBMA is the MVRO. Motor Vehicle Registration

Office is the one who regulates and administrate the motors and vehicles that are running around the SBMA. The operator of the said vehicle needs to register on the MVRO to run his vehicle inside the community by accomplishing the needed  requirements. After an interview to the MVRO Office-in-Charge, the following situations were noted by the researcher: (1) Difficulty in searching for individual records, (2) Monitoring of expired registration is sometimes being missed, (3) Generating of detailed reports cannot be easily done. These problems were caused mainly by the old record – keeping and transaction system.

The main objective of the proposed system is to provide an information system for managing their records. The system will be networked that will allow the sharing of data from each of the workstations. It will be easier compared to those who use independent workstations because it is more convenient and the processes will be faster and real-time.^1,2,3

Statement of the Problem

General Problem

The MVRO (Motor Vehicle Registration Office) is a department that is in charge of regulating the transportation in Subic Bay Freeport Zone. It systematizes the transportation inside the SBFZ and has 275 registered taxis aside to 500 registered shuttle buses, public utility vehicles and company vehicles. According to the Officer-In-Charge of MVRO,  Mrs. Marietta Fe S. Dumlao, their database only

reside to excel and not organized to the various categories of the registered vehicles

Their PC is also a stand-alone that only one staff is able to access the data. And because of the huge number of the registered vehicles, the biggest challenge to their department is generating detailed reports of the driver’s information.

Specific Problem

Difficulty in searching for individual records.

Monitoring of expired registration is sometimes being missed.

Generating of detailed reports cannot be easily done.

Lack of security in terms of accessing the confidential files .

Materials and Methods

System Development Model

In helping the proponents achieve the desired proposed system, research tools and techniques are used. Activities were done to utilize the information that the proponents obtained.

Figure 1: System Development Model – Waterfall Model The following discuss the phases involved in the model   Click here to View figure

 

Planning and Research

The design gives the advocates the chance to talk about the proposed framework, expressing its significance and how it will be led. This stage is centered around the goal of the examination and social affair of data for investigation.

Investigation

The goal of this stage is principally to assemble the product prerequisites determination and make an outline in light of the necessities. The advocates assembled data through meeting, web and library examine. After assembling every one of the information, the advocates directed workshops and conceptualizing where they thought of a functional outline

stories and a framework that is as indicated by the clients’ needs.

Outline

In the wake of coding, the scientists figure out how to outline the screen format, what will be the look of the UI and what will be the shading plan to be utilized. Catch connections and pictures are arranged and done in this stage.

Coding

Amid this stage, the defenders built up the framework utilizing PhP and MySQL. The defender code and after that test until the point that the advancement is refined.

Testing

Amid this stage the advocates tried the framework. After the planning and encoding all the required capacities, the advocates checked and tried the usefulness of the framework

Usage

This stage would concentrate on execution of the data framework. The improvement group would set up the exchanges and movement of the framework to the clients’ PC . The proposed framework was transferred for additionally testing and starting execution.

Support. Once the recipient begins utilizing the created framework it ought to dependably be refreshed and keep educated to the capacities displayed. Support is basic to keep premises and the workplace protected and dependable. It is critical that an arranged support software engineer is set up and that all upkeep work is hazard surveyed before starting the assignment.

Research Instruments

The respondents utilized various types of instrument to make this investigation conceivable. The accompanying apparatuses were utilized for social event of information:

Meeting

The Group directed a meeting with Mrs. Marietta Fe Dumlao, the Officer Responsible for MVRO, to accumulate all the data required for the advancement of the proposed framework. The advocates masterminded a meeting guide which plans to secure information, for example, the driver’s necessity for enrollment and infringement procurement.

Web Research

The group utilized the web in social occasion steady and related actualities and most recent data related with the proposed framework to further understanding. This device was utilized to get important data concerning the examination

Library Research

The advocates utilized the library for extra assembling data. Library contributed a great deal in giving data particularly as far as related writing that have been useful in giving related articles.

Figure 2: shows the progress made by the proponents during the development of the system  Click here to View figure

 

Figure 3: Admin System Dashboard This show the System’s Overview where you can see the management categories of the system  Click here to View figure

 

Results and Discussions

Table 1   Click here to View table

 

Table 2  Click here to View table

 

This chapter concludes the study. The conclusion and recommendations included in this chapter discusses the summarization of all the benefits, features and significance of the proposed system to the beneficiaries.

Conclusion

In the implementation of the proposed system, the beneficiary will have a system with greater accuracy in record management and will save time for them. It will resolve the currently identified problems of the business which includes difficulty in searching for individual records, processes takes time, generating of detailed reports cannot be easily done and lack of security in terms of accessing the confidential files. The proposed system  provide an  information system for managing their records. The system will also be networked that will allow the sharing of data from each of the workstations. It will be easier compared to those who use independent workstations because it is more convenient and the processes will be faster and real-time. The proponent therefore conclude that implementation of the proposed system will benefit the business a lot more than it cost.

Recommendations

The Information System of Motor Vehicle Registration Office is expected to be fully functional upon  implementation. The proponents recommend the agency to obtain the appropriate hardware and software requirements for the system to operate fully as expected. End-user training should not be of the strenuous since the system is designed to be very user friendly. However, prompt orientation to all users and involved personnel should not be ignored but even considered to be great significance in order to meet the optimum desired benefits that the system may provide.

Transition from the existing to the proposed system would not give much hassle if properly used and implemented. In its implementation phase, as soon as there may be any innovation, the system should be updated to be aligned with the change introduce.

Acknowledgement

First of all, the researchers, would like to offer their sincerest gratitude to God Almighty for continuously giving them strength and wisdom while doing this software engineering project; for unconditional love and for continuously showering them blessings along the way.

The researchers would also like to thank their research adviser, Dr. Froilan Mobo, who supported them to what they are now.

The researchers would like to express their gratitude to their families and friends who encouraged and motivated them that brings the project to success. Especially, the financial support the families gave.

Lastly, they would like to show appreciation to their beloved college, the AMA Computer College-Olongapo Campus for giving  them the opportunity to make this project possible.

References

1. Al-Saedi. Implementation of LAN-Based IP Telephony Simulator” retrieved from https://www.researchgate.net/publication/299443909_Implementation_of_LAN-Based_IP_Telephony_Simulator. 2015.
2. Almadani. Automatic Vehicle Location and Monitoring System Based on Data Distribution Service” Retrieved from http://www.sciencedirect.com/science/article/pii/S1877050914009867. 2014. 
3. Bavais. “PC-Based Electronic Bulletin Board” retrieved from http://lpulaguna.edu.ph/wp-content/uploads/2016/08/3.DEVELOPMENT-OF-A-PC-BASED-ELECTRONIC-BULLETIN-BOARD.pdf. 2015.
4. Gunawan. LAN-Based Application of File Management in the Computer Laboratory of School of Applied Science” Retrieved from https://www.researchgate.net/publication/298700404_Lan-based_application_of_file_management_in_the_computer_laboratory_of_school_of_applied_science. 2015. 
5. Lee. LAN-Based Inventory System”retrieved from https://prezi.com/jknp-re_r9qi/lan-based-inventory-system/. 2012. 
6. Padua. LAN-Based ISO Database Management System of Quality Management and Planning Department in LetranCalamba” retrieved from  https://ejournals.ph/article.php?id=10912. 2015. 
7. Platilla. LAN-Based Expidenture Monitoring System of Sta. Cruz, Laguna” Retrieved from https://ejournals.ph/article.php?id=10848. 2016. 
8. Reyes. LAN-Based Information System for College of Information and Communications Technology” Retrieved from http://www.ijias.issr-journals.org/abstract.php?article=IJIAS-15-111-03. 2015. 
9. Selvaraj. Smart Dustbin Monitoring System using LAN-Server and Arduino” retrieved.from  https://www.researchgate.net/publication/315725507_Smart_Dustbin_Monitoring_System_using_LAN_Server_and_Arduino. 2017. 
10. Vehicle Registration System. Retrieved from http://www.smartcube.co/INDUSTRIES/TransportationTraffic/VehicleRegistrationSystem.aspx. 2016. 
11. Vehicle license registration system. Retrieved from https://www.slideshare.net/AgbonaAzeez/vehicle-license-registration-system. 2016. 

---

---

This work is licensed under a Creative Commons Attribution 4.0 International License.