Skip to content

This is all the code for our database systems (COS 457) course project. The system was designed to provide a management interface for volleyball coaches. It would also provide players the ability to change some personal information and get informed about current events.

Notifications You must be signed in to change notification settings

jgore077/COS-457-Course-Project

Repository files navigation

COS-457-Course-Project

Technologys Utilized

Installation

Firstly install python modules

pip install -r requirements.txt

Secondly navigate to "vbms-frontend" directory

cd ./vbms-frontend

Then install all node modules

npm i

Running

Windows

./run.ps1

Linux

./run.sh

Technical Details

The backend uses flask to create an api which interacts with database with a postGres connector called psycopg2. The backend also has a class called volleyBallData which contains many of the methods neccesary to interact with the database.

The frontend is made with React and will send requests to the backend to serve data to users.

The interface also allows users to interface with the database at a level determined by their role on the team. For example every user can change their shirt size, phone number and commuter status but not all users can edit/create games.

Data Sources

Faker Library:
Usage: Faker is a Python library used extensively in this project to create data that resembles real-world information. Data Types Generated: Personal Information: Names, emails, and phone numbers for users (players, coaches, admins). Temporal Data: Dates and times for games, practices, and announcements. Location Data: Addresses and locations for game and practice venues.
Custom Python Scripts:
Functionality: These scripts are tailored to the specific needs of the VBMS. They utilize Faker for basic data generation and add custom logic to create volleyball-specific information. Key Features: Team Data Generation: Scripts generate team names, player roles, and coach assignments. Game and Practice Schedules: Automated creation of game and practice schedules, ensuring no conflicts or unrealistic timings. Injury Reports and Transfers: Generation of realistic injury reports and player transfer data between teams.
Admin-Defined Data:
Nature: This dataset comprises manually entered data that provides a base for the VBMS. It includes information that requires domain knowledge and specificity, which cannot be effectively generated by automated scripts. Components: Team and Tournament Names: Predefined names for teams and tournaments to add authenticity to the simulated environment. Specific Event Details: Manual entry of special events, such as end-of-season galas or charity matches, that require unique descriptions and details. Tailored Announcements: Custom announcements related to team activities, achievements, or specific messages from coaches and administrators.
Database Integration:
PostgreSQL Database: The backend of VBMS is powered by a PostgreSQL database. The data generated through the above methods is formatted and structured for compatibility with this database system. Data Structuring: The structured data from various sources is organized into a format that aligns with the database schema of VBMS, ensuring seamless integration and retrieval.

Usage and Future Work

Data Integration: The CSV files are designed for easy import into the VBMS's PostgreSQL database. Testing and Simulation: Data can be used for system testing, user training, and simulating real-world scenarios in volleyball team management. Extensibility: The structured data format and comprehensive documentation make it easy to extend or modify data for future enhancements or new features in the VBMS.

About

This is all the code for our database systems (COS 457) course project. The system was designed to provide a management interface for volleyball coaches. It would also provide players the ability to change some personal information and get informed about current events.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published