System Analysis And Design Soccer Club Computer Science Essay

Published:

The process of Register member means that if member request member registration form, Employee gives member registration form to that member. Then apply for playing member. If member accept for playing member, save to the member file. Accept member means that if a person applies for social member, committee from the club check member type and accept social member. And then update to the member file and then give invoice for registration. And then give a membership card to a person.

2

Renewable

The process of 'renewable' means that if member is over limited time, that member will make renew. So, that member will gives membership fees for renewable.

3

Select player for the team

The process of 'select player of the team' means that if player register in the team, captain and vice-captain select the team. And then save to the team file.

4

Lady using a tablet
Lady using a tablet

Professional

Essay Writers

Lady Using Tablet

Get your grade
or your money back

using our Essay Writing Service!

Essay Writing Service

Arrange for the match

The process of 'arrange for the Match' means that if player arranged Match by coach, player also accept match then save to the match file.

5

Record the match result

The process of 'record the match result' means that captain monitor the player results and then save to the match file.

6

Accept non-member

The process of 'accept non-member' is Non-member requests for 'training registration from event secretary. When event secretary accepts for the registration, non-member pays registration fees to the event secretary. So, event secretary save the record to the training session and non-member file.

7

Invite international player

The process of 'invite international player' is international player invite to the event secretary. So, event secretary accept it. And then pay session fees from international player. And then save the record to the payment file.

DATA FLOW DESCRIPTIONS

Check information means check the data of member file

Update means edit the information for member.

Create means add new employee.

Check team file means check team and check member type

Update means edit member type.

Read member information means to search member file

Team & Season List means to read Team & Season List in the March file

Update means to edit Team & Season List in the March file

Create no-member file means save new non-member.

Create means save new training session.

See employee File means to read employee details.

See int't player file means to read international player details

DATA STORE CONTENTS

NO.

Data Store

Description

1

Member file

to save member information detail

2

Employee File

to save employee information detail

3

Member Type File

to save member type information detail

4

Team File

to save team information detail

5

Match File

to save match information detail

6

Match Detail File

to save match and member information detail

7

Non-member file

to save non-member information detail

8

Training Session File

to save training session information detail

9

Training Session Detail File

to save training session and int'l player information detail

10

Int'l player File

to save int'l player information detail

11

Payment File

to save payment information detail

EXTERNAL ENITITY DEFINITIONS

NO.

External Entity

External Entity Description

1

Person

a new person coming to the club

2

Member

after register people that coming to the club

3

Player

a person who will play in a team in the club

4

Non-member

a person who will play in a training session in the club

5

International player

a person who will play in a training session in the club

Task 2

2- 1) ENTITY RELATIONSHIP DIAGRAM

Int'l Player

Member

Match

Match Detail

Non-Member

Member Type

Team

Player

Social

Employee

Captain

Vice-

Captain

Event-Secretary

Training Session

Payment

Training Session Detail

2-2) ENTITY DESCRIPTIONS

No

Entity Name

Entity Description

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

1.

Member

There are two members included in the soccer club. They are player and social.

2.

Member Type

A member type has many members.

3.

Match

A match has many members.

4.

Match Detail

The detail information of match.

5.

Team

A team has many members.

6.

Training Session

A training session has many international players.

7.

International Player

An international player has many training sessions.

8.

Training Session Detail

The detail information of training session

9.

Non-Member

A training session has many non-members.

10.

Employee

An employee has many training sessions. An employee manages many teams. In the employee, there are three levels included. They are captain, vice-captain and event secretary.

11.

Payment

A payment has many international players.

2- 3) ATTRIBUTES

File Design

Entity Name : Member

Primary Key: Member ID

Foreign Key: Membr TypeID, Team ID

Attribute

Data Type

Size

Comments

MemberID

Text

15

-

Member Name

Text

30

-

Member TypeID

Text

15

-

NRC

Text

20

-

Member Fees

Text

30

-

Member Type

Text

10

-

Date of Birth

Text

20

-

Gender

Text

20

-

Address

Text

20

-

Phone

Text

20

-

Email

Text

20

-

Entity Name : Member Type

Primary Key: Member Type ID

Foreign Key: None

Attribute

Data Type

Size

Comments

Member Type ID

Text

15

-

Type Name

Text

30

-

Price

Text

20

-

Entity Name : Match

Primary Key: Match ID

Foreign Key: -

Attribute

Data Type

Size

Comments

MatchID

Text

15

-

Date

Text

30

-

Time

Text

20

-

Location

Text

20

-

Entity Name : Team

Primary Key: Team ID

Foreign Key: Employee ID

Attribute

Data Type

Size

Comments

TeamID

Text

15

-

Team Name

Text

30

-

EmployeeID

Text

15

-

Entity Name : MatchDetail

Primary Key: MatchID+MemberID

