Creating a Database Management System with Python, which allows user to access with different roles and find the relevant museum data. It was our final project in ENSF300 course.
- Import data from Museum.SQL to the mySQL schema.
- Run pip install -r requirements.txt to have all the modules installed
- Run the main program by py main.py or double click on it.
- Great looking UI.
- On the admin panel, you could add/modify user as well as run any SQL commands/ providing path to the SQL script.
- Login/Registration or just visit as a guest.
- Insert/Modify Data as a Data-Entry User.
- GUI for showing the data to guest.
- Finished all the bonus marks.
- Administration Username: username, Password: password
- Guest NOT NEEDED
- Data Entry User Username: username, Password: password
- Registered User Please sign up using registration from the menu
- code folder: contains your main python application code
- sql scripts folder: contains all sql scripts required (database creation and initialization, sql script with query tasks in the handout, etc...)
- database design folder: EERD and relational schema
- optional data folder: has data files that you can sue to load data to your application if you use this optional implementation requirement