Report CrossWords System Document ... - GoogleCode

ohiofulvousSoftware and s/w Development

Aug 15, 2012 (4 years and 8 months ago)

348 views

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
1

<Ver 1.0>
3/15/2013





FPT
-
APTECH COMPUTER EDUC
ATION





eProject Document



[Cross Words]


Group
6







Group Member

-
Name:
Do Hong Quan

(Leader)


Rollno: A04508


Eproject_Code :5498

-
Name:
Vu Manh Hao


Rollno : A04312


Eproject_Code: 5485

-
Name:
Hoang Phuc Thinh


Rollno: A04516


Eproject_Code :5442

-
Name:
Hoang Ai Viet


Rollno : A04521


Eproject_Code: 5585

Instructor

Vu Tran Lam

Batch

C0907I

Semester

2



Ha Noi

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
2

<Ver 1.0>
3/15/2013















TABLE OF CONTENTS





I.

SYNOPSIS

II.

PROBLEM DEFINITION
.


III.

CUSTOMER REQUIRIMENT
SPECIFICATION (CRS)
.

IV.

ARCHITECTURE & DESIGN OF THE PROJECT.

V.


DATA FLOW DIAGRAM

VI.

ENTITY RELATIONSHIP (ER) DIAGRAM.

VII.

DATABASE DESIGN / TRUCTURE.

VIII.

TASK SHEET.

IX.

CHECKLIST OF VALIDATIONS.

X.

SUBMISSION CHECKLIST.















FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
3

<Ver 1.0>
3/15/2013



CROSS WORDS

______
***_______




INTRODUCTION



Our client, Mr. Luther is the owner of a website “Luther.com”. He is a mathematician by
profession. He is working in one of the famous institutions situated at a location near by his
residence. He generally uses this website for the purpose
of displaying his work, or he conducts
some exercise, and as well some of the ad words he has subscribed for. He also conducts various
quiz related to mathematics for the sake of entertainment to the users of the website. This quiz
can be attempted by any
of the users who generally visit his website.


Recently he has visited a site, in which he came across a puzzle called “Cross Words”. And he
felt it interesting. And thought it would be better if this can be implemented in his website. So he
has approached

us, so that we can help him by developing a desktop application for conducting
this puzzle, so that he can upload it on his site, so that the users can play this puzzl
e.


ACKNOWNLEDGEMENTS


We

would like to acknowledge all those who have given moral support and helped me make
the project a success.

We

wish to express my gratitude to the eProject Team at the Head Office, who guided and
helped me.
We

would also like to express my gratitude to my teacher.
His name’s Vu Tran Lam
.
He was guided and helped me so much during process project.

And finally,

We

would like to offer many thanks to my friend for their valuable
suggestions and constr
uctive feedback
.








FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
4

<Ver 1.0>
3/15/2013



I. SYNOPSIS:


The application is to be developed for the Windows platform using Java SE
6.0,Netbeans 5.5 and Microsoft SQL Server 2005 as the back
-
end.

The application should perform the following functions:



Play Puzzles Game



Manag
er Puzzles.



Manager Players



Record Scores


1. The main function of the system




1
.1 Adminis
tractor

a system
.



1
.2

Manager Puzzles



1.3

Manager Players



1
.
4

Search



1.5 About Software





2. Details of main function


1
-

Administractor

a system:


1.1
Login system:




Purpose:





Allow use
r

declare
identification

to used program.




Object use
d
:





Administrato
r




Function
al

request:

Allow
admin

insert

username and password and validate
information.

The program will

be

display error if username or password is
invalid.

Function to remember the username and password to access
.

Function forgot password
.

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
5

<Ver 1.0>
3/15/2013


1.2
User
s


management:




Purpose:

Allows users to manage information system
.




Object use
d
:





System manager.




Function
al

request:

The program allows users to add
,
edit
,

deleted
,

searched


and

listed
puzzle

in system.

Execute condition:

User

has to login system.


1.3

Change password

of

Admin
:




Purpose:





Allow users to change their password.




Object use
d
:





Admin
istractor




Function
al

request:

The program allow user to change password.

The program will error if your username and password old invalid
.




Execute condition:





User has to login system.


2
-

Manager Puzzles
:


2.1 Add new Puzzle




Purpose:




This function allows
admin

to

add new puzzle


into system.




Object use
d
:





Admin




Function
al

request:


The system allow
admin

to
add new puzzle






Allow admin add
order (about information puzzle)







-

Add Questions







-

Add Answers







-

Add Size







-

Add Subject

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
6

