make a league table for an online java game

Ukončen Zveřejněno Apr 25, 2015 K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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:

[url removed, login to view]~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.

Herní design HTML Java

Identifikační číslo projektu: #7554290

O projektu

2 nabídek Projekt na dálku Aktivní Jun 1, 2015

2 Freelnceři na tento projekt zveřejňují nabídky v průměru $30

kansalenator

Hi , I am having an experience of around 5+years in Java/J2ee related technologies. I am also familiar with RDBMS system like Oracle/Mysql. I have worked in companies like Cisco,fair Isaac corporation in the past. Další

$35 USD za 1 den
(2 Recenzí)
1.6
elasolova35

I have a lot of experience with sql. I think I can do this task in a fast and efficient manner. I also know about Java. I will be happy to work with you on this project.

$24 USD za 1 den
(0 Recenzí)
0.0