Web-based Data Management System Research Articles

Development of a Web-Based Educational Management System for a Technology Vocational High School in Banda Aceh, Indonesia

This study explores developing and implementing a web-based Management Information System (MIS) tailored for SMK Negeri 2 Banda Aceh, a vocational school in Indonesia. To enhance administrative efficiency and address unique challenges in vocational education, the system centralizes tasks such as attendance tracking, academic record management, and internship coordination. Employing the waterfall model, this project proceeded through structured phases, including requirements analysis, system design, development, and usability testing. A sample of 50 users, comprising students, teachers, and school operators, evaluated the system based on usability, interface design, and information clarity through a questionnaire, yielding high satisfaction scores. Reliability testing and correlation analysis revealed strong internal consistency across questionnaire items and identified critical factors influencing user satisfaction, such as interface appeal and effective error resolution. The results indicate that the system meets core user needs and contributes to a streamlined, user-friendly school management process. With implementation planning, user training, and ongoing maintenance, this MIS offers a sustainable solution that can serve as a model for vocational schools across Indonesia, showcasing the potential of digital solutions in advancing educational administration and supporting career readiness in vocational education.

Design and Testing of a Web-Based Student Information Management System

Politeknik Piksi Ganesha is an institution of higher learning located in Bandung, Indonesia, specializing in engineering and technological curricula. The research's general objective is to describe the design and implementation of the web-based Student Information Management System (SIMS) to manage student data at Politeknik Piksi Ganesha Bandung. The functional and non-functional specifications are represented using Unified Modeling Language (UML) based on broad data collection through observation, interviews, and a literature review. It also entails black-box testing, which measures the system's performance against set criteria, focusing on the output without the details of its internal workings. The significant findings indicate that SIMS enhances highly administrative processes, accuracy in data, and good communication among stakeholders by applying clear UML diagrams of the system. This successful system development meets the institution's requirements and adds to the bar for other developments within the educational technology sector. The result has also emphasized the need for practical design methodologies and testing frameworks to develop reliable information systems to improve decision-making in academic institutions. The research has contributed significantly to the discipline because it has shown how different technological innovations can alleviate the problems surrounding managing student information at higher education levels.

Web Based Production Scheduling Information System for a Shrimp Paste Factory Utilizing the Waterfall Method

Communication was essential in various aspects of life due to the rapid development of information technology, including in the management of educational institutions and companies. PT. Sumber Nelayan Indonesia faced issues in production scheduling, where the process was still done manually using bookkeeping. This caused delays in order fulfillment, primarily due to machine breakdowns and human resource challenges that impacted the production process. Additionally, the company struggled to manage order data and machine capacity, making it difficult to estimate order completion times and the amount of output produced. This research aimed to develop a web-based management information system for scheduling using the Laravel framework to assist PT. Sumber Nelayan Indonesia in managing scheduling more effectively and efficiently. The research method employed was R&D, with the system development model following the waterfall method, utilizing PHP as the programming language and MySQL as the database. System testing was conducted using black box testing. The results of the research indicated that the developed system could help the company schedule production more efficiently, reduce delays, and improve operational efficiency.

Advancing Parkinson's Disease Research in Canada: The Canadian Open Parkinson Network (C-OPN) Cohort.

Enhancing the interactions between study participants, clinicians, and investigators is imperative for advancing Parkinson's disease (PD) research. The Canadian Open Parkinson Network (C-OPN) stands as a nationwide endeavor, connecting the PD community with ten accredited universities and movement disorders research centers spanning, at the time of this analysis, British Columbia, Alberta, Ontario, and Quebec. Our aim is to showcase C-OPN as a paradigm for bolstering national collaboration to accelerate PD research and to provide an initial overview of already collected data sets. The C-OPN database comprises de-identified data concerning demographics, symptoms and signs, treatment approaches, and standardized assessments. Additionally, it collects venous blood-derived biomaterials, such as for analyses of DNA, peripheral blood mononuclear cells (PBMC), and serum. Accessible to researchers, C-OPN resources are available through web-based data management systems for multi-center studies, including REDCap. As of November 2023, the C-OPN had enrolled 1,505 PD participants. The male-to-female ratio was 1.77:1, with 83% (n = 1098) residing in urban areas and 82% (n = 1084) having pursued post-secondary education. The average age at diagnosis was 60.2±10.3 years. Herein, our analysis of the C-OPN PD cohort encompasses environmental factors, motor and non-motor symptoms, disease management, and regional differences among provinces. As of April 2024, 32 research projects have utilized C-OPN resources. C-OPN represents a national platform promoting multidisciplinary and multisite research that focuses on PD to promote innovation, exploration of care models, and collaboration among Canadian scientists.