<Ver 1.0>
3/15/2013



Execute condition:




Admin must login
.


2.2
Delete a
Puzzle
:





Purpose:




This function allows
admin

to

delete a puzzle


in system.




Object use
d
:





Admin




Function
al

request:


The system allow
admin

to
delete a puzzle

.

You can also select multiple puzzles and remove the puzzle you have
chosen

Execute condition:




Admin must login
.



2.3
Edit

a
puzzle






Purpose:




This function allows
admin

to

edit a puzzle


in system.




Object use
d
:





Admin




Function
al

request:


The system allow
admin

to
edit a puzzle.

Execute condition:




Admin must login
.






2.4


View information puzzle.






Purpose:

Allow
admin print report




Object use
d
:





Admin




Function
al

request:


FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
7

<Ver 1.0>
3/15/2013



List of puzzles.


When choos
ing
detailed puzzle will show:

-

Display i
nfor
mations about the Subject.

-

Display i
nfor
mations the number of column.

-

Display i
nfor
mations the number of row.

-

Display i
nfor
mations the number of question .

-

Display i
nfor
mations the number of answer.







Execute condition:




Admin must login
.


3
-

Manager Players


3.1

Delete a
player
:





Purpose:


This function allows admin to delete a
player

in system.




Object used:





Admin




Functional request:


The system allow admin to delete a
player

.

Execute condition:


Admin must login.


3
.
2

View player



Purpose:


This function allows admin view a
player

in system
.



Object used:




Admin



Function
al request:


+

The function

provides information on player

include:

+


Information on indivi
dual (name, age, address, ...)

Execute condition:


Admin must login.

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
8

<Ver 1.0>
3/15/2013


4
-

Search




Purpose:

Allow
userd

search
puzzle



Object used:




Admin




Functional request:



The system allow admin
and user search for
puzzles

by:

-

The
Subject

-

The
size (colum or row)




Execute condition:




Admin must login.



5
-

About Software





Functional request:


Information about members of the team that developed the


software






















FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
9

<Ver 1.0>
3/15/2013



II.
PROBLEM DEFINITION :


After reading the title of this Project, we start to analysis and u
know

problem of the
Project.

1. How
to

play the crossword puzzles?

You need to use the internet to access the website luther.com where you find our
crosswords.

2. How
to

manage

add more puzzle?

Administrator has to login the network by lawful account with the easy use
interface so Administrato
r can easily find the puzzle and add more puzzles,
questions, answers for puzzles.

3. How
to

see

name of people who play the game with the highest score?

The Administrator login
to M
anagement and chose the management sector
about player to see Player list.



III. CUSTOMER REQUIRIMENT SPECIFICATION (CRS)


1.

Client: player

2.

Business / Project Objective


Create the database for the Administrator. Add tables to store information about
name, gender, birthday, Secret question and answer, permission, active status.

Create forms to add new, edit the information of user.

Display the list of user as requested.


User Administrator:



Add new user in the database.



Edit information of user.



Remove user from database.

User Puzzle Manager:



Change personal information.



Create n
ew puzzle



Edit puzzle



Display the list of player



Search:



Basic search.



Advanced search option.





FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
10

<Ver 1.0>
3/15/2013




3.

Data

provided by the Client


o

Inserts to the application



Player information : Name Player



Fisness programs information : size of the puzzle

o

Show from the
application



Puzzle information : interface of the puzzle.



Player information : Name Player,Total time.



4.

Hardware / Software Requirements


The application is to be developed for Windows platform using Java SE
6.0,NetBeans 6.8,and SQL Server 2005.



4.1

Hardware



A

m
ini
m
u
m

c
o
m
pu
t
e

s
y
st
em

th
at

wil
l

h
e
l
p

y
o
u

acc
e
s
s

a
l
l

th
e

t
oo
l
s

i
n

t
h
e c
o
u
r
s
e
s

i
s

a

P
e
n
t
i
u
m
1
G
h
z

o
r a
hi
g
h
er c
a
p
a
b
il
it
y

CPU



5
1
2

M
b

of
R
am

or
h
i
g
h
er



1
G
b

o
f free

h
a
r
d

d
i
s
k

o
r
h
i
g
h
er



M
o
n
i
t
o
r
1
7

o
r
s
u
ppo
rt

r
e
s
o
l
ut
i
o
n

1
0
2
4*
7
6
8

or

h
ig
h
er.



Windows
2000 Server (or higher if possible)

4.2
Software



Java SE 6.0



Net beans 6.5



SQL Serve 2005



MS
SQ
L

Server

2
00
5

