This project is a social networking system for University of Pittsburgh built with PostgresSQL and operated by an application written in Java with JDBC
Contributors: Fangzheng Guo, Zhuolun Li and Shibo Xing

Instantiated schemas and all relations with integrity contraints
Defined triggers on tables for further SQL development
Generated sample data for initial testing of the schema

Implemented SQL procedures and functions to support the JDBC methods
Improved SQL relation schemas for better performance and modularity
Implemented Java methods and classes to accomplish user's operations

Fully implemented end-user interface, combined with JDBC methods with through controller's logic
Added concurrency control to prevent dirty reads and writes of the table through postgresql transaction
Performed testing on JDBC and SQL functions and black-box testing from end-user's perspective.

First change the credentials in

In the root directory of the repository, you can run:

to start the program.

Run

to start the program.

For any question or concern, please contact [email protected], [email protected] or [email protected].