Art Gallery Management System

This repository contains the complete code for making an Art Gallery Management System.

• Language used for GUI: Python (using Tkinter)
• Language used for connectivity with the database: Python (using cx_Oracle)
• Database used: Oracle 21c

About the project

On running the .ipynb file, a GUI window will pop up which looks like this:

It has 5 tables in the database (2 tabs for each table - one to insert data and the other to display it) namely "exhibition", "gallery", "artist", "painting" and "customer". After inserting the data in the input fields in a tab, press the submit button. A "Record added in xyz table" message will pop up if the insertion in the database was done successfully, otherwise an error message will be printed in the ouput window on the IDE you're using.

Use the display tab to view all the entries in the respective table.

Steps to run

1. Make a new user in your database to simplify the maintenance of table data.
2. Open the galleryDB.sql file in your database* and run the commands for table creation using the newly created user.
3. Open the artGallery.ipynb file with Jupyter Notebook (preferred) or any other python IDE.
4. Edit the part where connection to the database was made using cx_Oracle** according to your username and password and run the first cell to reach the GUI screen.
5. Now you can try entering and displaying the data entered in the tables.

* This repository uses Oracle as the database. You may use any other database, but in that case, you would need to make appropriate changes in the code.

** You may need to install cx_Oracle module and other libraries/modules as well, like tkinter etc. You may check the imports at the top of the first cell in the .ipynb file and install them accordingly.

References

https://docs.python.org/3/library/tk.html
https://cx-oracle.readthedocs.io/en/latest/
https://www.oracle.com/database/technologies/appdev/python/quickstartpythononprem.html