Perancangan Database Pada Sistem Asessmen Dan Pemetaan Hasil Asessmen Berbasis Tag Sebagai Pembantu Penyusunan Strategi Pembelajaran
DOI:
https://doi.org/10.18196/st.v20i2.3292Keywords:
Tag, database, asessmenAbstract
The Assessment and Mapping System of Tag-Based Assessment Results is an online-based system that aims to assist teachers and students in recording and mapping the assessment results for college admission. Information from the recording and mapping is very useful in helping the preparation of learning strategies and strategies to face the next exam. To support this assessment system required a database design. In the design of the database, the design is divided into 4 stages of Data Collection and Analysis, Conceptual Database Design, Logical database design, and Physical Database Design. The design of a conceptual database includes anyone involved in the system, what inputs are required, and what information (output) is desired from the database. While in logical database design, including the determination of Entities and attributes, determination of primary key, Entity Relationship Diagram (ERD). In the physical design, including ERD conversion to table form, normalization and implementation into the form of tables created on MS SQL Server. From the design of the database produces tables without anomalies, ie Eye, Student, Teacher, Testing, Problem, StandardValues, Tags, Groups, GrupMember, Member, EventUjian, Nilai, NomorSoal, PesertaUjian, Clipbooard, and OnGoingExam tables.
References
Adi, N. (2009). Rekayasa Perangkat Lunak Menggunakan UML dan Java. Yogyakarta.
Almazari, A. (2015). http://www.dokumenary.net/2015/03/22/tampilan-sementara-project-new-elearning/. Diambil kembali dari www.dokumenary.net.
Black, W. (2001). Assesment in Science: Practical Experience and Education Research.
http://jogdas.com/page/ujian_online. (2016). Diambil kembali dari www.jogdas.com.
http://sman10-kotaternate.sch.id/guru-5-197105221993032003.html. (2017). Diambil kembali dari www.sman10-kotaternate.sch.id.
http://www.bunafitkomputer.com/tag/aplikasi-e-learning-dengan-php. (2015). Diambil kembali dari www.bunafitkomputer.com.
http://www.kantin-php.com/2016/02/aplikasi-e-learning-responsive-ujian.html. (2016). Diambil kembali dari www.kanti-php.com.
https://business.tutsplus.com/id/tutorials/what-is-buddypress-how-to-set-up-and-use-it-right--cms-27443. (2017). Diambil kembali dari www.business.tutsplus.com.
L.P., V. A., Wijaya, A., & Irawan, d. A. (2006). Analisis dan Perancangan Sistem Basis Data Pendidikan pada Lembaga Musik Cantata.
Liana, T., & Ngalimin, J. (2012). Analisis dan Perancangan Sistem Basis Data E-learning Berbasis Web pada Sekolah Menengah Atas (SMA) Katolik Ricci.
Linda, M. (2004). Sistem Basis Data. Yogyakarta: Andi Offset.
Saputra, A. (2013). Membangun Aplikasi Online dengan PHP dan SQL Server. PT.Elex Media Komputindo.
Sukani. (2013). http://guraru.org/guru-berbagi/membuat-tes-online-sangat-mudah-dengan-edu20/. Diambil kembali dari www.guraru.org.
Sutanta. (2011). Dalam Basis Data Dalam Tinjauan Konseptual (hal. 91).
Thomas M. Connolly, C. E. (2005). Output System : A Practical Approach to Design, Implementation, and Management. Pearson Education.
Wibowo, C., Angelia, A., & Oenzil, A. N. (2013). Analisis dan Perancangan Sistem Basis Data Untuk Kegiatan Operasional Akademik pada SMP Darma Satria Persada.
Downloads
Published
How to Cite
Issue
Section
License
Semesta Teknika is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).