Claim Missing Document
Check
Articles

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

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.
Manajemen Proyek Sistem Informasi Pendataan Penjualan Donat Kawan Mamak Berbasis Web Dengan Menggunakan Framework Laravel Utama, Arya Dwi; Yahfizham, Yahfizham
Jurnal Sains, Teknologi & Komputer Vol. 1 No. 2 (2024): SAINTEK: Jurnal Sains, Teknologi & Komputer
Publisher : Lembaga Riset Mutiara Akbar

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

Abstract

This research aims to develop a web-based information system for managing donut sales at Kawan Mamak, in response to the rapid growth of the culinary industry. Using the Software Development Life Cycle (SDLC) approach, this system is designed to meet users' needs in efficiently managing sales data. Analysis of requirements, design, implementation, testing, and maintenance are the main stages in the development of this system. A solid database relationship between customer, sales, and donut variant tables is created to enhance system integration and responsiveness. A cheerful and efficient interface design is expected to improve user experience and positively contribute to the development of information technology in the culinary sector. With a focus on integrated sales management, this system aims to enhance Kawan Mamak's competitiveness by providing effective solutions to optimize the donut sales data recording process.