This is a comprehensive project to design and model a large, complex relational database for an e-commerce platform, implemented in Oracle SQL using database design techniques including Entity Relationship diagrams, normalization techniques (1NF, 2NF, 3NF using Bernstein's algorithm, and BCNF), along with a GUI written in Java to present and interact with the database.
- Connect to Ryerson's network using OpenVPN
- Put secret .env file in root directory
- Run javac -cp "libs\dotenv-java-3.2.0.jar" -d bin src\GUI.java
- Run java -cp "libs\dotenv-java-3.0.0.jar;bin" GUI
- buttons are very self-explanatory
- create button creates all tables, drop button drops them
- insert inserts all dummy data
- back to welcome takes you back to the welcome screen (panel that says "welcome", on the right side of the screen)
- the run queries button runs all pre-made queries, you must press the "next" button the run the next query
- the show table names button gives a list of all table names, which is selectable
- select a table and click show table data to show all data currently in that table:
- click "delete row" to delete the first row, or click on a cell and click delete row to delete the entire row of that cell
- double click on a cell to edit it. press enter and then click "update element" to update that cell in the database
- click "delete row" to delete the first row, or click on a cell and click delete row to delete the entire row of that cell
- select a table and click "drop selected table" to drop that table
Screenshots:
