Implementation of SMES Address Information Data Processing Database Design Using Python Programming

  • Muhammad Sholeh
  • Suraya
  • Dina Andayati
Keywords: SMES, Flask Framework, database, python

Abstract

This study aims to implement a database using Flask framework in Python programming language. The database management system used was MySQL. The database contained data about SME addresses. There were 5 interrelated tables that were the table of UKM, the table of alamat_UKM, the table of kelurahan, the table of kecamatan, and the table of kabupaten. The researchers applied the waterfall model. This model was carried out by taking a sequential approach in software development. The steps in this model were system and software requirements, analysis, design, coding, testing, and maintenance. This study resulted in 2 applications that were the Python-based application which was a server-side program and the website-based application which was a client-side program. In developing the applications, all processes in the database management system consisting of CRUDs (Create, Read, Update, Delete and Search) were developed, implemented, and processed in accordance with the transactional process in database management.

References

Abduh, T. (2017). Strategi Internasionalisasi UMKM. SAH MEDIA.

Bhasin, H. (2019). Python basic A Self Teaching Introduction. David Pallai.

Carlos Coronel, S. M. (2017). Database Systems: Design, Implementation, & Management. Cengage.

Copperwaite, M., & Leifer, C. (2015). Learning Flash Framework. In Packt Publishing. Packt Publishing. www.packtpub.com

Fauzi, R., Wibowo, S., & Youlina, D. (2018). Perancangan Aplikasi Marketplace Jasa Percetakan Berbasis Website Abstrak. 3(1).

Febriyantoro, M. T., & Arisandi, D. (2018). Pemanfaatan Digital Marketing Bagi Usaha Mikro, Kecil Dan Menengah Pada Era Masyarakat Ekonomi Asean. Jurnal Manajemen Dewantara, 1(2), 61–76. http://ejournal.stiedewantara.ac.id/index.php/JMD/issue/view/32

Grinberg, M. (2018). Flask Web Development Developing Web Applications with Python. O’Reilly Media, Inc. http://oreilly.com/safari

Gutierrez-Leefmans Catalina Nava-Rogel, R. M., & Andrea, T.-L. M. (2016). digital analytics tools and their predictive power on performance: An analysis of the Brazilian auto market. Revista Brasileira de Marketing, 15(2), 220–236. https://doi.org/10.5585/remark.v15i2.3216

Hakim, L. (2019). Pelatihan Pemasaran Online Berbasis Marketplace Bagi UMKM Dalam Merespon Perubahan Perilaku Konsumen. Loyalitas, II(1), 74–91.

Halachev, P. (2020). Web application with Python and security of the information system. INTERNATIONAL, 6(3), 103–106.

Hanief, S., Januhari, N. N. U., & Asmara, A. . R. (2020). Pelatihan Digital Marketing Memanfaatkan Sosial Media dan Marketplace pada Usaha Dekorasi dan Catering Pernikahan. WIDYABHAKTI, 2(3), 146–156.

Hardiyanto, D., Sholeh, M., & Rachmawati, R. Y. (2020). Optimization of information technology utilization based on geography information system as a marketing media for micro, small, and medium enterprises to improve competitiveness in Bantul Regency, Indonesia. IOP Conference Series: Materials Science and Engineering, 807(1). https://doi.org/10.1088/1757-899X/807/1/012010

Henderi. (n.d.). Sistem Basis Data: Model Relasional, SQL, dan Object Oriented Database. Bintang Pustaka Madan.

Indrajani. (2018). Database Design All in One: Theory, Practice, and Case Study. Elex Media Komputindo.

Is-haq, H. O. (2019). Digital Marketing and Sales Improvement in Small and Medium Enterprises in Nigeria. International Journal of Innovation and Research in Educational Sciences, 6(6), 803–810.

Mokhtar, N. F. (2015). Internet Marketing Adoption by Small Business Enterprises in Malaysia. International Journal of Business and Social Science, 6(1), 59–65.

Patil, S. J. (2019). Python - Using Database and SQL. International Journal of Science and Research (IJSR), 8(2), 83–85. https://www.ijsr.net/archive/v8i2/ART20194929.pdf

Permatasari, Maurisia Putri, & Endriastuti, A. (2020). Pelatihan Pemanfaatan Media Sosial Sebagai Alat Pemasaran Bagi Umkm Di Kecamatan Kedungpring, Kabupaten Lamongan, Jawa Timur. Jurnal Layanan Masyarakat (Journal of Public Services), 4(1), 91. https://doi.org/10.20473/jlm.v4i1.2020.91-99

Pirnat, M. (2015). How to Make Mistakes in Python. O’Reilly Media, Inc.

Raharjo, B. (2017). Belajar Otodidak Flash. Penerbit Informatika.

Ramdani, A. L., & Firmansyah, H. B. (2018). Clustering Application for UKT Determination Using Pillar K-Means Clustering Algorithm and Flask Web Framework. Indonesian Journal of Artificial Intelligence and Data Mining, 1(2), 53. https://doi.org/10.24014/ijaidm.v1i2.5126

S. Sumathi, S. E. (2007). Fundamentals of Relational Database Management Systems. Springer-Verlag Berlin Heidelberg.

Sholeh, M., Triyono, J., & Rachmawati, R. Y. (2020). Pendampingan Kelompok Informasi Masyarakat Dengan Memanfaatkan Marketplace Sebagai Media Pemasaran. Jurnal Penelitian Dan Pengabdian Kepada Masyarakat UNSIQ, 7(2), 158–164. https://doi.org/10.32699/ppkm.v7i2.965

Singh, M., Verma, A., Parasher, A., Chauhan, N., & Budhiraja, G. (2019). Implementation of Database Using Python Flask Framework. International Journal of Engineering and Computer Science, 8(12), 24890–24893. https://doi.org/10.18535/ijecs/v8i12.4399

Susanti, E., & Mailoa, E. (2020). RESTful API Implementation in Making a Master Data Planogram Using the Flask Framework ( Case Study : PT Sumber Alfaria Trijaya , Tbk ). Journal of Information Technology and Computer Science, 5(3), 255–269.

Widodo, P., & Imam, I. (2016). Perancangan Website Pertanian di Ploso Gede Ngluwar Magelang Sebagai Media Informasi Dan Pemasaran (Studi Kasus Pada Kelompok Tani Hidayah). Journal Speed – Sentra Penelitian Engineering Dan Edukasi, 10(4), 14–31. https://repository.bsi.ac.id/index.php/repo/viewitem/14048
Published
2021-07-30