Entities Including Primary Keys And Foreign Keys Computer Science Essay

Published:

I think that the old system is not perfect in business system. If we use the manual system, user can conflict about the process. To be improved and to be prevented the missininuous function of human action, we need to change our old system to computerized system. The computerized system is more accurate and secure than old system. If we use the new system, we can save time and no need to update the store list. So, to improve for our project, we need to change the computerized system.

1-3 LEVEL 1 (TOP LEVEL) DATA FLOW DIAGRAMS

Process descriptions

Register for a member : The registration process for the non-members who want to play in our soccer club.

Select the team : The committee elects the captain, vice-captain and player to form the team.

Local League Competition: The teams play in local league which are play in own country.

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

Set the training session : The events secretary open the session and invite the international player to lead the session. In this session, non-member also can take the session.

Dataflow descriptions

To request the member fees : When the register in soccer club, we need to look the member fees.

Send the member fees : The soccer club show the member fees when register.

Makes the member payment : The new member pay the money to activate the member.

Confirm registration : The committee sends the e-mail to confirm registration.

Add the member : When the member is confirm, the committee needs to add the new member information to the member file.

Activate the member : When the committee is finish to add, the member needs to activate.

Send the member fees : When the member requests the list of member fees, the committee needs to show from the member fees file.

Update the payment : When the member is finish in payment, the committee must add the payment.

Elect a captain and vice-captain : The committee elects the captain and vice-captain from the members.

Select the captain : In the process of choosing the captain, the committee needs to check the member list.

Confirm : The member need to confirm to do the captain and vice-captain after the committee chooses.

Register with one team in each season : The player can register in a team for each season.

Update the player : When the player joins a team, the committee updates them.

Arrangements the matches : The committee needs to record the schedule of matches.

Plays in local league and cup competition : A team requests the list of local league.

The schedule of match : When the player or team requests, the committee needs to show it.

Send the information of match : The committee displays the schedule of match or local league.

The list of player : The committee needs to show the player in each team.

Record by result : After finish to play, the committee updates the result.

Publish on the notice board : The committee shows the recently result on a public signboard.

Invite to lead the sessions : The events secretary invites the international players to lead the sessions.

Confirm : If they're sure to lead the sessions, they accept our invitations.

Send the training sessions : To advertise the sessions.

Advertise the sessions : advertise to the public.

Update : If the secretary opens the new sessions, they update in training session file.

Update the information : If the international player to lead the sessions, the secretary needs to update their information.

Confirm : The file reply after update.

Payment for international player : The events secretary needs to pay the salary for the international player.

To pay the fees for leading : The events secretary must pay the salary to the international player by monthly or session.

Send the entrance fees : The secretary send the list of session's fees to the students.

Confirm to play : the students need to reply if they're sure to play.

Make the entrance fees : If they're sure to play the sessions, they must pay the fees.

Entrance fees for new : When the new student makes the payment, the secretary updates in payment form.

Data store contents

Lady using a tablet
Lady using a tablet

Comprehensive

Writing Services

Lady Using Tablet

Plagiarism-free
Always on Time

Marked to Standard

Order Now

Member : The member file which can record the member registration form.

Member fees : The member fees file which records the member type and member fees.

Team : This file records the teams and the player who contains in the teams.

Match : In the match file that records the schedule of events and local league and cup competition.

Match result : Match result file takes the result of local league and cup competition.

Training Session : This file takes the schedule of training session.

International Player : This file records the information of international player.

Payment : The payment file records the payments of the international player and takes the entrance fees for the new students.

External entity definitions

Non-member : The people who doesn't register in this club.

Member : The people who did the register in this club and they can get chance from the club.

Player : The player is a member of this club and they can play in local league competition and also register in a team.

International Player : The people who is a foreigner and to lead the sessions in this soccer club.

TASK 2

2.1 ENTITY RELATIONSHIP DIAGRAM

2.2 ENTITY DESCRIPTIONS

Member : The member who can play in this club. There are two types of members such as social member and annual member. An annual member needs to pay the chargers per year.

