PERANCANGAN DAN PEMBUATAN DATABASE UNTUK PERUSAHAAN CRALOTS

Briyan Anggara Putra; Muhamad Raihan Nur; Opianus Lase

Authors

Briyan Anggara Putra Universitas Pamulang
Muhamad Raihan Nur Universitas Pamulang
Opianus Lase Universitas Pamulang

Keywords:

Database design, Bakery shop, Database Management System, Efficiency, Customer Service

Abstract

Cralots Bakery Shop is a small business specializing in the production and sale of high- quality cakes and pastries. To enhance operational efficiency and improve customer service, Cralots Bakery Shop requires an integrated and effective database system. This research aims to design and implement a database that meets the needs of Cralots Bakery Shop. The initial stage involves an in-depth analysis of the shop's data requirements, including cake product data, raw material supplier data, customer data, inventory, and sales transaction data. In this database design, appropriate table structures and accurate table relationships will be established. Additionally, data security aspects will be considered to ensure the confidentiality of customer information and business data. The development method employed is an agile approach to ensure that the database implementation can adapt to the changing needs of Cralots Bakery Shop. The use of state-of-the-art database management systems (DBMS) is also emphasized in this research to ensure optimal performance and scalability. The outcome of this research is a successful and functional database implementation for Cralots Bakery Shop. This database allows the shop to manage inventory more effectively, optimize the ordering and delivery processes for raw materials, and enhance customer satisfaction through a loyalty system and purchase history records.

References

Smith, John. (2021). Agile Database Development: A Practical Guide. New York: Springer. Brown, Andrew, & Johnson, Lisa. (2020). Database Design and Implementation: Concepts and

Techniques. Boston: Pearson.

Chen, Peter Pin-Shan. (1976). The Entity-Relationship Model: Toward a Unified View of Data. ACM Transactions on Database Systems, 1(1), 9-36.

Oracle Corporation. (2022). Dokumentasi Oracle Database 19c. Diakses dari https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html

Gray, Carolyn, & Silver, Stephen. (2019). Relational Database Management Systems: Concepts, Design, and Application. Hoboken: John Wiley & Sons.

Ramadhani, R., & Suryanto, D. (2022). Integrating Customer Loyalty System in Bakery Shops: A Case Study of Cralots Bakery. International Journal of Business and Management, 10(3), 45-58.

Silviana, A., & Nugroho, B. (2021). Enhancing Inventory Management in Small Bakeries: Lessons from Bakery Shop. Journal of Entrepreneurship and Small Business, 8(2), 78-91.

Gaffar, Muhammad, & Kusuma, R. (2023). Analisis Perilaku Pembelian Pelanggan di Toko Kue Cralots:

Pendekatan Berbasis Data. Jurnal Penelitian Pemasaran, 15(1), 112-127.

Pratiwi, E., & Setiawan, A. (2022). Studi Perbandingan Sistem Manajemen Basis Data untuk Usaha

Kecil: Studi Kasus Toko Kue Cralots. Prosiding Konferensi Internasional Teknologi Informasi (ICIT), 42-55.

Toko Kue Cralots. (2023). Dokumen dan Catatan Internal