Penerapan metode nested query untuk menetukan siswa penerima bantuan PIP

Adiat Pariddudin - [ https://orcid.org/0000-0003-3333-3744 ]
Muhamad Firdaus

Abstract

Cijujung 04 State Elementary School is one of the basic educational institutions that is always developing with the number of students increasing from time to time. Cijujung 04 Public Elementary School is a state school, this school is located in the Cikupa-Nagrak village of Cijujung village, cibungbulang sub-district, Bogor Regency. Public elementary schools or other private elementary schools also have very important data. One of them is a master book. The student handbook is a data set of students studying at the school. Student Parent Book is one of the most important parts of the management of this institution. The notes in the master book must be complete. Includes, student biodata, student grades, and student achievement results from the first semester to graduate school. However, in its implementation so far it has been ineffective and inefficient because it is carried out manually, namely by writing data in a thick ledger or a master book. The teacher also had difficulty finding student data in the parent book and also sought students for prospective recipients of PIP assistance. A system is needed that can be used by teachers to find student data in the parent book and also look for students for potential recipients of PIP assistance. Nested queries or queries are queries that have other queries in them. By using the nested query method in the parent book system, the search process for prospective PIP recipient students can be searched as needed because in the parent book system has a student search feature based on the desired category. Based on the nested query method. From the results of the distribution of questionnaires to test the system distributed to informatics engineering system respondents obtained a percentage of system eligibility of 87% so that it can be categorized as very feasible, while the results of distributing questionnaires to user respondents obtained a percentage of system feasibility of 94.5% so that it can be categorized as very feasible

Keywords

Nested Query; Log Book.

References

Arikunto, Suharsimi. 2015. Management Penelitian. Edisi revisi. Jakarta . R Ineka Cipta.

Dewi Mustika Melani, Rezeki Novandi. ANALISIS PERBANDINGAN OPTIMASI QUERY NESTED JOIN DAN HASH JOIN PADA MY SQL SERVER. Teknik Informatika. STMIK AMIKOM Yogyakarta.

Indrajani S.Kom., MM., 2014. Database Systems Case Study All In One. Gramedia. Jakarta.

Irmayansyah, Irmayansyah, and Salvinia Natans. "Penerapan Metode Bottom-Up untuk Mendasin Ulang Database pada Sistem Informasi Perhotelan Front Office InspiredHMS" Teknois, 2019, doi:10.36350/jbs.v9i1.4

Kirran Verra L, Muralikhrisna S. 2013. VISION BASED DEEP WEB DATA EXTRACTION ON NESTED QUERY RESULT RECORDS. Computer Science & Engineering, MITS, Madanapalle, india.

Lohman M Guy, Daniels Dean, Haas M Laura, Kistler Ruth, Selinger G Ptricia. OPTIMIZATION OF NESTED QUERIES IN A DISTRIBUTED RELATIONAL DATABASE. Carnaige Mellon-University.

May Norman, Helmer Sven, Morkoto Guido. 2003. NESTED QUERIES AND QUANTI_ERS IN AN ORDERED CONTEXt. Fakult¨at f¨ur Mathematik und Informatik. Universit¨at Mannheim. Germany.

Pradhan Chittaranjan, Jena Sangita Sushree, Mahapatra kumar Prasanta. 2010. OPTIMIZED QUERY PLAN ALGORITHM FOR THE NESTED QUERY. Computer Engineering, KIIT University, Bhubaneswar, India.

Pranata Antony. 2005. Algoritma dan Pemrograman. Graha Ilmu. Yogyakarta.

Pressman, Ph. D, R, S. 2012. Rekayasa Perangkat Lunak Yogyakarta :Andi.

Prihatin Nilaliliana. 2017. OPTIMASI QUERY PADA SISTEM INFORMASI PENCATATAN AKTIFITAS PERUBAHAN DATA NILAI MAHASISWA. Ilmu Komputer. Universitas Lampung.

Sidik Betha, 2012. Pemrograman web dengan php.Informatika Bandung.

Sinuraya Junus. 2017. METODE PENCARIAN DATA MENGGUNAKAN QUERY HASH JOIN DAN QUERY NESTED JOIN. Teknik Informatika. Politeknik Negeri Medan.

Sjukani, Moh. 2014. ALGORITMA (Algoritma dan Struktur Data 1) dengan C, C++, dan Java – Teknik – Teknik Dasar Pemrograman Komputer. Edisi 9. Mitra Wacana Media. Jakarta. 14. Sugiyono. 2014. METO

Article metrics

Abstract views : 90 | views : 65

Refbacks

  • There are currently no refbacks.