design an online league table for java game

Your task is to implement an online league table for a Java game. When finishing a game the player will be asked to enter his/her name. The score is then inserted into a central, web-based database. A web front will present the scores and should feature stats such as “average score by country”, “number of games played each day” etc. Note: you will be provided with the actual game and most of the website code. Your job is to: - Design the database tables - Amend an existing Java game so that it saves the scores to your database (the code for a game of Tetris will be provided, but you can use any you like) - Write the SQL for the various queries. Assignment Details: Design the database The requirements for the league table database is as follow: Basic information about players should be recorded: - The “username” should act as a primary key, and will be entered by the player after each game. If the username entered already exists in the table, we’ll assume it is the same player. If not, we’ll assume it is a new player and create a new record. - The “date joined” can simply be set to the date of the first score created for a certain username. - Likewise the country should be retrieved automatically when the first score for a certain username is created. When inserting scores the following information should be recorded: - name of the player (username) - date and time of the score - the score value itself (obviously!) - the game played (ultimately our system should be able to cater for many games, not just Tetris). You should design a Mysql database that contains at least 2 tables, and limit data duplication as much as possible. The appropriate data types and constraints should be implemented. Note: Some of the information (date, country) can be retrieved automatically from Java using the Date and System objects. Modify the game We will provide the Java class for a simple Tetris game. You will be required to make some changes so that: - the game asks for the player’s name when a game is completed - the score as well as all relevant information (see previous section) are inserted to your database. Note: we will provide you with a Java class for a simple game of Tetris, but you are welcome to use any Java game you find online, as long as you manage to run them, and as long as they are open source and free to use. Alternatively you could write your own game! Write queries You will be provided with the code for this website: [login to view URL]~in9352/scores/ The website is written in HTML, CSS and PHP, but you are not required to know these languages to complete this task. All you need to do is add SQL statements to meet the following requirements: - Main league table: display all scores in descending order (highest score first) - Top scores: display the top score for each game. - Most difficult games: display the average score for each game, in ascending order. - Champions: display the average score for each country, in descending order. - Busy day: display the number of games played daily, in descending order. Note: for some of the above you will need to manually insert dummy data to simulate players from other countries, or playing different games. This should be done via phpMyAdmin. Note 2: obviously feel free to use your HTML and CSS skills to customize your webpage, change the image and colours etc.