Non-member : The non-members are not from this club who want to apply the member.

Player : The player is same as the member who can play as a team.

Committee : The Committee means all of the things can do in one place.

Team : The team contains many players who are the member of this club. The team can play the local league and cup competition.

Match : The match means the team and the other team are compete during a time limit.

Match Result : In the match, the team will get the score that is called the match result.

Events Secretary : To manage the training sessions, international player and payments.

International Player : The player who can play and lead the session from the abroad.

Training Session : The training session means the class to teach the way of football by the international player.

Payment : In this payment, the events secretary pays the salary of the international players. Another is the events secretary records the payment the entrance fees of the training sessions.

2.3 ATTRIBUTES FOR ALL ENTITIES INCLUDING PRIMARY AND FOREIGN KEYS

Entity Name : Committee

Primary Key : Committee name

Foreign Key : None

Attribute Name

Data Type

Size

Committee name

Text

20

Starting date

Text

20

Entity Name : Player

Primary Key : Player ID

Foreign Key : Team no.

Attribute Name

Data Type

Size

Player ID

Number

Integer

Team no.

Number

Integer

Name

Text

50

Phone no.

Number

Integer

NRC or Passport No.

Text

50

Address

Text

50

E-mail

Text

20

Entity Name : Team

Primary Key : Team no.

Foreign Key : None

Attribute Name

Data Type

Size

Team no.

Number

Integer

Team Name

Text

50

Team Member

Text

50

Captain

Text

20

Vice-captain

Text

20

Coach

Text

20

Entity Name : Member

Primary Key : Member ID

Foreign Key : Team no.

Attribute Name

Data Type

Size

Member ID

Number

Integer

Team no.

Number

Integer

Name

Text

50

Phone no.

Number

Integer

NRC or Passport No.

Text

50

Address

Text

50

E-mail

Text

20

Entity Name : Non-member

Primary Key : register no.

Foreign Key : Member ID

Attribute Name

Data Type

Size

Register no.

Number

Integer

Member ID

Number

Integer

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

Name

Text

50

Phone no.

Number

Integer

NRC or Passport No.

Text

50

Address

Text

50

E-mail

Text

20

Entity Name : International Player

Primary Key : InterID

Foreign Key : session no.

Attribute Name

Data Type

Size

Inter ID

Number

Integer

Session no.

Number

Integer

Name

Text

50

Phone no.

Number

Integer

NRC or Passport No.

Text

50

Address

Text

50

E-mail

Text

20

Entity Name : Events Secretary

Primary Key : Secretary ID

Foreign Key : None

Attribute Name

Data Type

Size

Secretary ID

Number

Integer

Name

Text

50

Phone no.

Number

Integer

NRC or Passport No.

Text

50

Address

Text

50

E-mail

Text

20

Entrance Date

Number

20

Entity Name : Payment

Primary Key : Payment no.

Foreign Key : InterID+ register no.

Attribute Name

Data Type

Size

Payment no.

Number

Integer

InterID

Number

Integer

Register no.

Number

Integer

Payment Date

Text

20

Name

Text

20

Phone

Number

Integer

Address

Text

50

E-mail

Text

20

Session

Text

50

Fees

Text

10

Entity Name : Training Sessions

Primary Key : Sessions no.

Foreign Key : InterID

Attribute Name

Data Type

Size

Sessions no.

Number

Integer

InterID

Number

Integer

Course

Text

50

Time

Text

20

Start Date

Text

20

End Date

Text

20

Duration

Number

10

Max player no.

Number

10

Entity Name : Match

Primary Key : Match no.

Foreign Key : Team no.

Attribute Name

Data Type

Size

Match no.

Number

Integer

Team no.

Number

Integer

Team Name

Text

50

Player ID

Number

Integer

Phone no.

Number

Integer

Date

Text

20

Entity Name : Match Result

Primary Key : Record no.

Foreign Key : Match no.

Attribute Name

Data Type

Size

Record no.

Number

Integer

Match no.

Number

Integer

Team Name

Text

50

Date

Text

20

Time

Text

20

Match Place

Text

30

Result

Text