Web-Based System Enhances Extracurricular Management Efficiency in Educational Institutions

Background: The advancement of information technology has significantly influenced educational management, particularly in managing extracurricular activities within schools. Specific Background: Traditional methods of managing these activities often lead to time-consuming processes and ineffective communication, highlighting the need for a more efficient system. Knowledge Gap: While various management systems exist, few specifically address the challenges faced in managing extracurricular activities effectively and transparently. Aims: This research aims to develop and implement a web-based Extracurricular Management Information System (SIMAK) to enhance efficiency and transparency in managing extracurricular activities. Results: Utilizing Agile methodology with the Scrum model and the Laravel framework, the study successfully developed the SIMAK application, which supports activity registration, schedule management, attendance tracking, and student assessments. The implementation of SIMAK resulted in improved administrative efficiency, streamlined processes, and increased transparency in information access for administrators, coaches, and students. Novelty: This study presents a unique approach to extracurricular management by leveraging modern technology and methodologies to address existing inefficiencies in educational settings. Implications: The findings suggest that the SIMAK application not only enhances the management of extracurricular activities but also encourages greater student participation and provides schools with better data for decision-making. Overall, the application significantly contributes to optimizing students' educational experiences outside the classroom, promoting a more organized and transparent approach to extracurricular management. Highlights: Efficiency: Streamlines registration and scheduling processes for extracurricular activities. Transparency: Improves information access for all users involved. Engagement: Increases student participation in extracurricular activities. Keywords: Extracurricular Management, Information System, Agile Methodology, Transparency, Education Technology

Development and Implementation of a Web-Based Management Information System for Enhancing Computer Programming Training in Education

In the current era of information technology, web-based training systems are critical for enhancing the efficiency of training processes. This study focuses on the development of a Management Information System (MIS) tailored for computer programming training, utilizing a web-based training (WBT) platform. The primary objective is to introduce a framework for a web-based MIS that optimizes the management and delivery of computer programming courses. Computer programming education presents unique challenges, such as real-time participant tracking and dynamic content management, which are addressed by this MIS. The system was developed using the waterfall model, with data collected through interviews, observations, and requirements analysis. Key features include training schedule management, participant tracking, material organization, session management, evaluation tools, and reporting capabilities. Real-time feedback enhances participant engagement, while session management improves the overall learning experience. The web-based platform offers flexible access and simplifies the management of training processes, enabling users to track schedules, access materials, and monitor progress. Validation results show a high validity score (V = 0.883), exceeding the required threshold, and the materials received a validity score of 0.864, confirming their suitability for basic programming competency training at Medan State University. These results demonstrate the system’s effectiveness and potential for wider application, making it a valuable tool for improving the management and delivery of programming courses across various educational contexts.

Penerapan Aplikasi Manajemen Laboratorium Dinas Lingkungan Hidup Kota Palembang

Waste samples that is managed properly will generate added value and provide benefits for environmental management. The purpose of this study is to design a web-based waste water sample data management information system so that it can make it easier for waste laboratory staff and the public as customers and admins to manage and access waste water sample data and transactions. The method used in data collection is the DevOps method and it is also not important as a researcher to interview officials from the Palembang city environmental service regarding the laboratory management application program.. In making the website, the author uses the PHP and MySQL programming languages with the DevOps development method, object-based software modeling using UML and designing the system interface to show system functions. Database design is made to show the relationship between entities and data contained in the system. Users who will use the waste laboratory management application information system are employees of the environmental service laboratory unit as admin and the public. The results of this study indicate that the website design that was built can make it easier for the admin to manage waste water sample data, it can be stored in a database and can be accessed at any time. Apart from that, for residents,, this system has the benefit of accelerating the process of collecting waste in their environment, this system has the benefit of speeding up the process of collecting waste water sample data.

Injury risks for different road users in Nepal: a secondary analysis of routinely collected crash data

