Designing and Implementing a Database for Thesis Data Management by Using the Python Flask Framework

Abstract

This study aims to implement the database design used in thesis data processing using Flask. The results of the database design produce four tables, namely the lecturer table is used to store lecturer data, the student table is used to store student data, the title of thesis table is used to store data related to student thesis and the guidance table contains history during guidance with the supervisor, The design of the thesis data processing database was developed using Flask. Flask is a web framework written in Python. Flask serves as the application framework and the interface of the web-based flask application. In this research, the methodology used is to implement database development which consists of system analysis, logical design, physical design and implementation. The database design methodology is carried out by 1. Building a local conceptual data design based on user views, 2. Building and validating local logical data models, 3. Building and validating logical data models, 4. Translating logical data models for the database management system, 5. Designing and implementation of physical representation. The results show that the process of creating a thesis data management database can be done using the Flask framework. The development process using the flask framework includes the process of creating databases, tables and reading, adding, repairing and deleting data. In making the application, the application is divided into 2, namely the application used for database management and the application used to display website-based results that are used to display the results of data processing from the application. Implementation of data structures in the database design and applications used include programming language: Python 3.7.0, framework for displaying web-based data: Flask 1.1.2, and database management system using SQLite.

Rancang Bangun Sistem Pencatatan Penjualan dan Pembelian untuk Toko Lancar Elektronik

“…Untuk merancang bangun sistem tersebut, terdapat beberapa teknologi yang perlu digunakan. Sistem akan dibuat dengan menggunakan Flask karena keuntungan dari menggunakan framework tersebut adalah mudah dipahami dan fleksibel [8]. Bahasa pemrograman yang digunakan dalam pengembangan ini adalah bahasa Python karena Python menyediakan banyak modul third-party, menyediakan banyak libraries, bersifat open-source, mudah dipelajari, stuktur data yang bersifat user friendly, dan memiliki pemrosesan yang cepat [9].…”

Development of Operational Application System at PT. XYZ with Flask Overriding

“…XYZ can design and implement web applications specifically customized to meet their non-physical product inventory data processing needs with the advantages of Flask Overriding, such as the ability to access and manage databases easily, as well as the ability to integrate various additional features and extensions, PT. XYZ can quickly develop a system that suits the company's specific needs [5][6] [7].…”

Implementasi Python Framework Flask Pada Modul Transfer Out Toko Di Pt Xyz

“…Aplikasi yang dibuat mampu melakukan proses pengolahan database seperti delete, update, dan searching. Dari penelitian Suraya, didapat kesimpulan bahwa framework Flask bisa menjadi solusi untuk pemrograman berbasis web menggunakan Python [11]. Penelitian yang dilakukan oleh Suraya fokus pada perancangan sistem pengolahan database untuk manajemen data skripsi menggunakan framework Flask, sementara penelitian yang akan dilakukan lebih fokus pada pengembangan aplikasi Distribution Center System menggunakan Python dan framework Flask.…”