20

2.4 RELATIONSHIPS DETAILS

In a committee, there are many players.

In each team, there are many players who are a member.

In each team, there are many members as a player.

In a committee, there are many players in a team.

There are a lot of matches in local league and cup competition for each team.

In a match, there is a result for each team.

There a lot of non-member who want to play in this club.

When events secretary opens a new session, a lot of non-members attend it.

If the non-members attend the session, they need to pay the entrance fees and class fees.

The events secretary are opens the new session every month. So, there are many sessions you can take.

Events Secretary opens the many sessions so there are also many international players to lead these sessions.

Each International player has a two or more sessions to teach the soccer sports.

The international player leads more sessions and the events secretary pays the salary monthly.

TASK 3

3.1 ENTITY LIFE HISTORY

TASK 4

4.1 A SET OF TABLES IDENTIFYING PRIMARY AND FOREIGN KEYS

Townsville Kicks Soccer Club

Membership Application Form

Member ID : ____________

Date : ____________

(dd/mm/yy)

Full Name : _____________________________

Address : ___________________________________________________ ________________________________________________________________

Occupation : _____________________________

D.O.B : _____________________________

E-mail : ______________________________

Telephone : ___________________ mobile : _______________________

NRC No. : _______________________________

Member Type : social member annual member

Membership fees :

Photo

Applicant's Signature

Gather Data

Member ID

Date

Full Name

Address

Occupation

D.O.B

E-mail

Telephone

NRC no.

Member Type

Membership fees

Choose a Key

Member ID

First Normal Form

Member ID

Date

Full Name

Address

Occupation

D.O.B

E-mail

Telephone

NRC no.

Member Type

Membership fees

Second Normal Form

Member ID

Date

Full Name

Address

Occupation

D.O.B

E-mail

Telephone

NRC no.

Member Type

Membership fees

Third Normal Form

Member ID

Date

Full Name

Address

Occupation

D.O.B

E-mail

Telephone

NRC no.

Member Type

Member Type

Membership fees

Optimisation

Member

Member ID

Date

Full Name

Address

Occupation

D.O.B

E-mail

Telephone

NRC no.

Member Type

Member Type

Member Type

Membership fees

Data Model

Member

Member Type

Townsville Kicks Soccer Club

Team Allocation Form

Team No. : ______________

Date : ______________

(dd/mm/yy)

Team Name : _______________________

Captain : _______________________

Vice-captain : _______________________

Coach : _______________________

Player

No.

Player ID

Name

Phone

Remark

Age:

Under 18 yrs 16 yrs 14 yrs 12yrs

________________

Team leader Signature

Gather Data

Team No.

Date

Team Name

Captain

Vice-captain

Coach

Player ID

Player Name

Player Phone

Remark

Team Age

Team leader Name

Choose a Key

Team No.

First Normal Form

Single

Team No.

Date

Team Name

Captain

Vice-captain

Coach

Team Age

Team leader Name

Repeatation

Team No.

Player ID

Player Name

Player Phone

Remark

Second Normal Form

Single

Team No.

Date

Team Name

Captain

Vice-captain

Coach

Team Age

Team leader Name

Repeatation

Team No.

Player ID

Player Name

Player Phone

Remark

Third Normal Form

Single

Team No.

Date

Team leader Name

Team Name

Team Name

Captain

Vice-captain

Coach

Team Age

Repeatation

Team No.

Player ID

Player Name

Player Phone

Remark

Optimisation

Team

Team No.

Date

Team leader Name

Team Name

Team Information

Team Name

Captain

Vice-captain

Coach

Team Age

Team's Player

Team No.

Player ID

Player Name

Player Phone

Remark

Data Model

Team

Team's Player

Team Information

Townsville Kicks Soccer Club

Match Result Record Form

Match No. : _____________

Date : _____________

(mm/dd/yy)

Team Name : ___________________________

Opponent Team Name : ___________________________

Result Record Table

Date

Result

Scored Player

Rejected Player

Time

Team

Opponent Team

Team

Opponent Team

Team

Opponent Team

Gather Data