Background Road traffic injuries are the 12th leading cause of mortality globally. Nepal, one of the least developed countries in the world, has a rapidly rising rate of road traffic-related morbidity and mortality. There is incomplete reporting of traffic crashes in Nepal in the last three World Health Organization global status reports on road safety. Together with poor-quality coding of crashes, essential information to inform prevention interventions or make international comparisons is lacking. Objectives The study aimed to critically analyse routinely collected traffic police data in Makwanpur district, Nepal, to identify the road user groups most likely to be involved and injured in traffic crashes in this part of the country. Design Secondary data analysis. Setting Makwanpur district, Nepal. Data sources Road traffic crash records from the District Traffic Police Office, Makwanpur, over 2 years (April 2017–March 2018 and May 2019–April 2020). Data were extracted from paper-based records onto an electronic database, and the data were analysed descriptively using the Statistical Package for the Social Sciences version 24.0 (IBM Corporation, USA). Results There were 291 crashes recorded in 2017–8 and 435 crashes in 2019–20. Two-wheeled vehicles (motorcycles/scooters) were the most frequently involved in police-reported crashes (35.5%). For most crashes (419/726, 58%), no cause was documented in the police record. Road users involved in crashes were mostly riders or passengers of motorised two-/three-wheelers (33.4%), four-wheeled vehicles (19.9%) or buses (16.7%). Of fatal injuries, 31.2% were riders or passengers of motorised two-/three-wheelers, and 24.8% were pedestrians. Limitations The data used represent crashes reported to the traffic police and therefore underestimate the true number of crashes and injuries. At the end of the second period of study, local movement restrictions associated with the COVID-19 pandemic lockdown limited the traffic on the roads, resulting in fewer crashes in March and April 2020. In most crash records, there were missing data, limiting the ability to determine contributory factors with confidence. Conclusion This study contributes to the evidence gap by describing crashes and mortality data by vehicle type and road user category. The findings suggest that the number and rates of crashes may be increasing over time. Action to improve the quality and completeness of data routinely collected by the traffic police is needed; a piloted web-based Road Accident Information Management System has the potential to support improved routine data collection. Future work The data indicate crashes occurring in one district over 2 years. To better understand the apparent increase in crashes, an analysis over a longer period, and over multiple districts, would be necessary. Funding This article presents independent research funded by the National Institute for Health and Care Research (NIHR) Global Health Research programme as award number 16/137/49.

Development and Analysis of a Web-Based Management Information System for Dental Practices to Improve Healthcare Services

Introduction: A website-based management information system is needed in dental practices as a public service center that is required to work quickly, precisely, and accurately. The performance of dental practices becomes more optimal with a computerized management information system. Objectives: This study aimed to develop and analyze a web-based management information system for dental practices to improve healthcare services in Indonesia. Methods: This is an action research design conducted at an independent dental practice in Kudus, Indonesia. The research utilized the waterfall method, which started with requirements analysis, design, implementation, testing, and deployment, as well as maintenance. The analysis was carried out using two methods: Black-Box Testing and User Acceptance Testing (UAT). The UAT percentage results were categorized into 5 sections: 0%-20% very unsatisfied, 21%-40% unsatisfied, 41%-60% neutral, 61%-80% satisfied, and 81%-100% very satisfied. Results: Testing used the Black-Box Testing method on 17 menus, with results meeting the expected specifications and no errors detected during the testing. The User Acceptance Testing (UAT) indicated a 96% approval rate, which signified an excellent rating in users' assessment of the developed system. Conclusions: Based on the results of the study, a web-based electronic dental practice management information system was proposed to meet the needs of dentists.

Sistem Informasi Pengelolaan Program Bantuan Dana Hibah Berbasis Website di Biro Kesejahteraan Rakyat Pemerintah Provinsi Lampung

The study addresses the inefficiencies of managing the Grant Fund Assistance Program in the People's Welfare Bureau of Lampung Province, where conventional manual processes have led to errors, inefficiencies, and data duplication. By developing a web-based Grant Fund Assistance Management Information System using the waterfall methodology, the research provides a structured and modern solution to these issues. The system incorporates a robust database design, leveraging the Model View Controller (MVC) framework to enhance functionality, scalability, and user access management. It adopts a user-friendly interface built with PHP, JavaScript, HTML, and CSS to ensure accessibility for different stakeholders, including administrators and applicants. Comprehensive testing was performed to ensure system reliability and compliance with functional and non-functional requirements, such as security and usability. This innovation is expected to improve administrative efficiency, enhance transparency in fund allocation, and streamline the application process for community and organizational beneficiaries, supporting the goals of good governance and clean governance.

