SISTEM INFORMASI UJIAN SEKOLAH ONLINE SMP NEGERI 5 MEDAN BERBASIS DATA WAREHOUSE

Nikita Br Nababan; Andrian Syahputra; Sri Panca Rani; Satria Pasaribu; Bremi Br Ginting

doi:10.51903/pixel.v16i1.1205

Nikita Br Nababan Universitas Potensi Utama
Andrian Syahputra Universitas Potensi Utama
Sri Panca Rani Universitas Potensi Utama
Satria Pasaribu Universitas Potensi Utama
Bremi Br Ginting Universitas Potensi Utama

DOI: https://doi.org/10.51903/pixel.v16i1.1205

Keywords: Kata kunci: Ujian online, Datawarehouse, waterfall, PHP, MySQL.

Abstract

Web-based information systems are in high demand in various circles of society, including in the world of non-computer education, where the written examination system commonly used in education often has many obstacles. Factors must also be considered when evaluating written tests, as many participants may avoid writing notes on cards and waste paper and ink to ask and repeat questions, including negative factors in written tests, so this study aims to do so. a database-based online exam system that educational institutions can use to convert existing written exams into an online exam system. Therefore, with the rapid development of information technology, it is necessary to design and build an online examination system based on Data Warehouse to replace the manual written examination system and facilitate the work of the teacher in SMP Negeri 5 Medan. Primary schools enter question data into the system and can minimize the operational costs of passing exams, and the system can also store data more securely in its data warehouse, i.e. teacher information, basic information, student information. subject information, value information and question information. The method is Data Warehouse, software procedures and Waterfall model. The survey respondents were 150 students from SMP Negeri 5 Medan, a total of 150 students. This online exam system was created using PHP programming language, MySQL database and XAMPP web server

References

[1] Conolly,Thomas dan Begg Carolyn(2002). Database systems – A Practical Approach to Design, Implementation and Management, edisi-3. Addison Wesley Longman.Inc., USA
[2] Becker, Jason, et al. "Data Warehouse Design: Modern Principles and Methodologies." McGraw-Hill Education, 2014.
[3] Boehm, Barry W. "A spiral model of software development and enhancement." Computer, vol. 21, no. 5, pp. 61-72, 1988.
[4] Fatansyah(2002). Buku Teks Ilmu Komputer – Basis Data, cetakan-4. Informatika
[5] Inmon, W.H.(2002). Building the Data Warehouse,edisi-3. Wiley Computer Publishing.
[6] Kimball,R.,Merz, R (1998). The Data Warehouse Lifecycle Toolkit. Expert Methods for Designing, Developing and Deploying Data Warehouses. Wiley Computer Publishing, Canada.
[7] Kimball, Ralph, and Margy Ross. "The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence." John Wiley & Sons, 2016.
[8] Paulraj, Ponniah. "Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals." John Wiley & Sons, 2011.
[9] Pressman, Roger S. "Software engineering: a practitioner's approach." McGraw-Hill Education, 2014.
[10] Royce, Winston W. "Managing the development of large software systems: concepts and techniques." Proceedings of the 9th international conference on software engineering. IEEE Computer Society Press, 1987.
[11] Sapia, Claudio. "Data Warehousing Design and Advanced Engineering Applications: Methods for Complex Construction." IGI Global, 2013.
[12] Sommerville, Ian. "Software engineering." Addison-Wesley, 2016.