Match No.

Date

Team Name

Opponent Team Name

Match Date

Result

Scored Player

Rejected Player

Time

Stadium

Choose a Key

Match No.

First Normal Form

Single

Match No.

Date

Team Name

Opponent Team Name

Repeatation

Match Date

Result

Scored Player

Rejected Player

Time

Stadium

Second Normal Form

Single

Match No.

Date

Team Name

Opponent Team Name

Repeatation

Match No.

Match Date

Result

Time

Stadium

Match Date

Scored Player

Rejected Player

Third Normal Form

Single

Match No.

Date

Team Name

Opponent Team Name

Repeatation

Match No.

Match Date

Result

Time

Stadium

Match Date

Scored Player

Rejected Player

Optimisation

Match

Match No.

Date

Team Name

Opponent Team Name

Match Result

Match No.

Match Date

Result

Time

Stadium

Match details

Match Date

Scored Player

Rejected Player

Data Model

Match details

Match

Match Result

Townsville Kicks Soccer Club

Payment Form for International Player

Payment No. : _____________

Date : _____________

(mm/dd/yy)

International Player

Name :_________________________

InterID : ________________________

Phone : _____________________ Mobile : ___________________

Address : __________________________________________________ __________________________________________________________________

E-mail : _________________________

Session No. : _________________________

Bonus : _________________________

Total : _________________________

Staff's Name :_______________ Player's Name: _______________

Signature : _______________ Signature : ______________

Gather Data

Payment No.

Date

International Player Name

InterID

Phone

E-mail

Address

Session No.

Bonus

Total

Staff's Name

Player's Name

Choose a key

Payment No.

First Normal Form

Payment No.

Date

International Player Name

InterID

Phone

E-mail

Address

Session No.

Bonus

Total

Staff's Name

Player's Name

Second Normal Form

Payment No.

Date

International Player Name

InterID

Phone

E-mail

Address

Session No.

Bonus

Total

Staff's Name

Player's Name

Third Normal Form

Payment No.

Date

Staff's Name

Bonus

Total

InterID

InterID

International Player Name

Phone

E-mail

Address

Session No.

Player's Name

Optimisation

Payment

Payment No.

Date

Staff's Name

Bonus

Total

InterID

International Player

InterID

International Player Name

Phone

E-mail

Address

Session No.

Player's Name

Data Model

Payment

International Player

4.2 DATA DICTIONARY

Title: Computerized System for Soccer Club

Type: Structure

Author: Htet Myat Soe

Date: 20 October 2010

No

Name

Alias

Definition

Occurrence

Picture

Notes

1.

Committee

Club

Committee= Committee Name+ Starting date

1

1

All of the things are in committee.

2.

Player

Member

Player=Player ID+ Player name+ Phone no.+ NRC or Passport No.+ E-mail+ Address

1-999

470-999

Player can't attend the training session.

3.

Team

-

Team=Team no.+ Name+ Captain+ vice-captain+ Coach

1-10

-

-

4.

Member

Player

Member= Member ID+ Member name+ Phone no.+ NRC or Passport No.+ E-mail+ Address

1-999

470-999

Member no need attend the training session.

5.

.

Non-member

Trainee or not register

Non-member= register no.+ name+ Phone no.+ NRC or Passport No.+ E-mail+ Address

1-999

470-999

Non-member can't participant the team.

6.

International player

Trainer

International player=InterID+ Name+ Phone no.+ NRC or Passport No.+ E-mail+ Address

1-999

Not associated to the team.

International Player is trained only for training session.

7.

Events Secretary

-

Events Secretary= Secretary ID+ Name+ Phone no.+ NRC or Passport No.+ E-mail+ Address+ Entrance Date

1-999

470-999

Events Secretary is responsible for the arranging the training session.

8.

Payment

Invoice

Payment= Payment no.+ Date+ Name+ Phone + Address+ E-mail+ Session+ Fees

The payment is both trainee and trainer

9.

Training Session

class

Training Session= Session no.+ Course+ Time+ Start Date+ End Date+ Duration+ Max Player no.

-

-

-

