Database Tables Used in the Lecturer Information System

Oct 13, 2025 by talynt.org 56 views

Improving Efficiency and Transparency of Lecturer Data: USU FMIPA Lecturer Information System

In today's digital age, information is a valuable asset for every institution, including the Faculty of Mathematics and Natural Sciences (FMIPA), University of North Sumatra (USU). To improve the efficiency of lecturer data management and information transparency, USU FMIPA developed a web-based lecturer information system. This system is designed to provide easy and centralized access to various information related to lecturers, such as educational history, publication, research, dedication, and scientific activities.

The development of the lecturer information system website utilizes a reliable software combination, namely Macromedia Dreamweaver 8 for ease and development speed, as well as XAMPP which is a complete package consisting of Apache Web Server, PHP, and MySQL to build a stable database system. This system uses several important tables for storing the necessary data, such as:

Database Tables Used in the Lecturer Information System

Table of Guidance_TA: Save data about the student's final project guidance.
User Table: Storing information system user data, such as lecturers, students, and administrators.
Publication Table: Store lecturer scientific publication data, such as journals, books, and proceedings.
Table of Service: Storing data on community service activities carried out by lecturers.
Research Table: Saving research data conducted by lecturers, both basic and applied research.
Subject Table: Save course data taught by the lecturer.
Activity_ilmiah Table: Save data on scientific activities followed by lecturers, such as seminars and conferences.
Data_dosen Table: Save the basic data of the lecturer, such as name, NIP, address, and contact.

Benefits of Lecturer Information Systems for USU FMIPA

The lecturer information system developed by USU FMIPA has several benefits for the faculty, including:

Data Management Efficiency

Data management efficiency: Centered lecturer data in one system, facilitating data access and update.
Transparency Information: Lecturer information can be easily accessed by all users, increasing transparency and accountability.
Improving data quality: This system encourages lecturers to update their data regularly, maintain the accuracy and relevance of information.
Improve communication effectiveness: This system facilitates more effective communication between lecturers, students, and administrators.

Conclusion

FMIPA USU Lecturer Information System is an important step in building an integrated and efficient information system in the USU FMIPA environment. It is hoped that this system can improve the quality of service, facilitate the decision-making process, and support the development of the faculty in a more advanced direction.

Future Development

The lecturer information system developed by USU FMIPA can be further developed to include additional features, such as:

Integration with other systems: Integrate the lecturer information system with other systems, such as student information system and library system.
Mobile accessibility: Make the lecturer information system accessible through mobile devices, such as smartphones and tablets.
Data analytics: Provide data analytics and reporting features to help administrators and lecturers make informed decisions.

By continuously improving and developing the lecturer information system, USU FMIPA can provide better services to its students, lecturers, and administrators, and support the development of the faculty in a more advanced direction.

Introduction

The Lecturer Information System (LIS) developed by the Faculty of Mathematics and Natural Sciences (FMIPA), University of North Sumatra (USU) is a web-based system designed to provide easy and centralized access to various information related to lecturers. In this article, we will answer some frequently asked questions (FAQs) about the LIS.

Q1: What is the purpose of the Lecturer Information System?

A1: The purpose of the LIS is to improve the efficiency of lecturer data management and information transparency, and to provide easy and centralized access to various information related to lecturers.

Q2: What are the benefits of using the Lecturer Information System?

A2: The benefits of using the LIS include:

Data management efficiency: Centered lecturer data in one system, facilitating data access and update.
Transparency Information: Lecturer information can be easily accessed by all users, increasing transparency and accountability.
Improving data quality: This system encourages lecturers to update their data regularly, maintain the accuracy and relevance of information.
Improve communication effectiveness: This system facilitates more effective communication between lecturers, students, and administrators.

Q3: What are the database tables used in the Lecturer Information System?

A3: The LIS uses several important tables for storing the necessary data, such as:

Table of Guidance_TA: Save data about the student's final project guidance.
User Table: Storing information system user data, such as lecturers, students, and administrators.
Publication Table: Store lecturer scientific publication data, such as journals, books, and proceedings.
Table of Service: Storing data on community service activities carried out by lecturers.
Research Table: Saving research data conducted by lecturers, both basic and applied research.
Subject Table: Save course data taught by the lecturer.
Activity_ilmiah Table: Save data on scientific activities followed by lecturers, such as seminars and conferences.
Data_dosen Table: Save the basic data of the lecturer, such as name, NIP, address, and contact.

Q4: How can I access the Lecturer Information System?

A4: The LIS can be accessed through the USU FMIPA website, and users can log in using their username and password.

Q5: What are the system requirements for the Lecturer Information System?

A5: The LIS requires:

Operating System: Windows or Linux
Browser: Internet Explorer, Google Chrome, Mozilla Firefox, or Safari
Database: MySQL
Server: Apache Web Server

Q6: How can I report any issues or errors with the Lecturer Information System?

A6: Users can report any issues or errors with the LIS to the USU FMIPA IT department through email or phone.

Q7: Can I integrate the Lecturer Information System with other systems?

A7: Yes, the LIS can be integrated with other systems, such as student information system and library system.

Q8: Is the Lecturer Information System accessible through mobile devices?

A8: Yes, the LIS can be accessed through mobile devices, such as smartphones and tablets.

Q9: Can I get data analytics and reporting features in the Lecturer Information System?

A9: Yes, the LIS provides data analytics and reporting features to help administrators and lecturers make informed decisions.

Q10: How can I get more information about the Lecturer Information System?

A10: Users can get more information about the LIS by contacting the USU FMIPA IT department through email or phone.