Analysis and Implementation of a Simple Database Management Software Based on Python and Excel

Shanwen Lei

doi:10.54097/k9c58g42

Authors

Shanwen Lei

DOI:

https://doi.org/10.54097/k9c58g42

Keywords:

Database management software, Python, Data export, Data import.

Abstract

This paper aims to address the challenges faced by small and medium-sized enterprises (SMEs) and individual users in database management. It adopts a combination of Python and Excel to simplify the operational process and enhance the user interface, thereby reducing the learning curve and technical requirements for managing databases. Users can effortlessly manage their databases, leading to improved work efficiency. This project breaks through the limitations of traditional database management software, offering a simple, efficient, and low-resource solution.

Downloads

Download data is not yet available.

References

Lemahieu, W., vanden Broucke, S., & Baesens, B. (2018). Principles of database management: the practical guide to storing, managing and Analyzing big and small Data. Cambridge University Press.

Ghiani, G., Laporte, G., & Musmanno, R. (2022). Introduction to Logistics Systems Management: With Microsoft Excel and Python Examples. John Wiley & Sons.

Suraya, S., & Sholeh, M. (2022). Designing and implementing a database for thesis data management by using the python Flask Framework. International Journal of Engineering, Science and Information Technology, 2(1), 9-14.

Toman, S. (2021). Web application for Data Import from XLSX into a Relational Database.

Lindstrom, G. (2005). Programming with python. IT professional, 7(5), 10-16.