10.

Match

-

Match=Match No.+ Team Name+ Player ID+ Phone+ Date

1-200 per year

-

-

11.

Match Result

score

Match Result= Record no.+ Date+ Time+ Place+ Result

1-200 per year

-

-

Title: Soccer Club

Type: Element

Author: Htet Myat Soe

Date: 20 Oct 2010

No.

Name

Alias

Definition

Occurrence

Pictures

2.

Committee name

-

-

-

-

3.

Starting date

-

-

-

-

5.

Player ID

-

-

1-999

200-999

6.

Player Name

-

-

-

-

7.

Phone

-

-

-

-

8.

E-mail

-

-

-

-

9.

Address

-

-

-

-

10.

NRC no.

-

-

-

-

12.

Member ID

-

-

1-999

300-999

13.

Member Name

-

-

-

-

14.

Phone

-

-

-

-

15.

E-mail

-

-

-

-

16.

Address

-

-

-

-

17.

NRC no.

-

-

-

-

19.

Team no.

-

-

-

-

20.

Name

-

-

-

-

22.

Vice-captain

-

-

-

-

23.

Coach

-

-

1-50

30-50

24.

Non-member

-

-

-

-

25.

Register no.

-

-

1-999

300-999

26.

Name

-

-

-

-

27.

Phone no.

-

-

-

-

28

NRC no.

-

-

-

-

29.

E-mail

-

-

-

-

30.

Address

-

-

-

-

32.

InterID

-

-

1-999

200-999

33.

Name

-

-

-

-

34.

Phone no.

-

-

-

-

35.

NRC no.

-

-

-

-

36.

E-mail

-

-

-

-

37.

Address

-

-

-

-

39.

SecretaryID

-

-

1-20

10-20

40.

Name

-

-

-

-

41.

Phone

-

-

-

-

42.

NRC no.

-

-

-

-

43.

E-mail

-

-

-

-

44.

Address

-

-

-

-

45.

Entrance Date

-

-

-

-

Title: Soccer Club

Type: Data store

Author: Htet Myat Soe

Date: 20 Oct 2010

No.

Name

Alias

Definition

Occurrence

Notes

1

Member

Player

Store the member information

-

-

2.

Member fees

Store the member payment

-

-

3.

Team

The team's member records

-

-

4.

Match

Store the match

-

-

5.

Match result

Store the match result

-

-

6.

Training session

Store the schedule of sessions

-

-

7.

International player

Store the international player information

-

-

8.

Payment

Store the payment of the international player and entrance fees for students

Title: Soccer Club

Type: Data flow

Author: Htet Myat Soe

Date: 20 Oct 2010

No.

Name

Alias

Definition

Occurrence

Notes

1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

11.

12.

13.

14.

15.

16.

17.

18.

19.

20.

21.

22.

23.

24.

25.

26.

27.

28.

29.

30.

31.

31.

32.

To request the member fees

Send the member fees

Makes the member payment

Confirm registration

Add the member

Activate the member

Send the member fees

Update the payment

Elect a captain and vice-captain

Select the captain

Confirm

Register with one team in each season

Update the player

Arrangements the matches

Plays in local league and cup competition

The schedule of match

Send the information of match

The list of player

Record by result

Publish on the notice board

Invite to lead the sessions

Confirm

Send the training sessions

Advertise the sessions

Update

Update the information

Confirm

Payment for international player

To pay the fees for leading

Send the entrance fees

Confirm to play

Make the entrance fees

Entrance fees for new

Member

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

When the register in soccer club, we need to look the member fees.

The soccer club show the member fees when register.

The new member pay the money to activate the member.

The committee sends the e-mail to confirm registration.

When the member is confirm, the committee needs to add the new member information to the member file.

When the committee is finish to add, the member needs to activate.

When the member requests the list of member fees, the committee needs to show from the member fees file.

When the member is finish in payment, the committee must add the payment.

The committee elects the captain and vice-captain from the members.

In the process of choosing the captain, the committee needs to check the member list.

The member need to confirm to do the captain and vice-captain after the committee chooses.

