Main Article Content

Didik Setiyadi

Abstract

Database System Development Life Cycle (DSDCL) is a method in database development. While the database language used to modify and retrieve data in a database is Data Manilation Language (DML). The DML that is often used is Structured Query Language (SQL) which is used to search and manipulate data in relational databases. SQL consists of simple syntax in the form of commands to manipulate data, these commands are called queries. The query language is used in implementing the Library System database using SQL Server 2008 RDBMS. The first step before performing DML using the query editor, must have a database and data that has been implemented with SQL Server 2008. In this discussion, only 4 (four) DML statements are explained. namely select, insert, update and delete by using the Library System database with SQL Server 2008 RDBMS. The select statement is used to display data from a table (1 or more) in the database. Update is used to make changes to data in tables in the database. Insert is used to fill in data and delete is used to delete data in tables in the database.

Downloads

Download data is not yet available.

Article Details

How to Cite
Setiyadi, D. (2021) “Database System Development Life Cycle (DSDLC) on System Libraries for Data Manipulation Language (DML) Using SQL Server 2008: -”, Jurnal Mantik, 5(2), pp. 1065-1071. doi: 10.35335/jurnalmantik.Vol5.2021.1448.pp1065-1071.
References
[1] D. Setiyadi, Sistem Basis Data dan SQL (Structured Query Language). Bogor: Mitra Macana Media, 2020.
[2] D. Setiyadi and D. Abdullah, Mudah dan Cepat Belajar Database dengan SQL Server 2008. Lhokseumawe: Sefa Bumi Persada, 2020.
[3] W. Widodo, Agus and D. Kurnianingtyas, Sistem Basis Data. Malang: UB Press, 2017.
[4] T. Aziz, E. Haq, and D. Muhammad, “Performance based Comparison between RDBMS and OODBMS,” Int. J. Comput. Appl., vol. 180, no. 17, pp. 42–46, 2018.
[5] N. Jayanti, Ari, Dewi, Ketut and N. Sumiari, Kadek, Teori Basis Data. Yogyakarta: Andi, 2018.
[6] J. Kachaoui and A. Belangour, “MQL2SQL: A proposal data transformation algorithm from mongoDB to RDBMS,” Int. J. Adv. Trends Comput. Sci. Eng., vol. 9, no. 2, pp. 2457–2463, 2020.
[7] C. Gy?rödi, R. Gy?rödi, and R. Sotoc, “A Comparative Study of Relational and Non Relational Database,” vol. 6, no. 11, pp. 78–83, 2015.
[8] J. Hakim Lubis and E. Muisa Zamzami, “Relational database reconstruction from SQL to Entity Relational Diagrams,” J. Phys. Conf. Ser., vol. 1566, no. 1, 2020.
[9] M. Ohyver, J. V. Moniaga, I. Sungkawa, B. E. Subagyo, and I. A. Chandra, “The comparison firebase realtime database and MySQL database performance using wilcoxon signed-rank test,” Procedia Comput. Sci., vol. 157, pp. 396–405, 2019.
[10] K. Bohora, A. Bothe, D. Sheth, and R. Chopade, “Backup and Recovery Mechanisms of Cassandra Database: A Review,” J. Digit. Forensics, Secur. Law, vol. 15, no. February, 2021.
[11] B. Sutejo, Sukses Sertiikasi Oracle Certified Professional (OCP) Exam 1Z0-007 @ Exam 1Z0-051. Jakarta: PT Elex Media Komputindo, 2010.
[12] Sourav Mukherjee, “SQL Server Development Best Practices,” Int. J. Innov. Res. Sci. Eng. Technol., vol. 8, no. 3, p. 8, 2019.
[13] K. Wahana, SQL Server 2012. Yogyakarta: Andi, 2013.
[14] R. Taft et al., “CockroachDB: The Resilient Geo-Distributed SQL Database,” Proc. ACM SIGMOD Int. Conf. Manag. Data, pp. 1493–1509, 2020.
[15] M. Nuryana and Sulistiyono, “Analisa dan Perancangan Sistem Front Office Hotel Bidakara Serang,” Protekinfo, vol. 1, no. September, pp. 1–5, 2014.
[16] J. Guo et al., “Towards complex text-to-SQL in cross-domain database with intermediate representation,” ACL 2019 - 57th Annu. Meet. Assoc. Comput. Linguist. Proc. Conf., pp. 4524–4535, 2020.
[17] M. Rigger, Z. Su, E. T. H. Zurich, and M. Rigger, “Testing Database Engines via Pivoted Query Synthesis This paper is included in the Proceedings of the 14th USENIX Symposium on Operating Systems Design and Implementation Testing Database Engines via Pivoted Query Synthesis,” 2020.
[18] E. Utami and Sukrisno, Mengoptimalkan Query pada Microsoft SQL Server. Yogyakarta: Andi, 2008.
[19] Indrajani, Database Design All in One (Theory, Practice and Case Study). Jakarta: PT Elex Media Komputindo, 2018.
[20] A. Sahfitri and S. Hartini, “Metode ADDIE Pada Aplikasi Interaktif Mengenal Bagian Tubuh Manusia Dua Bahasa Untuk Anak Sekolah Dasar,” Inf. Syst. Educ. Prof., vol. 3, no. 2, pp. 141–152, 2019.
[21] S. Bakhri, “Animasi Interaktif Pembelajaran Huruf dan Angka Menggunakan Model ADDIE,” INTENSIF J. Ilm. Penelit. dan Penerapan Teknol. Sist. Inf., vol. 3, no. 2, p. 130, 2019.
[22] S. Anwar, F. E. Schadaw, and Althafani, “Perancangan Animasi Interaktif Pengenalan Bahasa Sunda untuk Anak - anak dengan Metode ADDIE,” J. Ilmu Pengetah. Dan Teknol. Komput., vol. 3, no. 2, pp. 195–202, 2018.
[23] W. N. Cholifah, Y. Yulianingsih, and S. M. Sagita, “Pengujian Black Box Testing pada Aplikasi Action & Strategy Berbasis Android dengan Teknologi Phonegap,” STRING (Satuan Tulisan Ris. dan Inov. Teknol., vol. 3, no. 2, p. 206, 2018.