Article Per Year (5 Year)
p-Index From 2019 - 2024
0.23
P-Index
This Author published in this journals
All Journal Jurnal Sains, Teknologi dan Komputer
Lubis, Zaidah Nur Salamah
Unknown Affiliation
Agriculture, Biological Sciences & Forestry Chemistry Computer Science & IT Control & Systems Engineering Decision Sciences, Operations Research & Management

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search
Journal : Jurnal Sains, Teknologi dan Komputer

 1 
Pengembangan database Management system menggunakan My SQL Siregar, Ummi Kalsum; Sitakar, Tutur Arbaim; Haramain, Sultan; Lubis, Zaidah Nur Salamah; Nadhirah, Ulfi; Yahfizham, Yahfizham
Jurnal Sains, Teknologi & Komputer Vol. 1 No. 1 (2024): Jurnal Sains, Teknologi & Komputer (SAINTEK)
Publisher : Lembaga Riset Mutiara Akbar

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.56495/saintek.v1i1.450

Abstract

In today's digital era, the development of Database Management Systems (DBMS) explores the important role of storing, managing and accessing data efficiently. This research aims to analyze the DBMS development process using MySQL. Initial planning, where business needs and data requirements are identified. The database structure is then designed by considering normalization and relationships between entities. After installing MySQL, a database is created with a predetermined design. Next, the table is implemented by setting the columns, data types, and primary/foreign keys. User access rights are defined to ensure data security, and functions and stored procedures are implemented to facilitate complex data processing. Indexes are added to improve query performance. Backup and recovery management is an important focus in ensuring data continuity. Application integration is carried out by matching the application interface with the database system using the MySQL API or driver. This research presents a systematic guide for DBMS development using MySQL. Overall, using MySQL as a database management system offers flexibility, high performance and reliable security to support business needs in storing and managing data.
Co-Authors Haramain, Sultan Nadhirah, Ulfi Siregar, Ummi Kalsum Sitakar, Tutur Arbaim Yahfizham Yahfizham