Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
COMP 1406A Assignment 3: Introduction to GUI’s
Commonwealth Games
The Commonwealth Games are a series of sporting events held every 4 years, which host competitors from a body of 72 member nations and territories, including Australia. The 2022 Commonwealth games have just ended, and the organisers are looking ahead towards the 2026 Games, which are to be held here in Victoria.
Your team is going to be helping to create the technical infrastructure for recording the athletes, events, and results of the games. As part of this, you’ll be creating a MySQL database to store this information. The following specifications have been provided to you to assist in your design. The team also wants to store data about future games, and possibly previous ones too so that it can all be kept in the one system and accessed conveniently.
Note: Some simplifications have been made compared to the real games, in particular we do not carefully consider round-based sports (e.g. basketball), do not consider qualifier data, etc. If at any point your understanding of The Games and this specification contradict, consider this specification as authoritative.
Regions, countries, and Games
Currently, 72 member nations (countries) compete in The Games. These nations are divided into 6 fixed regions: Africa, Americas, Caribbean, Europe, Asia, and Oceania. For each member nation we should store their name, and a link to an image of their flag.
The Games are held every 4 years, and are located in one of the member nations. Each set of games has a ‘host city’ within that nation (e.g. Melbourne, Australia). Each set of games has its own ‘theme song’ for which we need to store the name (e.g. ‘This is the Moment’), as well as a music video recording (to be played at the event).
Sports, Events, and Competitors