Effect of spatial relationship between curves on crash severity at horizontal curves in a mountainous terrain

The study aimed to model the effect of spatial relationship between adjacent curves on the severity of curve-based crashes along with driver and crash causal characteristics, reflecting driver’s short-term expectancy. The crash and other associated data was retrieved from the web-based Road Accident Data Management System available in Himachal Pradesh, India, and curvature attributes were extracted using GIS. Overall, the study included 1113 curve based crashes. The driver’s perception of the sharpness of a curve was quantified as a single representative categorical factor based simultaneously on its length and radius using K-Medoid Clustering. Separate crash severity models catering to the two possible approach directions of the subject curve were developed reflecting its independent interaction with its corresponding adjacent curve in each direction. Partial Proportional Odds models were developed to overcome the predictive limitations of Ordinal and Multinomial logit models. Indicators of spatial relationship and the intensity of sharpness of the subject curve were found to be statistically significant. A sharp approach curve (radius:40–60 m) increased the risk of fatality by 2.16 times with a similar increase (2.5 times) observed for a short (length:30–60 m) adjacent curve. Adjacent curves turning in the same direction were 2.34 times more prone to fatalities. A very sharp subject curve with radius ≤ 40 m increased the risk of fatal crashes by 2.5 times, as did the short subject curves (30–60 m) (at least 3 times). Subject curves characterized by a short length and a very sharp curvature contributed relatively 3–4 times more to fatal crashes. The identified risk factors and their impact can help the relevant stakeholders to take appropriate actions and can further assist them in identifying high risk scenarios.

Analysis and Design of a Web-Based Counseling Guidance Management Information System at ABC High School

Counseling is a professional support process aimed at helping individuals or groups overcome various personal, emotional, social, or psychological problems. This process involves trained counselors who utilize specialized techniques to provide guidance, support, and advice, facilitating better coping mechanisms and overall well-being. Given the critical role of counseling in fostering mental health and personal development, it is essential to continually improve and enhance counseling services for students. By doing so, counselors can ensure they are providing the most effective and comprehensive support possible. At present, SMA ABC relies on traditional methods such as Microsoft Word and Microsoft Excel to record and store data related to counseling and guidance. While functional, these tools are not optimized for the dynamic and multifaceted nature of counseling work. This traditional approach can be time-consuming and prone to errors, hindering the efficiency and effectiveness of the counseling services provided to students. To address these challenges, a web-based management information system is needed. Such a system would streamline the process of recording, storing, and retrieving information, enabling counselors to complete their tasks more quickly, accurately, and on time. A well-designed web-based system would also facilitate better data analysis and reporting. The development of this system will use the waterfall method, a systematic and sequential approach to software development. This method ensures that all data and information related to the counseling procedures and the system's technical implementation are thoroughly processed and accurately integrated, resulting in a reliable and efficient management tool.

Design of a Web-Based Fleet Management Information System at PT Qtrans

The development of technology is currently very rapid and has an important role as a basic need in life. Technological sophistication is a force that helps the smooth running of work and business processes. In some companies, there is fleet management which is an operational activity in sending or receiving goods. For this reason, the use of information technology is needed to manage this fleet. In this case, PT. Qtrans still lack of visibility and supervision, and there is no effective fleet monitoring and tracking system because Microsoft Excel still used to record the data. The data analysis reports on fleet management are still manual and do not support the fleet maintenance and maintenance process. The system development model carried out in this study uses the prototype method model. The application of a website-based fleet management information system is expected to make it easier for administrators to monitor and manage fleets at PT Qtrans.

Sistem Informasi Manajemen Paud Melati Di Desa Lebak Ayu Kecamatan Sawahan Kabupaten Madiun Berbasis Web