Foreign Key: MembererID, TeamID, MatchID

Attribute

Data Type

Size

Comments

MatchID

Text

15

-

MemberID

Text

15

-

TeamID

Text

15

-

Result

Text

20

-

Description

Text

50

-

Entity Name : Training Session

Primary Key: Training Session No

Foreign Key: Employee ID

Attribute

Data Type

Size

Comments

Training Session No

Text

15

-

EmployeeID

Text

15

-

Date

Date

Date

-

Time

Text

15

-

Entity Name : International Player

Primary Key: International PlayerID

Foreign Key: None

Attribute

Data Type

Size

Comments

International PlayerID

Text

15

-

International Player Name

Text

15

-

Fees

Text

10

-

Entity Name : Training Session Detail

Primary Key: Training Session No + International Player ID

Foreign Key: International PlayerID, Training SessionID, Non-MemberID

Attribute

Data Type

Size

Comments

TrainingSessionID

Text

15

-

InternationalPlayerID

Text

15

-

Non_MemberID

Text

15

-

Entity Name : Non_member

Primary Key: Non_member ID

Foreign Key: -

Attribute

Data Type

Size

Comments

Lady using a tablet
Lady using a tablet

This Essay is

a Student's Work

Lady Using Tablet

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Examples of our work

Non_member ID

Text

15

-

Name

Text

30

-

Entity Name : Employee

Primary Key: EmployeeID

Foreign Key: None

Attribute

Data Type

Size

Comments

Employee ID

Text

15

-

Employee Name

Text

30

-

Position

Text

15

-

Gender

Text

6

-

NRC

Text

30

-

Address

Text

20

-

Phone

Text

20

-

Entity Name : Payment

Primary Key: Payment ID

Foreign Key: Training Session ID

Attribute

Data Type

Size

Comments

Payment ID

Text

15

-

Training Session ID

Text

15

-

Date

Date

Date

-

Price

Text

50

-

Description

Text

7

-

2- 4) OPTIONALITY AND DEGREE OF RELATIONSHIP

Related two entities

Entity Name

Relationship and Optional Description

-Member Type

-Member

-one to many relationship

-Member Type must include member many time

-Member

-Member Detail

-Match

-many to many relationship between member and match

-match detail is dummy table

- There will be many members in every match and many matches have many member.

-Employee

-Team

-Member

-Match Detail

-one to many relationship

-Employee must include team many time

-team must include member many time

-team also must include match detail

-Payment

-Training Session

-Employee

-Non-Member

-one to many relationship

- Training session can include many Non-member

-Training session must include many payment

-Employee can include many training session

-Training sessions

-Training sessions detail

-Int'l Player

-Payment

-one to many relationship

-many to many relationship

- many to many relationship between training sessions and int'l player

-Training sessions detail is dummy table

-There will be many int'l players in many training session and many training sessions has many int'l players.

-Payment can have many int'l players

Task 3

TASK 3

(3-1)ENTITY LIFE HISTORY

Task 4

4-1) A set of tables identifying primary key and foreign keys

[Member]

MemberID

Registration No

Registration Date

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

[MEMBER TYPE]

MemberID

Member TypeID

Member Fees

[TEAM]

TeamID

Name

[EMPLOYEE]

EmployeeID

Employee Name

