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

Suraya Suraya, Muhammad Sholeh

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.

Keywords


Database, Thesis, SQLite, Flask

Full Text:

PDF

References


Ula M, Tjut Adek R and Bustami B 2021 Emarketplace Performance Analysis Using PIECES Method Int. J. Eng. Sci. Inf. Technol. 1

Wing Wahyu Winarno 2021 Sistem Informasi dan Teknologi Informasi Sebuah Pengantar (Wingit Press)

S Pasaribu J 2021 Development of a Web Based Inventory Information System Int. J. Eng. Sci. Inf. Technol. 1

Acai Sudirman, Muttaqin Muttaqin, Ramen A. Purba, Alexander Wirapraja , Leon A. Abdillah, Fajrillah Fajrillah, Fatimah Nur Arifah, Julyanthry Julyanthry, Ronal Watrianthos J S 2020 Sistem Informasi Manajemen (Yayasan Kita Menulis)

Dahmani Z and Belarbi S 2014 New results for fractional evolution equations using Banach fixed point theorem Int. J. Nonlinear Anal. Appl. 5

Firmansyah M F and Maulana H Z 2021 Empirical Study of E-Learning on Financial Literacy and Lifestyle : A Millenial Urban Generations Cased Study Int. J. Eng. Sci. Inf. Technol. 1 75–81

Andreas Meier M K 2019 SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management (Springer)

Jeffrey A. Hoffer, Venkataraman Ramesh H T 2016 Modern Database Management

Toby J. Teorey, Sam S. Lightstone, Tom Nadeau H V J 2011 Database Modeling and Design: Logical Design (Elsevier)

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

Siahaan V 2020 MAHIR PYTHON/SQLITE: Membuat Dari Nol Database Sekolah (Balige Publishing)

Hendry 2015 Cepat Mahir MySQL dan SQLite (Elex Media Komputindo)

Maisa Putra D and Alfauzain A 2021 Design Of Tracer Using Microsoft Access Unit In Medical Record Primary Health In Padang Int. J. Eng. Sci. Inf. Technol. 1

Setiyadi A and Harihayati T PENERAPAN SQLITE PADA APLIKASI PENGATURAN WAKTU UJIAN DAN PRESENTAS Maj. Ilm. UNIKOM 13 221–6

Yuvaraj K, Oorappan G M, Megavarthini K K, Pravin M C, Adharsh R and Kumaran M A 2020 Design And Development Of An Application For Database Maintenance In Inventory Management System Using Tkinter And Sqlite Platform Design And Development Of An Application For Database Maintenance In Inventory Management System Using Tkinter And Sqlite Pl IOP Conf. Ser. Mater. Sci. Eng. Pap.

Bagus R, Putra D, Budi E S and Kadafi A R 2020 Perbandingan Antara SQLite , Room , dan RBDLiTe dalam Pembuatan Basis Data pada Aplikasi Android JURIKOM (Jurnal Ris. Komputer) 7 376–81

Trentadue R, Valassi A and Kalkhof A 2017 Text Data Storage Method Modification for SQLite Relational Database Text Data Storage Method Modification for SQLite Relational Database J. Phys. Conf. Ser. Pap. 5–10

Kengalagutti D and G A C 2020 Comparing Database Management Systems : MySQL , PostgreSQL , SQLite Int. Res. J. Eng. Technol. 7 2238–41

Bhosale S T and Patil P 2015 SQLite : Light Database System Int. J. Comput. Sci. Mob. Comput. 3 882–5

Raharjo B 2017 Belajar Otodidak Flash (Bandung: Penerbit Informatika)

Susanti E and Mailoa E 2020 RESTful API Implementation in Making a Master Data Planogram Using the Flask Framework ( Case Study : PT Sumber Alfaria Trijaya , Tbk ) J. Inf. Technol. Comput. Sci. 5 255–69

Ramdani A L and Firmansyah H B 2018 Clustering Application for UKT Determination Using Pillar K-Means Clustering Algorithm and Flask Web Framework Indones. J. Artif. Intell. Data Min. 1 53

Putra M G L and Putera M I A 2019 Analisis Perbandingan Metode Soap Dan Rest Yang Digunakan Pada Framework Flask Untuk Membangun Web Service SCAN - J. Teknol. Inf. dan Komun. 14 1–7

Adawadkar K 2017 Python Programming-Applications and Future Int. J. Adv. Eng. Res. Dev. 4 1–4

Wang J and Wang W 2018 Design of Data Mining of WeChat Public Platform Based on Python Design of Data Mining of WeChat Public Platform Based on Python J. Phys. Conf. Ser. Pap.

Halachev P 2020 Web application with Python and security of the information system INTERNATIONAL 6 103–6

Dharma Utamayasa I G 2021 Efect Physical Activity and Nutrition During The Covid-19 Pandemic Int. J. Eng. Sci. Inf. Technol. 1

Siahaan V and Sianipar R H 2019 LANGKAH DEMI LANGKAH PEMROGRAMAN DATABASE SQLITE DAN MYSQL DENGAN GUI PYTHON (SPARTA PUBLISIHING)

Copperwaite M and Leifer C 2015 Learning Flash Framework (Packt Publishing)

Agus Wahyu Widodo D K 2017 Sistem Basis Data (Malang: Universitas Brawijaya Press)

Pamungkas C A 2017 Pengantar dan Implementasi Basis Data (Yogyakarta: Deepublish Publisher)

Adyanata L 2016 Basis Data Dasar




DOI: https://doi.org/10.52088/ijesty.v2i1.197

Refbacks

  • There are currently no refbacks.


Copyright (c) 2021 Suraya Suraya, Muhammad Sholeh

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

International Journal of Engineering, Science and Information Technology (IJESTY) eISSN 2775-2674