PAUD Melati is one of the early childhood education level schools located in Lebak Ayu Village, Sawahan District, Madiun Regency. The problem with PAUD Melati is the process of collecting new student data and teaching and learning processes which are still manual, so what is considered is still not systematic and at the time of reporting and archiving documents it is still done with written document archives. Therefore, an early childhood management information system was built to facilitate school management to be more effective and efficient. The management information system was built and designed using the Waterfall method and tested using the Black Box Testing system testing method. With this PAUD management information system, it is hoped that it will be able to assist the school in carrying out the registration process to teaching and learning activities. The test results of the Web-Based Melati Early Childhood Education Management Information System get the expected results with the Black Box Testing test to get a percentage of system success of 100%.

Epidemiology and outcomes of drug-resistant tuberculosis cases notified in a low-resource district in Kerala, India 2017–2021 – A 5-year retrospective analysis

Objectives: Kasaragod district reports the highest drug-resistant tuberculosis (DR-TB) case notification rates in Kerala. We conducted a cross-sectional study in Kasaragod to describe the DR-TB cases notified from January 2017 to December 2021 and to identify the factors associated with unfavorable treatment outcomes in DR-TB patients. Materials and Methods: We analyzed the programmatic data from the “Nikshay portal” (a web-based patient management information system for [TB] under the National TB Elimination Program), DR-TB treatment cards, and treatment registers available with the district TB center for all the DR-TB patients notified during the study period. We described the DR-TB cases by year, local self-government area (the local administrative setup), age, gender, income level, and treatment outcomes. We compared sociodemographic, anthropometric, and clinical factors among the DR-TB patients with favorable (cured and treatment completed) and unfavorable (died, lost to follow-up, and treatment failure) treatment outcomes. Results: From January 2017 to December 2021, 128 DR-TB cases were notified from Kasaragod. Annual notification rates varied from 1.4 to 3.4/100,000 population with the highest notification in 2019. The proportion of new TB cases notified tested for drug sensitivity rose from 22% in 2017 to 86% in 2021. Seven of 41 local self-government areas had not notified DR-TB cases during 2017–2021. The notification was higher in inter-state border areas and the coastal belt of the district. The notification of DR-TB cases was highest among the 45–59 age group (17/100,000), followed by the 60 above group (11/100,000). Males and those living below the poverty line had higher notification rates. Among the outcomes evaluated 118 DR-TB patients, 89 (75.4%) had favorable outcomes, whereas the remaining 24.6% had unfavorable outcomes (death 18 [15.3%], loss to follow-up 7 [6%], and treatment failure 4 [3.4%]). Age more than 45 years adjusted odds ratio (aOR) 3.1 (95% confidence interval [CI] 1.1–8.8), income category below the poverty line aOR 6 (95% CI 1.2–28.6), admitted at least twice during treatment aOR 9.2 (95% CI 2.8–30.3), and body mass index at diagnosis <18.5 kg/m2 aOR 3 (95% CI 1.1–10.3) were found to be significantly associated with unfavorable treatment outcomes. Conclusion: DR-TB notifications have increased in the Kasaragod district from 2017 to 2021, with a high burden among males aged 45 years and above. The favorable treatment outcome is better than the national and state average. Regular monitoring and follow-up of multidrug-resistant patients with low incomes, above 45 years, and underweight may improve the final treatment outcomes.

Rancang Bangun Sistem Informasi Manajemen Asset Berbasis Web Dengan Metode Waterfall

This research is an effort to design and build a web-based Asset Management Information System (SIMA) by applying the Waterfall Method. SIMA is an important component in managing an organization's assets, including the efficient procurement, maintenance and monitoring of assets. The Waterfall method was chosen because it has a systematic and structured approach, starting from the needs analysis stage to the implementation and system maintenance stages. The aim of this research is to optimize the asset management process by integrating web technology so that it can provide real-time and efficient access to information. This is expected to have a positive impact on more effective and measurable asset management in various industrial sectors. This research will focus on the key steps in developing a web-based SIMA using the Waterfall Method. The first stage is requirements analysis, where the functional and non-functional requirements of SIMA will be identified in detail. Next, system design will be carried out based on the results of the analysis, including designing the user interface and database structure. The implementation phase will change the system design into program codes that can run, followed by the testing phase to ensure the quality and performance of the system. Finally, the system will be fully implemented and maintained according to needs and changes that occur. Thus, it is hoped that this research can make a significant contribution in increasing the efficiency and effectiveness of asset management through the use of appropriate and structured information technology..

Aplikasi Laporan Keuangan Musala Al-Maghfiroh RW 023 Kelurahan Kaliabang Tengah Bekasi Berbasis Website

