+1-415-670-9189
info@expertsmind.com
Develop a java networked database project
Course:- JAVA Programming
Reference No.:- EM131031584




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> JAVA Programming

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




Put your comment
 
Minimize


Ask Question & Get Answers from Experts
Browse some more (JAVA Programming) Materials
Demonstrate how the quicksort algorithm behaves. You will be implementing quicksort, but in a way that allows the program's user to visually observe how the algorithm proce
Describe the differences between black-box testing and white-box testing. Which strategy do you feel to be more useful?  Why? (Name and describe at least one type of black o
After the method is defined, the main method must repeatedly have the user enter 3 integers, call the triangleType method and display the return type. Be sure not to have an
The java program needs to create a GUI with a text field and a button, with an actionlistener. When the button is clicked, whatever text typed into the text field is stored in
Write down Java servlet which uses doGet to return markup document which provides your name, e-mail address, and mailing address along with a brief autobiography.
Write a program that calculates the minimum, maximum, average and standard deviation (s) of the exam score in a subject. The program will accepts the score and quit if negat
Bash scripting can be a very useful tool to manage Linux servers and workstations. The important components of a script include variables, keyboard input, terminal output, d
The first player claims a Poker hand (see "Hand Ranks" below for legal calls). When making a claim, a player says what all five dice are, not just the name of the hand. For