Overwatch 2 Tournament DBMS

Take Control of Your Overwatch 2 Tournaments

View Live Demo »

Table Of Contents

• About the Project
• Built With
• Getting Started
  • Prerequisites
  • Installation
• Usage
• License
• Authors
• Acknowledgements

About The Project

This is a project I made for Introduction to Databases at Oregon State University. This project involved both independent and collaborative efforts. I designed and built the website, and together with a partner, we designed the database.

Key Features:

• Manage Player Information:

  • Create, edit, and delete player profiles including their roles.
  • Automatically calculate the player's highest achieved rank.
  • Easy-to-use forms simplify data entry and updates.

• Manage Team Information:

  • Create, edit, and delete team information and assigned players.
  • Calculate the team's average rank based solely on the players' roles within the team (not their full role repertoire).
  • Effortlessly add and remove players from your teams.

• Manage Tournament Information:

  • Create, edit, and delete tournament details.
  • Manage participating teams, easily adding, viewing, and removing them from the competition.

Built With

• Next.js
• shadcn
• NEON - Serverless Postgres
• Vercel

Getting Started

To get a local copy up and running follow these simple example steps.

Prerequisites

Make sure you have the latest version of npm installed.

• npm

npm install npm@latest -g

Installation

1. Get a free Database Key at [https://neon.tech/]

2. Clone the repo

git clone https://github.com/johnklucinec/Overwatch-Tournement-SQL-Database

3. Install NPM packages

npm install

4. Enter your API in env.local. Only the first two variables are required.

DATABASE_URL=DATABASE_URL=postgresql://ExampleUser:ExampleToken@neonserver/OverwatchTournamentdb?sslmode=require
NEXT_PUBLIC_BASE_URL=http://localhost:3000
NEXT_PUBLIC_JOHN_GITHUB=https://github.com/johnklucinec
NEXT_PUBLIC_TROY_GITHUB=https://github.com/RemyTroy
NEXT_PUBLIC_WALKTHROUGH=https://youtu.be/-lLLTluAkBw
NEXT_PUBLIC_GITUHB=https://github.com/johnklucinec/Overwatch-Tournement-SQL-Database
NEXT_PUBLIC_PORTFOLIO=https://johnklucinec.github.io/github-pages/

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.

Usage

You can use the provided SQL files to create the tables and import some sample data into your own database.

ERD

SCHEMA

License

Distributed under the MIT License. See LICENSE for more information.

Authors

• John Klucinec - Comp Sci Student - John Klucinec - Designed Website and Database
• Troy Hoffman - Comp Sci Student - Troy Hoffman - Quality Assurance

Acknowledgements

• ShaanCoding
• TomDoesTech
• Oregon State University