Develop a java networked database project

Assignment Help JAVA Programming
Reference no: EM131031584

Mini Project Specification

A mini project

Develop a java networked database project called myTicTacToe to have a server based database accessible by multiple users. The database should hold information on users (names, usernames, and passwords).

Anyone should be able to add him/herself as a user. Further discussions will take part in a lecture. The given TicTacToe program is a java application. You are expected to do the following:

1. Import and test the given project before you attempt to improve it.

2. Convert the program to a simple client-server program to enable two users on separate client machines play the game against each other. Listing 1 shows a sample code snippet for the server side. You do not need a GUI for the server side but you may choose to have one if you wish to. Hints: Use the source code given, add a client class, and add a server class. The source code given will be part of server side implementation. Use it as a separate class at server end but NOT as the main class since the server class should be the main class.

3. Add a database to the project. A server side database should hold user information as shown in the tables below. The specifications given are bare minimum. Enhance tables adding one or more columns of your choice (e.g. date enrolled, date played etc.)

a. Create a table called PLAYERS. This will be used to keep a record of players. Although no authentication is expected at this stage, this can later be added.

b. Create a table called RESULTS. This should hold results of games between any two players played at any time. The column Winner should take values 1, 2, or 0. The first two identifies the winner while 0 indicates a draw.

c. Note that at this stage only one game can be played (no multi-threading yet).

4. The game should start as soon as a second player becomes active.

5. Write SQL scripts as part of methods to do the following (you will need new GUI components to be added to your application):

a. Add new user.

b. Get a person's results (show the person's name, opponent's name, won/lost/drew as well as total number of points obtained). Each wins worth 1 and each draw worth 0.5. Zero for losses.

c. Produce the cumulative results (i.e. as in 5b. but for all players.)

6. Add multi-threading to your program to enable multiple sessions of the game run simultaneously.

7. Active and free users should be flagged so that a new player can find an opponent. A free user is one who started the application and waiting for an opponent.

Table 1: PLAYERS:

 

ID

Name

Surname

Username

Password

email

Type

Integer

Varchar

Varchar

Varchar

Varchar

Varchar

Size

N/A

30

30

30

30

30

Primary key?

Yes

No

No

No

No

No

Unique?

Yes

No

No

Yes

No

Yes

Null?

No

No

No

No

Yes

Yes

Foreign key?

 

 

 

 

 

 

Table 2: RESULTS

 

Game_No

Name1

Surname1

Name2

Surname2

Winner

 

Type

Integer

Varchar

Varchar

Varchar

Varchar

Integer

Size

N/A

30

30

30

30

1

Primary key?

Yes

No

No

No

No

No

Unique?

Yes

No

No

No

No

No

Null?

No

No

No

No

No

No

Foreign key?

 

 

 

 

 

 

The coursework report should contain the following sections:

- Title page - giving title, module, date and authors' details

- Introduction - a short description of the work done

- List of contents - with page numbers

- Design and development - The design and development of your program.

- Testing, results, and discussions - supported by screen shots.

- Conclusion - A short summary of the work done and your conclusions, possible improvements and enhancements

- References used - a full list of all sources used; books, journals/magazines, electronic sources

Bonus: Implement authentication so that 5 points is added to your average laboratory grade (only if functional). This may be as significant as moving you up by a class.

Attachment:- manifest.rar

Attachment:- Project Specification.pdf

Reference no: EM131031584

Physical design and implementation

In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Stor

Write a program that displays a frame window w pixels wide

Write a program that displays a frame window W pixels wide and H pixels high. Use the Scanner to enter the values for W and H. The title of the frame is also entered by the

Write a java application that prompts the user for input

Write a Java application that prompts the user for pairs of inputs of a product number (1-5), and then an integer quantity of units sold (these are two separate prompts for

Compute the area of the triangle

Compute the area of the triangle using Heron's Formula(below), in which s represents half of the perimeter of the triangle, and a,b, and c, represent the length of the three

Develop a reservation system program for specific flights.

develop a reservation system program for specific flights. A customer should be able to select from one of four categories of seats on flights from RDU to any of at least thre

Square with a rectangle of the same size

Write a Java statement to initialize a variable square with a rectangle object whose top left corner is (10, 20) and whose sides all have length 40. Then write a statement t

Web application that allows user to specify six lottery nums

Write a web application that allows a user to specify six lottery numbers. Generate your own combination on the server, and then print out both combinations together with a co

Collection of scores (type int) for the last exam i

After being given a collection of scores (type int) for the last exam in your computer course, you are to computer the average of the scores and assign grades (O, S, U i.e. Ou

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd