As a part of the Udacity Full Stack Web Developer Nanodegree programme, this project was all about designing an SQL database scheme to hold the results of games in an Swiss-system style tournament.

SQL queries had to be designed to support the rules of the Swiss-system (basically, players with a similar number of wins should play each other in the next round).

The SQL queries quickly got quite complicated, so I made use of the CREATE VIEW command to break the query into more manageable sub-queries.

For more details and to read the code, please visit the project on GitHub here.