[INT'L PLYAER]

Int'l PlayerID

Int'l Player Name

*PaymentID

[PAYMENT]

Training Session ID

PaymentID

Description

Price

[MATCH]

MatchID

Date

Time

Location

[MATCH/MEMBER]

MatchID

MemberID

*TeamID

Result

Description

[TRAINING SESSION]

Training SessionID

Date

Time

*EmployeeID

[TRAININGSESSIONID/INT'L PLAYERID]

Training SessionID

Int'l PlayerID

*Non-MemberID

[NON-MEMBER]

Non-MemberID

Non-Member Name

(1)Member Registration Form

Townsville Kicks Soccer Club

Member Registration Form

Member ID:………… Registration No:……...

Member Name: …… Registration Date:……..

NRC:………………… (dd/mm/yy)

Date Of Birth: ………

Gender: ……………..

Father Name: ………

Occupation: …………

Address: …………….

Phone: ………………

Email: ……………….

Member Type: Player/ Social

Member Fees: ……..

I. UNF

Registration No

Registration Date

MemberID

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

Member Type

Member Fees

II. Choose a key:

MemberID

III. 1 NF

MemberID

Registration No

Registration Date

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

MemberID

Member TypeID

Member Fees

IV. 2 NF

MemberID

Registration No

Registration Date

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

MemberID

Member TypeID

Member Fees

V. 3NF

MemberID

Registration No

Registration Date

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

Member TypeID

MemberID

Member Fees

VI. Optimization

[Member]

MemberID

Registration No

Registration Date

Member Name

NRC

Date Of Birth

Gender

Father Name

Occupation

Address

Phone

Email

[MEMBER TYPE]

Member TypeID

MemberID

Member Fees

VII. Data Model

(2)Team Allocation

Team Allocation Form

Team ID: …………….

Team Name: ………..

Captain Name: ………

Vice Captain Name: ...

No.

Member ID

Member Name

Position

Age

UNF

TeamID

Team Name

Captain Name

Vice Captain Name

MemberID

Member Name

Position

Age

II. Choose a key: TeamID

III. 1 NF

TeamID

Team Name

Captain Name

Vice Captain Name

TeamID

MemberID

Team Name

Member Name

Position

Age

IV. 2 NF

TeamID

Team Name

Captain Name

Vice Captain Name

TeamID

MemberID

Member Name

Position

Age

V. 3NF

TeamID

Name

Captain Name

Vice Captain Name

TeamID

MemberID

Member Name

Position

Age

VI. Optimization

[TEAM]

TeamID

Name

Captain Name

Vice Captain Name

[MEMBER]

TeamID

MemberID

Member Name

Position

Age

VII. Data Model

(3) Payment Form

Training Session Payment Form

Training Session ID: …………… Date: ……….

No.

Payment ID

Description

Price

I. UNF

Training Session ID

Date

PaymentID

Description

Price

II. Choose a key: PaymentID

III. 1 NF

Training Session ID

Date

Training Session ID

PaymentID

Description

Price

IV. 2 NF

Training Session ID

Date

Training Session ID

PaymentID

Description

Price

V. 3 NF

Training Session ID

Date

Training Session ID

PaymentID

Description

Price

VI. Optimization

[TRAINING SESSION]

Training Session ID

Date

[PAYMENT]

Training Session ID

PaymentID

Description

Price

VII. Data Model

(4) Match Form

Match Form

Match ID: …………… Date:……….

Location: …………… Time: ……….

No.

Member ID

Member Name

Team ID

Result

Description

EmployeeID

I. UNF

MatchID

Date

Time

Location

EmployeeID

MemberID

Name

TeamID

Result

Description

EmployeeID

II. Choose a key:

MatchID

III. 1 NF

MatchID

Date

Time

Location

MatchID

MemberID

TeamID

EmployeeID

Name

Result

Description

IV. 2 NF

MatchID

Date

Time

Location

MatchID

MemberID

TeamID

EmployeeID

Result

Description

MemberID

Name

V. 3NF

MatchID

Date

Time

Location

MatchID

MemberID

*TeamID

Result

Description

MemberID

Name

TeamID

Team Name

*EmployeeID

EmployeeID

EmployeeName

VI. Optimization

[MATCH]

MatchID

Date

Time

Location

[MATCH/MEMBER]

MatchID

MemberID

*TeamID

Result

Description

[MEMBER]

MemberID

Name

[TEAM]

TeamID

Teame Name

*EmployeeID

[Employee]

EmployeeID

Employee Name

VII. Data Model

(5) Training Session Form

Training Session Form

Training SessionID: …………… Date: …………..

Employee ID: ……………………. Time: …………..

Int'l Player

No.

Int'l Player ID

Int'l Player Name

Payment ID

I. UNF

Training SessionID

EmployeeID

Date

Time

Int'l PlayerID

Int'l Player Name

PaymentID

II. Choose a key:

Training SessionID

III. 1 NF

Training SessionID

EmployeeID

Date

Time

Training SessionID

Int'l PlayerID

Int'l Player Name

PaymentID

IV. 2 NF

Training SessionID

EmployeeID

Date

Time

Training SessionID

Int'l PlayerID

Int'l Player Name

PaymentID

Int'l PlayerID

Int'l Player Name

PaymentID

V. 3NF

Training SessionID

Date

Time

*EmployeeID

Training SessionID

Int'l PlayerID

EmployeeID

Employee Name

Int'l PlayerID

Int'l Player Name

*PaymentID

PaymentID

Payment Date

VI. Optimization

[TRAINING SESSION]

Training SessionID

Date

Time

*EmployeeID

[TRAINING SESSIONID/INT'L PLAYER]

Training SessionID

Int'l PlayerID

[EMPLOYEE]

EmployeeID

Employee Name

[INT'L PLYAER]

Int'l PlayerID

Int'l Player Name

*PaymentID

[PAYMENT]

PaymentID

Payment Date

(6) Non-member Form

Non-Member Form

Training SessionID: …………… Date: …………..

Time: …………..

No.

Non-Member ID

Non-Member Name

……………………………………………………………………………………………………..

I. UNF

Training SessionID

Date

Time

Non-MemberID

Non-Member Name

II. Choose a key:

Training SessionID

III. 1 NF

Training SessionID

Date

Time

Training SessionID

Non-MemberID

Non-Member Name

IV. 2 NF

Training SessionID

Date

Time

Training SessionID

Non-MemberID

Non-Member Name

V. 3F

Training SessionID

Date

Time

Training SessionID

Non-MemberID

Non-Member Name

VI. Optimization

[TRAINING SESSION]

Training SessionID

Date

Time

[NON-MEMBER]

Training SessionID

Non-MemberID

Non-Member Name

VII. Data Model

4- b) Data Dictionary

Title: Soccer Club

Type: Element

Author: Zar Yar Shi

Date:

No

Name

Allas

Definition

Occurrence

Picture

Note

1

MemberID

--

--

- 1 value for Member

Pic x-xxxxxx

Range b-000001 to b-999999

2

Member Name

--

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

--

3

NRCID

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range

x-xxxxxxxxxxxxxxxxxxxx

--

4

MemberFees

--

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

--

5

Member Type

--

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

--

6

DOB

--

--

-1 value for Member

Pic DATE/TIME

--

7

Gender

--

--

-1 value for Member

Pic xxxxxx

Range x-xxxxxx

8

Address

Location

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

--

9

Phone

--

--

-1 value for Member

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

10

Email

--

--

-1 value for Member

Pic x-xxxxxx

Range b-000001 to b-999999

--

11

Member Type No

--

-1 value for Member Type

Pic x-xxxxxx

Range b-000001 to b-999999

12

Type Name

--

-1 value for Member Type

Pic 999

Range 1-999999

--

13

Price

--

--

-1 value for Member Type

Pic 999999

Range 0-999999

--

14

PaymentID

--

--

-1 value for Member Type

Pic 999

Range 1-999999

--

15

Training SessionNo

--

--

-1 value for Training sessionID

Pic x-xxxxxx

Range b-000001 to b-999999

--

16

Date

-Start Date

--

-1 value for Training sessionID

Pic DATE/TIME

--

17

Description

--

--

-1 value for Training sessionID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

--

18

MatchID

--

--

-1 value for MatchID

Pic x-xxxxxx

Range b-000001 to b-999999

--

19

Match Time

--

-1 value for MatchID

Pic DATE/TIME

--

20

Match Date

--

--

-1 value for MatchID

Pic DATE/TIME

--

21

Match Result

1 value for MatchID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

22

Result

1 value for MatchID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

23

Location

Venue

--

-1 value for MatchID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

24

TeamID

--

--

-1 value for TeamID

Pic x-xxxxxx

Range b-000001 to b-999999

25

Team Name

--

--

-1 value for TeamID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

26

Int'l PlayerID

--

--

-1 value for Int'l PlayerID

-Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

27

Int'l Player Name

--

-1 value for Int'l PlayerID

-Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

28

PaymentID

--

--

-1 value for PaymentD

-Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

29

Non-MemberID

--

--

-1 value for Non-MemberID

-Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

30

Non-Member Name

--

--

-1 value for Non-MemberID

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

31

EmployeeID

--

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

32

Employee Name

--

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

33

Position

--

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxx

34

NRCID

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range

x-xxxxxxxxxxxxxxxxxxxx

35

Phone

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

36

Address

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

37

Email

--

-1 value for Employee

Pic xxxxxxxxxxxxxxxxxxxx

Range x-xxxxxxxxxxxxxxxxxxxxx

Title: Townsville Kicks Club

Type: Structure

Author: Zar Yar Shi

Date:

No.

Name

Allas

Definition

Occurrence

Note

1

Member

--

Member = Member ID+ Name + Fees+ NRC+DOB+TypeNo+ Addr+Phone+Email+ Gender+

--

--

2

Member Type

--

MemberType = TypeNo+TypeName+

Price

--

--

3

Match

--

MatchID= MatchID+ Date+Time+Location

--

--

4

Team

--

Team= TeamID+ Team Name+ EmployeeID

--

--

5

Match Detail

--

Match Detail=Match ID+MemberID + TeamID+Result+Desc:

--

--

6

Employee

--

EmployeeID+Name+

Position+Gender+ NRCID+Addr+Phone+

Email

--

--

7

International Player

--

International Player= Int'l Player ID +Name+ PayementID

--

--

8

Training Session

--

Training Session =Training SessionNo+ Date+Time+EmployeeID

--

9

Training Session Detail

--

Training Session Detail=Training SessionNo+Int'l PlayerID+Non-MemberID

--

10

Payment

--

Payment = Payment ID+Training SessionNo+ Date+ Description+Price

--

--

11

Non-Member

--

Non-Member=Non-MemberID+Non-Member Name

--

--

Title: Townsville Kicks Soccer Club

Type: Data store

Author: Zar Yar Shi

Date:

No.

Name

Allas

Definition

Occurrence

Note

1

Member

--

Member = Member ID+ Name + Fees+ NRC+DOB+TypeNo+ Addr+Phone+Email+ Gender+MemberTypeID

30,000 Member items to be hold. Currently 20,000

Flow in : Member addition

Flow out: Member reductions

Member enquiry

Member Type enquiry

2

Member Type

--

MemberType = TypeNo+TypeName+

Price

20,000 Member type items to be hold. Currently 10,000

Flow in : Member type additions

Flow out: Member type reductions

Member type enquiry

3

Match

--

MatchID= MatchID+ Date+Time+Location

100 match items to be hold. Currently 50

Flow in : Match additions

Flow out: Match reductions

Match enquiry

4

Team

--

Team= TeamID+ Team Name+ EmployeeID

100 team items to be hold. Currently 60

Flow in : Member additions

Flow out: Member reductions

Team enquiry

5

Match Detail

--

Match Detail=Match ID+MemberID + TeamID+Result+Desc:

3,000 items to be hold. Currently 2,000

Flow in : Match and member additions

Flow out: math reductions

Match enquiry

Member enquiry

6

Employee

--

EmployeeID+Name+

Position+Gender+ NRCID+Addr+Phone+

Email

2, 000 employee items to be hold. Currently 700

Flow in : employee additions

Flow out: employee reductions

enquiry

7

International Player

--

International Player= Int'l Player ID +Name+ PayementID

50 players items to be hold. Currently 30

Flow in : Int'l Player additions

Flow out: Int'l Player reductions

8

Training Session

--

Training Session =Training SessionNo+ Date+Time+EmployeeID

100 Training sessions items to be hold. Currently 40

Flow in :

Training session additions

Flow out: Training session

reduction

9

Training Session Detail

--

Training Session Detail=Training SessionNo+Int'l PlayerID+Non-MemberID

300 items to be hold. Currently 100

Flow in : Training sessions and

int'l player additions

Flow out: Training sessions and

int'l player additions

reductions

10

Payment

--

Payment = Payment ID+Training SessionNo+ Date+ Description+Price

30,000 payment items to be hold. Currently 20,000

Flow in : Payment additions

Flow out: Payment reductions

11

Non-Member

--

Non-Member=Non-MemberID+Non-Member Name

30,000 Non-Member items to be hold. Currently 10,000

Flow in : Non-Member additions

Flow out: Non-Member reductions

Title: Soccer Club

Type: Data flow

Author: Zar Yar Shi

Date:

No.

Name

Alias

Definition

Occurrence

Notes

1

Request Member Registration

-MemberID+ Name+ NRC+ Phone+ Email + Address+MemberType

50 per hour

Maximum 40

Minimum 10

Source : 1 Check valid member

Destination: Registration

2

Accept Member Registration

-MemberID+ Name+ NRC+ Phone+ Email + Address+Member Type

25 per hour

Maximum 40

Minimum 10

Source : 1 Check valid member

Destination : Registration

3

Apply for Playing Member

-MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

40 per hour

Maximum 30

Minimum 10

Source : 1 Check valid member

Destination : Registration

4

Apply for Social Member

-MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

40 per hour

Maximum 15

Minimum 10

Source : 1 Check valid member

Destination : Registration

4

Accept Playing Member

-MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

20 per hour

Maximum 15

Minimum 10

Source : 2 Check valid member

Destination : Accept Member

6

Accept Social Member

-MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

20 per hour

Maximum 15

Minimum 10

Source : 2 Check valid member

Destination : Accept Member

7

Pay Membership Fees

MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

60 per hour

Maximum 50

Minimum 40

Source : 2 Check valid member

Destination : Accept Member

8

Give Invoice

MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

60 per hour

Maximum 50

Minimum 40

Source : 2 Check valid member

Destination : Accept Member

9

Give Membership Card

MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

50 per hour

Maximum 35

Minimum 20

Source : 3 Check valid member

Destination : Renewable

10

Renewable Fees

MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

20 per hour

Maximum 15

Minimum 10

Source : 3Check valid member

Destination : Renewable

11

Give Receipt

MemberID+ Name+ NRC+ Phone+ Email + Address+ Member Type

20 per hour

Maximum 15

Minimum 10

Source : 3 Check valid member

Destination : Renewable

12

Register 1 Team

MemberID+ Name+ NRC+ Phone+ Email + Address+ Team+ MemberType

30 per hour

Maximum 15

Minimum 10

Source : 4 Check valid member

Destination : Select Player for the Team

13

Select the team

MemberID+ Name+ NRC+ Phone+ Email + Address+ Team+ MemberType

30 per hour

Maximum 15

Minimum 10

Source : 4 Check valid member

Destination : Select Player for the Team

14

Arrange Match

MemberID+ Team + MemberType+ Match ID

10 per hour

Maximum 10

Minimum 5

Source : 5 Check valid player

Destination : Arrange for the Match

15

Accept Match

MemberID+ Name+ NRC+ Phone+ Email + Address+ Team Type+ Match ID

20 per hour

Maximum 15

Minimum 10

Source : 5 Check valid player

Destination : Arrange for the Match

16

Monitor Result

MemberID+ Team Type+ Match ID+Match Detail

20 per hour

Maximum 15

Minimum 10

Source : 6 Check the Match Result

Destination : Record the Match Result

17

Request Registration to Training Session

Non-MemberID+ Name+Training Session+ Training Session Detail

100 per hour

Maximum 80

Minimum 70

Source : 7 Check the Non-Member

Destination : Accept Non-Member

18

Accept Registration

Non-MemberID+ Name+Training Session+ Training Session Detail

100 per hour

Maximum 70

Minimum 50

Source : 7 Check the Non-Member

Destination : Accept Non-Member

19

Pay Fees for Registration

Non-MemberID+ Name+Training Session+ Training Session Detail+ PaymentID

40 per hour

Maximum 35

Minimum 10

Source : 7 Check the Non-Member

Destination : Accept Non-Member

20

Give Receipt

Non-MemberID+ Name+Training Session+ Training Session Detail

40 per hour

Maximum 35

Minimum 10

Source : 7 Check the Non-Member

Destination : Accept Non-Member

21

Invite Int'l Players

Int'l PlayerID+Name+ Training Session+ Training Session Detail+EmployeeID

20 per hour

Maximum 15

Minimum 10

Source : 8 Check the Int'l Player

Destination : Invite Int'l Player

22

Accept Invitation

Int'l PlayerID+Name+ Training Session+ Training Session Detail+EmployeeID

20 per hour

Maximum 15

Minimum 10

Source : 8 Check the Int'l Player

Destination : Invite Int'l Player

23

Pay Fees for Session

Int'l PlayerID+Name+ Training Session+ Training Session Detail+EmployeeID+ PaymentID

20 per hour

Maximum 15

Minimum 10

Source : 8 Check the Int'l Player and Training Session

Destination : Invite Int'l Player

23

Accept Fees for Training Session

Int'l PlayerID+Name+ Training Session+ Training Session Detail+EmployeeID+ PaymentID

20 per hour

Maximum 15

Minimum 10

Source : 8 Check the Int'l Player and Training Session

Destination : Invite Int'l Player

Task 5

5- 1) Prototype - Member Registration Form

Prototype - Fixture List Form

Fixture List Form

Team No

Season

Serial No

Opponent Team

Match Date

Match Time

Venue

Description

Prototype - Match Result Form

Match Result Form

Match ID………………. Date……………

Location………………. Time……………

No

Opponent Team

TeamID

Result

Goal for/ Against

Referee

User Interface - Adding a new member

User Interface - Fixture List Form

User Interface - Match Result Form

VALIDATION RULES

Customer new Registration

No

Click

Condition

Message

1

New button

"Customer ID" is auto play.

2

Cancel button

If there is no data in the textboxes, message will display

Message ="there is not data in the textbox"

Clear all textboxes.

3

Submit button

If there is no data in the customer name.

Message=" Customer Name must have data"

If there is no data in the address

Message="Address must have data"

Save customer list.

Message="Successfully Save"

4.

Update button

If there is no data in the text boxes, message will show.

Message ="there is not data in the textbox"

Update customer information.

5.

Close button

When click close button, message will display.

Message ="Are you sure you want to close this form"

Close the form.

Fixture List Registration

No

Click

Condition

Message

1

New button

"Team ID" is auto play.

2

Cancel button

If there is no data in the textboxes, message will display

Message ="there is not data in the textbox"

Clear all textboxes.

3

Submit button

If there is no data in the Team name.

Message=" Team Name must have data"

If there is no data in the Date

Message=" Date must have data"

If there is no data in the Time

Message=" Time must have data"

Match Result Registration

No

Click

Condition

Message

1

New button

"Match ID" is auto play.

2

Cancel button

If there is no data in the textboxes, message will display

Message ="there is not data in the textbox"

Clear all textboxes.

3

Save button

Save Match.

Message="Successfully Save"

4

Update button

If there is no data in the text boxes, message will show.

Message ="there is not data in the textbox"

Update Match information.

5

Delete button

When click close button, message will display.

Message ="Are you sure you want to delete this data."

Close the form.

,

Task 6

(6-1) Training Plan

No

Description

Day 1

Day 2

Day 3

Day 4

Day 5

Day 6

Day 7

1.

Basic Computer Training

2.

Presentation of New System

3.

Training new system with staff

4.

Discussion and Review

5.

Hardware and Go Live

System analyst will give a training session and small groups would be trained for the new system.

Firstly, we explain to the user how to run the program

And then we will run the program ourselves

Then train to the user how to run the program

Re-explain if the user not understand the program

User Guide

Adding a new member

18

17

16

15

14

13

12

11

10

9

8

7

6

5

4

3

2

1

1. Show auto member ID

2. Enter member name

3. Choose gender

4. Enter DOB

5. Enter member fees

6. Enter NRD ID

7. Enter Join Date

8. Enter Expiry Date

9. Enter address

10. Enter Phone No

11. Enter Email

12. Choose Member type

13. Click new button to start fill the form and to show member ID

14. Click save button to save the data in the database

15. Click cancel button to clear all the textbox

16. Click Edit button to edit data

17. Click Delete button to delete data

18. Click Exit button to close the member registration form

Fixture List Form

6

4

5

3

2

1

1. Show auto Team ID

2. Enter season name

3. Enter data

4. Click new button to team ID

5. Click cancel button to clear the textboxes

6. Click submit button to save the team

Match Result Form

5

9

8

7

6

10

3

4

2

1

1. Show auto match ID

2. Enter Location

3. Show Date

4. Show Time

5. Click new button to match ID

6. Click save button to save the match

7. Click cancel button to clear the textboxes

8. Click delete button to delete the match

9. Click update button to edit the match

10. Enter data

Task 7

REPORT

According to the assignment, Townsville Kicks soccer club is run by an elected committee. Members of the public may apply for membership of the club, and may be playing members or simply social members. There is an annual membership fee, renewable every year. The schedule of membership fees as follows: a social member is $25, 00, a player over 18 years is $35, 00, a player between 13 and 18 years is $20, 00 and a player under 12 years is $10, 00.

There are six teams: 1st team, 2nd team, and four junior teams. The junior teams are for four specific age groups and consist of players under the age of 18 years, 16 years, 14 years and 12 years on 1st September of the current season. The committee elects a captain and vice-captain for each team every year from team and who also makes the arrangements for travelling to matches at other soccer clubs. Each player can only be registered with one team in each season.

Each team plays in one local league competition and one local cup competition and one local cup competition each season. Each league and cup competition is made up of a total of twenty teams. Clubs may only enter one team into each competition. All results of matches involving Townsville Kicks are recorded by the team captains and published on the club's notice board in the clubhouse. None of the club's team play friendly matches.

As well as team matches the club holds a number of training sessions that are open to non-members. The committee includes an Events Secretary with responsibility for organizing these open training sessions, inviting international players to lead the session, advertising the training sessions and determining and collecting the fees for such sessions. The club plays international players a fee for leading a session and those taking part have to pay an entrance fee. The Events Secretary records the fees paid to international players and total amount of money collected in entrance fees at each event.

Townsville Kicks soccer club requires a computerized system to carry out all the tasks above e.g. member and fee registration, team allocation, creating fixture lists (matches to be played), setting up training sessions and publishing results. They also require a website allowing members access to a diary of all matches and other club events including the results of matches.

DETAILS OF TASK 1- 6

We use the SSADM method according to assignment requirements. According to the assignment Task 1, firstly create a process model for the soccer club system comprising: a context diagram of the system, a statement of the aims of the system, and a data flow diagram for the system including process description, Data Flow Descriptions, data store contents, and external entity definitions.

A context diagram is to display the entire system as a single process. The external entity and process include in the context diagram. As shown in task 1, there are five external entities at the context diagram;

Person,

Non-Member,

Int'l Player,

Member, and

Player.

Person is asking and applying member registration to the soccer club and the payment process includes in the flow. Non-Member request for training sessions registration of the club and make the payment process. Int'l players are asked for invitation and when they accept it they will get payment for leading sessions. Member makes payment for renewable fees every year. Player is asked for registration 1 team to play each season. The context diagram shows the overview points of the system. The process description is the explanation of the data that include in the process. The next statement is explanation the system aim and objectives.

To setup a computerized system to efficiently supported existing system

To support fast response for customers rapidly on the web

To support accurate and efficient response for customers

To prevent human errors in calculation and data processing

To save on time and cost spent traveling

To produce complete, accurate and timely reports

Easy to understand and use for client side which they are not required much computing knowledge

The process description is the explanation of the data that include in the process. It has seven processes.

Register Member

Renewable

Select Player for the team

Arrange for the Match

Record the Match Result

Accept Non-member

Invite Int'l Players

According to the assignment Task 2, we created an entity relationship diagram for the system; entity descriptions for all entities in the diagram, appropriate attributes for all entities in the diagram, and relationships detailing optimality and degree of relationships between entities.

According to the assignment Task 3, entity life history is created for a training session.

According to the assignment Task 4, a database design is created for the soccer club system including: a set of tables identifying primary and foreign keys, and data dictionary entries for all items included in the database design.

In this task 4, we need to make the form design that will use in system. After draw form design, we need to make many steps. There are

Make UNF or Gather data

Choose the key

Converting to first normal form( 1 NF)

Converting to Second normal form( 2 NF)

Converting to third normal form( 3 NF)

Make Optimization and

Make Data Model

There are 6 forms, Member Registration form, Team Allocation form, Training Session form, Training Session Payment form, Match form, Non-Member form to make a set of full normalization tables. Element, flow, store and structure are show in data dictionary.

According to the assignment Task 5, we created a prototype user interface for the soccer club system including, as a minimum, the following functions:

adding a new member,

creating a fixture list for a team,

and recording a match result.

According to the assignment Task 6, we created system outline training plan for the new system and created a User Guide for the system.

REVIEW OF WORK And ASSUMPTIONS

This assignment is changing computerized new system from the current system of Townsville Kicks soccer club. In changing the computerized system, we need to draw DFD, ERD, ELH, Third normal form, prototype and others needed. By task 1, we need to create data flow diagram to know about the system scope. For task 2, we need to draw entity relationship diagram to show the main process of system. Task 3, we have to draw entity life history to know bed booking detail. In task 4, we have to create database design for soccer system. This includes a set of fully normalized tables and data dictionary entries of all items. For task 5, we use software to create prototype graphical user interface for search form for adding a new member, creating a fixture list for a team, and recording a match result. In this task, we have to describe about validation rules and reason for this needed. In the task 6, we have to create an outline training plan for the new system including trainers and how the sessions would be organized. Moreover we have to create a User Guide for the system. The last task 7, we have to write about details of all tasks, a discussion of assumption and weakness and improvement points and review of work.

The overall system has been achieved in general. In particular, the proposed system is cost-effective in terms of time, effort and paper-based work of the manual system. The currently running system has some limitations in data processing, controlling and reporting to the management. The data losing may occur and less security of information. Because of manual system transactions can be done weekly rather than daily transactions. In the existing system, the officers in the club can normally make enquiry by telephone and keep, gather and record the data in manually. So, there may be so many data missing and unnecessary problems. The new system can support to the staff in the soccer club and will allow them to result in giving the faster customer services. The data and information is likely to be more accurate, reliable and update.

The new system will help the users and management in performing their tasks efficiently and effectively. So, the officer can easily have the updated data and detail information and can make timely decisions. And then, the new system can easily be as the following, too:

To setup a computerized system to efficiently supported existing system

To support fast response for customers rapidly on the web

To support accurate and efficient response for customers

To prevent human errors in calculation and data processing

To save on time and cost spent traveling

To produce complete, accurate and timely reports

Easy to understand and use for client side which they are not required much computing knowledge.

Changing a computerized system for the soccer club, the system will be improved on all systems and the mistake will be minimized compare with the current system. This will release staff in soccer club to carry out their main duties and also centralize the payment of registration fees thus simplifying the association's accounting procedures. After it is finished as a perfect system, users and members can make online registration easily. And then we can make Townsville Kicks soccer club website and it can make to know about our association. There are some weaknesses for changing computerized system because virus and some other barrier can have in computer system and these can be damaged some important data easily. Moreover, data can be stolen or deleted easily if there is not secure security system. However, there are many benefits of changing computerized system for soccer club.

It is easy to search for fixture list, match results, member and non-members, training sessions. Furthermore, data can be updated easily and stored in one place. Therefore, we prefer computerized system for Townsville Kicks soccer club to manual system.

Appendix

ADVANTAGES AND DISADVANTAGES

In the payment process, the customers need to make the payment by cash. So, some of the customers may find that it is not very comfortable for them to make the payment by cash. If they live very far from the soccer club and want make the payment, it also not very comfortable for them. So, in order to solve these problems, we may need to make the online payment system. According to the scenario, the future plane of the soccer club is to create a website that allows members to register and pay fees for registration via the club the association's website. So, when the club has developed the website, we can also aggregate the online payment system to the website. We also need to use SSL (Secure Socket Layer) protocol for the security of the online payment. The new system for the club that I currently develop doesn't include the authentication and authorization methods. So everyone can access the computer systems in the office. So we need to keep username and password to prevent unauthorized users to access the system. So it will be very comfortable for the accountant to carry out the banking process.

In the proposed system, all of the information is going to keep on the computerized system. So, it is very easy to find the information of the club when the members of the public request the soccer club information. All of the information will be correctly stored in the computerized system. As the soccer club needs to keep much information, sometime it is very difficult and needs to take a long time to retrieve the soccer club information. By using the computerized system, the above disadvantages can be avoided. When it comes to make the payment, the staffs can correctly store the payment information in the system. In the manual system, the payment information can be incorrectly stored because committee needs to handle altogether about six teams. So sometimes, the information can be incorrect. In the manual system, time consuming can occur. But in the new system, all of the information is stored electrically. So it is very easy to retrieve the information and also the information is correct. The backup process can easily be done. These are the advantages and improvements of using the computerized system for the Townsville Kicks soccer club.

References