SQL database for a fictional game events & tournaments. Includes planning, normalization, development and testing phases.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

1.2 KiB

Tournament database project

A SQL/database project work

About

This project aims to create a database model for chess and board game tournament events where multiple teams play against each other. Each team has multiple members with simple ranking system. Each event can take place either in a virtual environment (online game) or in a physical location. This database model defines necessary tables, attributes and relations for this set.

Project Technical Goals

The following list describes requirements for the project:

  • Class diagram

  • Relation diagram

  • Relation schema

  • Data dictionaries for relation & class models

  • Database normalization from 0NF to 3NF

  • Database permission policy

  • SQL query files for SELECT, INSERT, DROP, ALTER, UPDATE, DELETE and various JOIN queries

    • For testing purposes (database integrity, scalability etc.)

Sample relation model/diagram, version 0.1. Date: 09th November, 2019 (MySQL Workbench)

Sample relation model/diagram, version 0.1. Date: 09th November, 2019 (Microsoft Visio 2010)

Project members