Project Overview

As part of the Introduction to Relational Databases course (CPSC 304) at the University of British Columbia, I participated in a group project to develop a Database Management System (DBMS) for a Reddit-styled social media platform. This project focused on providing comprehensive database management for an application with various features, including user interactions, communities, awards, and admin functionalities.

Development Process

The initial phase of the project involved creating an Entity-Relationship (ER) diagram to outline the database structure. The ER diagram, which laid the foundation for our database design, is illustrated below:

This is an example of what a projection query on users looks like with some test data:

Technical Implementation

We built the project using the Oracle database with SQL*Plus and implemented it in Java, utilizing JDBC for database access. Key features of our application included:

• - Development of an intuitive Java Swing interface for seamless database interactions and real-time data visualization.
• - Utilization of advanced SQL features like nested statements, division, and aggregation using group-by and having clauses.
• - Effective integration of the ER diagram into the application to ensure robust database integrity.

Future Enhancements

Moving forward, the next steps for this project include refining the user interface and enhancing the flexibility of the database queries to make them more customizable.