Databases Project


    This project was to create a GUI application to interact with a local database and compare different insertion methods. This was for my Database class and was worked on with a group. This project was for me to learn how SQL databases are worked with other programming languages. Our group chose to develop our application in Python for its ease of use and strong compatibles. The application first takes a login screen to get credentials and what database to reference from. Host for where your database is located, user and password for access and running queries on the database, and the schema of where the tables in the database. The database and queries are specific to a certain format of Football. There are four tables: Teams, Players, Games, and Play. Teams is the table with all the team’s properties like id, name, and city. Players holds all the Players data like name, id if what team there on, position, touchdowns, total yards, and salary. Games hold all the game data like what stadium was it played at, result of the game, attendance, and ticket revenue. The Play table holds what players played at what games.

    After logging in, you are takin to another window where you are able to maniple the database like inserting new elements into the tables, delete tables, get averages from a specified column, and show the table to see all entries. The insertion section takes in a text file with the data you what to insert into the database in a csv format which the user can type in or select from their computer files. There are also different sections for the three different insertion methods we were to test. Single insert which does a single insert for each line in the txt file, Multi insert which does a multiple insert at once, and Load Data that loads the file and inserts. We time these insertions to see how long insertions make with Single insertion take an extortionary long time compared to Multi and Load Data insertion.

Contributions:

  • Basic UI Design
  • Connecting UI to Database Queries