The player can register in a team for each season.

When the player joins a team, the committee updates them.

The committee needs to record the schedule of matches.

A team requests the list of local league.

When the player or team requests, the committee needs to show it.

The committee displays the schedule of match or local league.

The committee needs to show the player in each team.

After finish to play, the committee updates the result.

The committee shows the recently result on a public signboard.

The events secretary invites the international players to lead the sessions.

If they're sure to lead the sessions, they accept our invitations.

To advertise the sessions.

advertise to the public.

If the secretary opens the new sessions, they update in training session file.

If the international player to lead the sessions, the secretary needs to update their information.

The file reply after update.

The events secretary needs to pay the salary for the international player.

The events secretary must pay the salary to the international player by monthly or session.

The secretary send the list of session's fees to the students.

The students need to reply if they're sure to play.

If they're sure to play the sessions, they must pay the fees.

When the new student makes the payment, the secretary updates in payment form.

TASK 5

DRAFT SCREEN DESIGN

Adding a new member

Townsville Soccer Club

Creating a new member

Date: _____________

(dd/mm/yy)

Member ID : ______________________________

Member Name : ______________________________

Address : ______________________________

Date of Birth : ______________________________

Type social member annual member

Remark : ______________________________

No.

Match No.

Opponent Team

Home or away

Stadium

Date/time

Creating a Fixture List

Townsville Soccer Club

Creating a fixture list

Date: _____________

(dd/mm/yy)

Team Name : ______________________________

Team ID : ______________________________

Coach ID : ______________________________

No.

Match No.

Opponent Team

Home or away

Stadium

Date/time

Recording a match result form

Townsville Kicks Soccer Club

Match Result Record Form

Match No. : _____________

Date : _____________

(mm/dd/yy)

Team Name : ___________________________

Opponent Team Name : ___________________________

Result Record Table

Date

Result

Scored Player

Rejected Player

Time

Team

Opponent Team

Team

Opponent Team

Team

Opponent Team

(b) PROTOTYPE

Fixture list for a team

Creating a New Member

Match Result

(c) VALIDATION RULES

For Adding a New Member Form

Control

Field Name

Condition

Messages

Save

Text boxes and combo box are not filled

"You fill at all text boxes and select combo boxes."

Member ID

If format is text,

"You must fill number format."

DOB

If format is text,

"You must fill the date/time format"

Registration Date

If format is text,

"You must fill the Date/Time format."

Expired Date

If format is text,

"You must fill the Date/Time format."

TASK 6

6.1 TRAINING PLAN

Session No.

Start Date

Duration

Time

Day

Trainer

No. of students

fees

0001

12 sept

1 month

5pm-6pm

Mon~Fri

Mr. David

30

$30

0002

25 sept

1month

4pm-5:30pm

Sat, Sun

Mr. Luis

30

$30

0003

28 sept

2weeks

4pm-5:30pm

Mon~Fri

Mr. John

20

$35

0004

1 oct

3weeks

4pm-6pm

Sat, Sun

Mr. Nelson

20

$35

0005

20 oct

3 months

4pm-5pm

Sat, Sun

Mr. Raymond

30

$60

User Guide

For Adding a New Member Form

New Button

When the user presses the New button, you must get the new form for adding new member information.

Save Button

When the user presses the Save Button, the system save the information that you filled in the database. If the information has error, the system will show for help.

Update Button

The Update Button is for repairing the member information that you saved in the database.

Delete Button

The Delete Button is used to cut the information of members from the database or grid.

Member ID

Member ID is display automatically when the member information is filled.

Member Name

You must fill the new member name. Format must Text.

Address

You must fill the new member address. Format must Text.

Phone

You must the phone number of new member. Format is Number.

E-mail

If the new member has e-mail address, must fill e-mail address. Format is Text.

DOB

User must fill your date of birth. Format is Date/Time (DD/MM/YYYY).

NRC

User must fill the NRC number of new member. Format is Text.

Member Type

User must select the type that you would like to apply for.

Fee

User must fill the fee for registration that upon the member type.

Registration Date

