Perancangan Database Relasional Data Lansia Panti Jompo Graha Kasih Bapa Kabupaten Kubu Raya

Atanasia, Gusti Syarifudin

Abstract


The author conducts research on data management in the Graha Kasih Nursing Home in Kubu Raya District, which is to find problems with data processing that still uses paper so that it is susceptible to errors in the data recording process and the risk of data loss is very large, making it difficult to access data. Therefore the author designed a Relational Database for elderly data at the Graha Kasih Nursing Home of Kubu Raya District to overcome the problem. The form of research used in this study uses a case study with R & D (Research and Development) method which is a descriptive method which is the initial method of R & D method to collect data about existing conditions. While the data collection techniques used are interviews, observation and documentation studies. The method of analysis and design used in this research is the Database Method of Life Cycle (DBLC), with the focus of the discussion including Conceptual Database Design, Logical Database design, and Physical Database Design. Flowchat is used to describe existing running systems, while the proposed system modeling and design uses UML (Unified Modeling Language). The design of this Relational Database is made with Visual Basic .NET programming language as its design tool and MYSQL as its database. The designed database resulted in an application that could help the Graha Kasih Nursing Home of Kubu Raya District to facilitate the management of occupants 'data, contribution data, data on residents' transfers, contributor data, donation data, and employee data, as well as minimizing the risk of data damage and data loss. , and facilitate the process of accessing data easily and quickly.

Keywords


Relational Database; Flowchart; UML; DBLC; Visual Basic.NET; MYSQL;

Full Text:

PDF

References


Marthin, J., 1975, Computer Database Organization, parth I dan II, New Jersey: PrenticeHall, Inc.

Silberschatz, A., Korth, H.F., and Sudarshan, S., 2001, Database System Concepts, 4th Edition, New York: McGrow-Hill.

Oetomo, Budi Sutedjo Dharma, 2002, Perencanaan dan Pembangunan Sistem Informasi, Andi, Yogyakarta.

Hariyanto, Bambang Ir. MT., 2004, Sistem Manajemen Basis Data, Informatika, Bandung.

Sutanta, E., 2004, Sistem Basis Data, Graha Ilmu, Yogyakarta.

Stephens, Ryan, Plew, Ron, 2004, Sams Teach Yourself SQL, in 21 Days, 4th Edition, California: Que/Sams.

Jogiyanto, HM., 2005, Analisis dan Desain Sistem Informasi: Pendekatan Terstruktur Teori dan Praktek Aplikasi Bisnis, Edisi Ketiga, CV ANDI OFFSET, Yogyakarta.

Laudon, Kenneth C. dan Laudon, Jane P., 2005, Management Information Systems: Managing the Digital Firm, 8th Edition, Prentice Hall, New Jersey.

Mcleod, Raymond Jr., dan Schell, George P., 2007, Sistem Informasi Manajemen, Jilid 1, Edisi Ketujuh, Hendra Teguh, PT Prenhallindo, Jakarta.

Suyanto, Asep Herman., 2007, Step by Step: Web Desain Theory and Practices, CV ANDI OFFSET, Yogyakarta.

Daramayuda, Ketut, Pemrograman Aplikasi Database dengan Microsoft Visual Basic.NET 2008, Informatika, Bandung.

Sugiyono, 2008, Metode Penelitian Kualitatif dan R&D, ALFABETA, Bandung.

Connolly, Thomas dan Begg, Carolyn, 2010, Database System: A Practical Approach to Design, Implementation, and Management, Fifth Edision, Pearson Education, Boston.

Nugroho, Adi., 2011, Perancangan dan Implementasi Sistem Basis Data, Andi, Yogyakarta.

Indrajani, 2011, Perancangan Basis Data pada Klinik, ComTech, Jakarta, Juni 2011.

Indrajani, 2011, Bedah Kilat 1 Jam: Pengantar dan Sistem Basis Data, PT Elex Media Komputindo, Jakarta.

Indrajani, 2011, Perancangan Basis Data dalam All in One, PT Elex Media Komputindo, Jakarta.

Fathansyah, 2012, Basis Data, edisi revisi, Informatika, Bandung.

Rosa A.S. dan M. Shalahuddin, 2013, Rekayasa Perangkat Lunak Terstruktur dan Berorientasi Objek, Informatika, Bandung.

Tominanto, 2013, Pengembangan Sistem Informasi Pengolahan Data Pendaftaran Pasien Rawat Jalan Menggunakan Basis Data MySQL, INFOSKES, Surakarta, November 2013.

Kadir, Abdul, 2013, Pemrograman Database MySQL Untuk Pemula, MediaKom, Yogyakarta.

Rusdiana, M.H. dan Moch. Irfan, 2014, Sistem Informasi Manajemen, Pustaka Setia, Bandung.

Indrajani, 2014, Pengantar Sistem Basis Data Case Study All in One, PT Elex Media Komputindo, Jakarta.

Gat, 2015, Perancangan Basis Data Perpustakaan Sekolah dengan Menerapan Model Data Relasional, Citec Journal, Pontianak, Agustus 2015.

Jubilee Enterprise, 2015, Pengenalan Pemrograman Komputer, PT Elex Media Komputindo, Jakarta.

Putra, Dr. Nusa, 2015, Research and development, PT RajaGrafindo Persada, Jakarta.




DOI: http://dx.doi.org/10.30700/in.v1i1.892

Article Metrics

Abstract view : 87 times
PDF - 56 times

Refbacks

  • There are currently no refbacks.


Copyright (c) 2020 Atanasia, Gusti Syarifudin

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.