JDBC

D
r
i
v
er

1
.
2














FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
11

<Ver 1.0>
3/15/2013


IV.
ARCHITECTURE
&

DESIGN OF THE PROJECT.



































FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
12

<Ver 1.0>
3/15/2013


V.
DATA FLOW DIAGRAM
:


1. Flow chart for

Login:



Vaild
Invaild
Yes
No
Start
Input UserName
and Password
Check UserName
and Password
Manager
End
Yes or
NO


Figure: Flow chart for Login





FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
13

<Ver 1.0>
3/15/2013


2.Flow chart for Add



Begin
Vaild
Invalid
Yes
No
Start
Insert Data
(
Questions
,
Size
,
Answers
,
Subject
)
Check Data
(
Questions
,
Size
,
Answers
,
Subject
)
Save Puzzle in to
Database
End
Yes
or
No
?


Figure: Flow chart for Add







FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
14

<Ver 1.0>
3/15/2013



3.

Flow chart for

Delete Puzzle



Yes
No
Start
Choose Puzzle
Confirm to Delete
Save To Database
End


Figure: Flow chart for Delete







FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
15

<Ver 1.0>
3/15/2013


4.
Flow chart for

Seach Puzzle



Valid
Invalid
Yes
No
Start
Insert Data
(
Subject
,
Size
)
Check data
Displays
Data
End
Yes
Or
No


Figure: Flow chart for Seach









FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
16

<Ver 1.0>
3/15/2013


VI .

ENTITY RELATIONSHIP (ER) DIAGRAM


























RDBMS

D
iagram





FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
17

<Ver 1.0>
3/15/2013


VII.

DATABASE DESIGN/STRUCTURE



Table Design:


Admi
n

Field Name

Data Type

Null

Key

Description

IDAdmin

Int

No

Primary Key


UserName

Nv
archar(
50
)

No



Pass

Varchar(
20
)

No


Password of User

Email

Nvarchar(50)

No



Phone

Int

No



Secretque
s
tion

Nvarchar(200)

No



Answer

Nvarchar(200)

No



FullName

Nvarchar(50)

No



Address

Nvarchar(50)

No



Active

Bit

No



Permission

Nvarchar (50)

No



Permission of staff





Player

Field Name

Data Type

Null

Key

Description

IDPlayer

Int

No

Primary Key


IDpuzz

Int

No

Foreign Key


Name

Varchar(
20
)

No



Totaltime

Int

No



Date

Datetime

No






FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
18

<Ver 1.0>
3/15/2013


Puzz

Field Name

Data Type

Null

Key

Description

IDPuzz

Int

No

Primary Key


Subject

Nvarchar(50)

No



Subject of puzz

IDsize

Int

No

Foreign Key




Subject

Field Name

Data Type

Null

Key

Description

S_ID

Int

No

Primary Key


S_name

Nvarchar(100)

No








Question

Field Name

Data Type

Null

Key

Description

IDquest

Int

No

Primary Key


IDPuzz

Int

No

Foreign Key


Question

Nvarchar(max)

No



Answer

Nvarchar(50)

No



PositionY

Int

No


Position Y of start
answer

PositionX

Int

No


Position X of start
answer

Countchar

Nvarchar(50)

No



Oriented

Int

No


1 is
horizontal

2 is vartical




FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
19

<Ver 1.0>
3/15/2013



Size

Field Name

Data Type

Null

Key

Description

IDSize

Int

No

Primary Key


Sizename

Nvarchar(50)

No


4x4 or 6x6 or ………

C潵湴

f湴n

乯N


乵浢N爠潦⁣牯獳r潲搠

eac栠摩he湳楯n































FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
20

<Ver 1.0>
3/15/2013


VIII . TASK SHEET




















Project Ref. No.:



Project
Title:

Activity Plan
Prerared By:

Date of Preparation of Activity Plan:


Sr.No

Task

Actual
Start Date

Actual
Days

T e a m

Me mb e r

Names

Status


1


Cross
Words





Complet
ing

2






Complet
ing

3






Complet
ing

4






Complet
ing

5






Complet
ing

6






Complet
ing

7






Complet
ing

8






Complet
ing

9






Complet
ing

10






Complet
ing

11






Complet
ing

12






Complet
ing

FPT


Aptech Computer Education

eProject Document


<Group6
-
C0907I>

Page
21

<Ver 1.0>
3/15/2013


IX . CHECKLIST OF VALIDATIONS


Option

Validated























X . SUBMISSION CHECKLIST


Sr.No

Particulars

Yes

No

NA

Comments