You must the date of registration that apply for new membership.

Expired Date

You must the date of expired that duration of membership.

For Creating Fixture List

Cancel Button

When the user presses the Cancel button, the system will reset all the informations.

Save Button

When the user presses the Save Button, the system save the information that you filled in the database. If the information has error, the system will show for help.

Update Button

The Update Button is for repairing the match result that you saved in the database.

Close Button

When the user presses the close button, the system will close the form.

Match No

The system automatic fills the number of match.

Team Name

You must fill the number of team.

Team ID

You must fill your team ID.

Coach ID

You must fill your coach ID.

Opponent Team

In opponent team field, you must type the opponent team.

Home

When you press the home button, you may reach the home page.

Stadium

In that field you should type the place when you play

Date/ Time

You must type the time and date of play.

For Match Result Form

New Button

When the user presses the New button, you must get the new form for recording match result.

Save Button

When the user presses the Save Button, the system save the information that you filled in the database. If the information has error, the system will show for help.

Update Button

The Update Button is for repairing the match result that you saved in the database.

Delete Button

The Delete Button is used to cut the match result from the database or grid.

Match No

You must fill the number of match.

Team No

You must fill the number of team.

Playing Date

You must fill the date of playing that format is Date/Time (DD/MM/YYYY).

Playing Time

You must fill the time of playing that format is Date/Time (DD/MM/YYYY).

Times of playing

You must fill the frequencies of playing of that team.

Times of win

You must fill the frequencies of win of that team.

Times of failure

You must fill the frequencies of failure of that team.

Numbers of goals

You must fill the number of goals of that team which the number is the playing goals in that match No.

TASK 7

REPORT

In Task (1), we must rely scheme and data charts Townsville kicked soccer club system. Non-members will learn about the football team and the system must show the type and term of payment. If non-members would like to make a statement, the system will take all the information about non-members and make the payment. And the system will respond, are not members of the system will accept as a member.

If the old members had expired, the system sends information to the member. And ask whether he would again or not. If a member wishes to re-member, the system will set a new record date and end date. Then the system confirms update and makes the payment. And the system is to invite international players to practice and, if an international player to confirm the training, the system makes the payment.

And in the level (1), the system processes is to apply for membership, renewal for existing members, the selection of the team role, recording the match and the creation of training. Apply for membership; renew memberships and training settings above. At this level, the system displays more detailed information about the team. The team selection role, a member will have to confirm that someone will be captain and vice captain. And in a record match, the coach will train and select a player and make education in the match.

For storage at this level, the membership fee will be retained in the members to fill board (depending on the type of member), and save information to Member States in the form of member registration will be saved to a file members. And to update the information of members will also be saved in file members. And the election of the captain and vice-captain will also be saved in file members. In this process, it is automatically updated. In the recording of the match, the match details will be stored in a match file, and match results will be saved as a result of the match. Information about international players will be saved to file an international player and all payments will be stored in the payment files.

The Task (2), we must explain what the data model or entity-relationship diagram of the system. There are many people in the diagram; football team, a member of a non-member, coach, match, match, an international player, the events secretary, player and coaching. We also need to explain the description of persons in the details and attributes for all individuals, including primary keys and foreign keys. And the relationship between the parties (one to many, one to one or many to many) and do not necessarily relations, which means that the relationship is whether that can or should (solid line will be and the dotted line will be available).

Listen

Read phonetically

In task (3), we have to explain about the entity life history (ELH) of the training session. We have to explain the how training session work with ELH.

In the task (4), we have to explain about the normalization with database design and DD (Data Dictionary). In order to do the Normalization, we have to do the six steps including 1.gather data (TNF), 2.choose a key, 3.First normal form (1NF), 4.Second normal form (2NF), 5.Third normal form (3NF), and 6.Optimization. And we have to explain the DD (data dictionary). We have to explain DD with entries for all items included in database design by using Level 1 and Level 0.

In the Task (5), we have to create and explain the prototype user interface for system and that will include screen design of the Adding new member, Creating Fixture List for the team and recording match result. The screen designs make with the VB.Net programming software and print screenshots the screen designs.