The prayer room is a place of worship and is one of the centers of Muslim activities apart from the mosque. The financial management of prayer rooms which still uses a manual management system causes prayer rooms to have difficulty processing data and takes a long time. Therefore, a prayer room financial management information system is needed to make it easier for managers to input data and increase data accountability and transparency. This research aims to develop a web-based prayer room financial management information system. The data collection methods used were observation and literature study. System development is carried out through needs analysis, basic data design, and interface design using UML. The system was built using the PHP and HTML programming languages, using a bootstrap framework and creating basic data using MySQL. The research results show that the web-based prayer room financial management information system can make it easier for managers to input prayer room asset and financial data. This system can also increase accountability and data transparency, so that it can provide real-time financial report information to the congregation and the public regarding prayer room management. It is hoped that this research can make a positive contribution to the efficiency of prayer room financial management, become a reference for other prayer rooms that still use manual systems, and overall, strengthen the quality of community service activities at the local level.

Comparison of Min-Max and EOQ Methods in Web-Based Stock Management Information System

Warehouse stock management is very important for the sustainability of a business, especially building stores that have a lot of goods. Many problems occur in the absence of stock information management in a business. This happens at Pelita Building Store which has a lot of goods so it is very difficult for the owner to decide which items to stock based on priority. This study aims to help business owners to carry out stock management by comparing two inventory methods, namely the Economic Order Quantity (EOQ) and Min-Max methods. The comparison is carried out with the aim of determining the most optimal method that can be used for stock management in the building shop business case. This research uses a system development method by adopting the prototype method. This research was tested by conducting blackbox and accuracy testing. The results of this study based on blackbox testing stated that the features in the application function properly and can be used for stock management. In addition to black box testing, accuracy testing is also carried out. Accuracy testing is done by comparing the data from the information system calculation with the data from the manual calculation. After comparison, an accuracy of 100% is obtained, thus it can be concluded that this application can be used to help shop owners determine priority stock and the most accurate method is to use the EOQ method

Employee Acceptance of Human Resource Management Information System: Integrated UTAUT and TTF Model in a Selected Public Firm in Sri Lanka

Aim: In the modern digital world, many companies are moving towards technology-based applications to perform human resource administration work. Employees nowadays are capable of accessing a web-based Human Resource Management Information System (HRMIS) to obtain critical data from recognized techniques such as System Applications and Products (SAP), PeopleSoft, Bann and Lawson. This study aims to investigating the factors affecting the adopting intention of HRMIS in a selected public firm in Sri Lanka.
 Design: Acknowledging the vital concepts on accepting or resisting technology, six components (performance expectancy, effort expectancy, social influence, facilitating conditions, task characteristics, and technology characteristics) from the Unified Theory of Acceptance and Use of Technology (UTAUT) model and the Task Technology Fit (TTF) model were contextualized to investigate the drivers influencing HRMIS adoption intentions in a selected public firm in Sri Lanka. Target population was identified as the Executives, Supervisors/Technical Officers, Clerical and Allied employees of the chosen public company in Sri Lanka. A structured online questionnaire, including 30 items, was used to collect data.
 Findings: Multiple regression analysis results revealed that the factors of Performance Expectation, Task Characteristics, and Technology Characteristics have a positive influence on users’ adoption intention to HRMIS. Effort Expectancy, Social Influence, and Facilitating Conditions had negative influence.
 Implications: The outcomes highlight the necessity of combining TTF components with technology acceptance theories when evaluating the factors influencing acceptance of HRMIS or other information systems. The study's findings will aid management in making the required organizational changes to encourage employees to use the HRMIS application.

Web-Based Asset Management Information Systems in Higher Education

This study aims to determine the Asset Management Information System in Higher Education. The research method used in this study is the SLR (Systematic Literature Review) method. In this study, SLR (Systematic Literature Review) is used to identify, review, evaluate, and interpret previous studies on the Google scholar database with a period of the last 10 years, namely 2013-2023. The results showed that universities do not yet have an internal information system to control their assets. The absence of an asset management information system will have difficulty in tracing asset data. Solutions to overcome existing problems require a web-based asset management information system that can carry out asset management to be more efficient and organized, and make it easier to collect the number of assets, data about assets based on their condition, grouping assets by type, and make it easier to search asset data.