Abstract

The goal of this research is to implement database management using SQLite in Python. Database management is used to organize, store, and manipulate data efficiently. It is done using a special software, called the "database management system" (DBMS), like SQLite. The purpose of database management is to ensure that data is always accessible, accurate, consistent, and secure. It also provides a solid foundation for data analysis and decision making. The basic operations of database management using SQLite are explained: importing library, creating database, creating tables, adding data, retrieving data, printing data, searching data, ordering data, updating data, computing data, aggregating data, grouping data, deleting data, and dropping tables. The developed program was tested on an experimental data. The program has successfully performed the basic operations of database management using SQLite and provided the required results.

References

• Sammut, C. & Webb, G. (2011). "Encyclopedia of Machine Learning". Springer.
• Kubat, M. (2021). "An Introduction to Machine Learning". Springer.
• Jung, A. (2022). "Machine Learning: The Basics". Springer.
• Li, H. (2023). "Machine Learning Methods". Springer.
• Forsyth, D. (2019). "Applied Machine Learning". Springer.
• Chopra, D. & Khurana, R. (2023). "Introduction to Machine Learning with Python". Bentham Science Publishers.
• Müller, A. & Guido, S. (2016). "Introduction to Machine Learning with Python: A Guide for Data Scientists". O'Reilly.
• Raschka, S. (2015). "Python Machine Learning". Packt Publishing.
• Zollanvari, A. (2023). " Machine Learning with Python". Springer.
• Sarkar, D., Bali, R., & Sharma, T. (2018). "Practical Machine Learning with Python". Apress.
• Zelle, J. (2017). "Python Programming: An Introduction to Computer Science". Franklin, Beedle & Associates.
• Padmanabhan, T. (2016). "Programming with Python". Springer.
• Chun, W. (2001). "Core Python Programming". Prentice Hall.
• Beazley, D. & Jones, B. (2013). "Python Cookbook: Recipes for Mastering Python 3". O'Reilly.
• Lutz, M. (2013). "Learning Python: Powerful Object-Oriented Programming". O'Reilly.
• Perkovic, L. (2015). "Introduction to Computing using Python: An Application Development Focus". Wiley.
• Downey, A. (2016). "Think Python: How to Think Like a Computer Scientist". O'Reilly.
• Date, C. (2006). "An introduction to Database Systems". Pearson.
• Elmasri, R. & Navathe, S. (2016). "Fundamentals of Database Systems". Pearson.
• Silberschatz, A., Korth, H., & Sudarshan, S. (2020). "Database System Concepts". McGraw-Hill.
• Connolly, T. & Begg, C. (2015). "Database Systems: A Practical Approach to Design, Implementation, and Management". Pearson.
• Ramakrishnan, R. & Gehrke, J. (2003). "Database Management Systems". McGraw-Hill.
• Gracia-Molina, H., Ullman, J., & Widom, J. (2009). "Database Systems: The Complete Book". Pearson.
• Coronel, C. & Morris, S. (2022). "Database Systems: Design, Implementation, and Management". Cengage Learning.
• Churcher, C. (2012). "Beginning Database Design: From Novice to Professional". Apress.
• Groff, J., Weinberg, P., & Oppel, A. (2010). "SQL: The Complete Reference". McGraw-Hill.
• Batra, R. (2018). "SQL Primer: An Accelerated Introduction to SQL Basics". Apress.
• Patrick, J. (2009). " SQL Fundamentals". Pearson.
• Nield, T. (2016). "Getting Started with SQL". O'Reilly.
• Simon, M. (2023). "Getting Started with SQL and Databases". Springer.
• Wilton, P. & Colby, J. (2005). "Beginning SQL". Wiley.
• Bush, J. (2020). "Learn SQL Database Programming". Packt Publishing.
• Churcher, C. (2016). "Beginning SQL Queries: From Novice to Professional". Apress.
• Allen, G. & Owens, M. (2010). "The Definitive Guide to SQLite". Apress.
• Kreibich, J. (2010). "Using SQLite". O'Reilly.
• Codd, E. (1970). "A Relational Model of Data for Large Shared Data Banks". Communications of the ACM. 13 (6), 377–87.
• Chamberlin, D. & Boyce, R. (1974). "SEQUEL: A Structured English Query Language". Proceedings of the 1974 ACM SIGFIDET Workshop on Data Description, Access and Control, 249–64.
• SQLite: http://www.sqlite.org
• Python: http://www.python.org
• Numpy: http://www.numpy.org
• Pandas: http://pandas.pydata.org
• Matplotlib: http://www. matplotlib.org
• Seaborn: http://seaborn.pydata.org
• SciPy: http://scipy.org
• NLTK: http://www.nltk.org
• SK Learn: http://scikit-learn.org