The task (6) is not an easy one because we have to explain User guide for the new system. And we have to create the outline training plan. The training plan will include who would be trained, how the sessions would be organized. And another one is the user guide for the system.

And the last task, task (7), is the professional report about my system design for the soccer club. And the assumption; what should be include and what should be done and the future plan; how to upgrade the system more and more perfect.

In problem (3), we must explain the history of life of the person (ELH) training session. We should explain how the training works with ELH.

In problem (4), we must explain the normalization of relations with the database design and the DD (Data Dictionary). To make the normalization that we need to do six steps, including data 1.gather (TNF) 2.Select the key, 3.First normal form (1NF), 4.Second normal form (2NF), 5.Third normal form (3NF), and 6.Optimization. And we have to explain, DD (Data Dictionary). We must explain to DD with entries for all items included in the database with levels 1 and 0.

The Trust (5), we must establish and explain the user interface for the prototype system, and which will include a screen designed to add new members, creating Scoreboard for the team and the result of recording the match. Screen designs make a VB.Net programming and print screenshots of the screen designs.

Problem (6) is not easy, because we have to explain, user manual for the new system. And we need to create an outline of the training plan. The curriculum will include who will be trained, as the sessions will be organized. And one more manual system.

And the last problem, the problem (7), is a professional record of my system design for a football club. And guess what should be included and what should be done and the future plan, how to update the system more and more perfect.

ASSUMPTIONS

According to our above description, we need to perform the computerized system for the soccer club with the structure of system analysis and design methodology. On the other hand, we can use the SSADM (Structured System Analysis and Design Method) implementation. In SSADM technique, we use the data flow, Context diagram, ERD, ELH and so on.

REVIEW OF WORK

In task (1), we have to draw a context diagram and data flow diagram of the Townsville kicks Soccer Club system. The non-member will enquire about the football team and the system has to show the member type and fee. If the non-member would like to make the application, the system will take all the information about the non-member and make the payment. And the system will reply the non-member that the system will accept as member.

In the Task (2), we have to explain about the data model or Entity Relationship Diagram of the system. There are many entities in the diagram; Football team, member, non-member, coach, match, match result, international player, events secretary, player and training session.

In task (3), we have to explain about the entity life history (ELH) of the training session. We have to explain the how training session work with ELH.

In the task (4), we have to explain about the normalization with database design and DD (Data Dictionary). In order to do the Normalization, we have to do the six steps including 1.gather data (TNF), 2.choose a key, 3.First normal form (1NF), 4.Second normal form (2NF), 5.Third normal form (3NF), and 6.Optimization. And we have to explain the DD (data dictionary). We have to explain DD with entries for all items included in database design by using Level 1 and Level 0.

In the Task (5), we have to create and explain the prototype user interface for system and that will include screen design of the Adding new member, Creating Fixture List for the team and recording match result. The screen designs make with the VB.Net programming software and print screenshots the screen designs.

The task (6) is not an easy one because we have to explain User guide for the new system. And we have to create the outline training plan. The training plan will include who would be trained, how the sessions would be organized. And another one is the user guide for the system.

And the last task, task (7), is the professional report about my system design for the soccer club. And the assumption; what should be include and what should be done and the future plan; how to upgrade the system more and more perfect.

ADVANTAGES AND DISADVANTAGES

Advantages

The soccer can be stored the important data about the team including members' information, training plan, fees, payment and other will be safe. And the system can reduce the paper waste, staff requirements and time consuming. The processes of the system will be done faster than the manual system. And as the data are in the computer system, we can find all the data required quickly. We can rapidly get the copies of the data and we do not need to worry about the losing data. So, by using the computerized system, we can get a lot of advantages such save time and money and reducing of staff, we can get more places in the office.

Disadvantages

There is only one most dangerous disadvantage is if the system breakdown, we can lose all the saving data and the regulation of the system can be broke down. And the other one is if we use the internet to advertise and organize, we have the danger of the hacking. Other disadvantage is that installation fees of setting up the system. We need program, and computers and internet access and giving training to the staff.