A Project Report on Online Score System

Team Information

The administrator Can Add/Update the teams With the details and the user can view the overall information of the

• the team detail module allows the user to browser The details of the team profile and management.
• Team module allows user to browse different teams
• where only one team can be selected at a time and get the detail
• when selected on a particular team.

This module gives the detail of team such as team logo, team name, team information, team captain, address, contact no show match details

Player Details

this will come under team information which gives the basic details about the players.

• allow the user to have a glimpse of the player’s profile.
• it give the personal details of a player with their batting style, bowling style and his position in the team along with their achievements

Batting Performance

• It gives the batsman profile, statistic, and summary of his batting performance in his current and previous matches that he had played.

Bowling Performance

• It gives the bowling profile, statistics, and summary of his bowling performance in his current and previous matches that he had played.

Results

• This module gives the summary that was played.
• It also gives the overall detailed result of that particular match that was played.
• Detail such as scores scored by both the teams Over’s completed, loss of wickets.

Gallery

it shows the best captured moments, pictures, video etc… That was taken during the course of the matches.

• It will dynamic.
• Here the photo is uploaded which was clicked/recorded by the fans during the matches.
• The user cannot upload the image here due to censorship issues.
• Instead, the user is supposed to e-mail the image to admin and then admin uploads it to the website.

Administrator

The administrator is allowed to access all the services in the system. The main objective of the administrator is to add/update the summary of the matches and also to add/update the schedules of the matches.

Users/Visitors

These users will get the full access of the website but they cannot do any changes on the Online Score System website, they can enjoy the services provides by the administrator.

Data Dictionary

ADMIN

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	username	Varchar	20	Null
3.	password	Varchar	20	Null

TEAMLIST

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	team_name	Varchar	20	Null
3.	team_logo	Varchar	30	Null
4.	captain_name	Varchar	20	Null
5.	Captain_photo	Varchar	30	Null
6.	Villege	Varchar	20	Null
7.	Contact	Varchar	10	Null

PLAYERLIST

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	Player_name	Varchar	20	Null
3.	Player_photo	Varchar	30	Null
4.	taem_name	Varchar	20	Null
5.	age	int	2	Null
6.	dob	date		Null
7.	Contact	Varchar	10	Null

BATSMAN

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	match_no	Varchar	20	Null
3.	Player_name	Varchar	20	Null
4.	Team_logo	Varchar	30	Null
5.	Innings	Varchar	10	null
6.	run	Int	3	Null
7.	Ball	Int	3	null
8.	four	Int	3	Null
9.	six	Int	3	Null
10.	Wide_run	Int	3	Null
11.	No_run	Int	3	Null
12.	lage	Int	3	Null
13.	By_run	Int	3	Null
14.	St	float		Null
15.	out_detail	Varchar	30	Null
16.	Bowler_name	Varchar	20	Null
17.	Vs_team	Varchar	30	null

MATCHLIST

No	FieldsName	DataType	Size	Constraint
1.	Id	int	3	PK
2.	Team_name(a)	Varchar	20	Null
3.	Team_logo(a)	Varchar	30	Null
4.	Villege(a)	Varchar	15	null
5.	Team_name(b)	Varchar	20	Null
6.	Team_logo(b)	Varchar	30	null
7.	Villege(b)	Varchar	15	Null
8.	umpire	varchar	20	Null
9.	Tos	Varchar	10	Null
10.	Date	Date		Null

ELEVENPLAYER

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	Player_name	Varchar	20	Null
3.	Team_name	Varchar	20	Null
4.	Match_no	int	3	Null

UMPIRELIST

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	umpire_name	Varchar	20	Null
3.	villege	Varchar	20	Null
4.	contact	int	10	Null

GALLERY

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	photo	Varchar	100	Null

BOWLER_LIST

No	FieldsName	DataType	Size	Constraint
1.	id	int	3	PK
2.	Match_no	int	20	Null
3.	Team_name	Varchar	20	Null
4.	Bowler_name	Varchar	20	Null
5.	Innings	Varchar	10	Null
6.	Over	Float		Null
7.	Run	Int	3	Null
8.	Wide_run	Int	3	Null
9.	No_ballrun	Int	3	Null
10.	Wicket	Int	3	Null
11.	Run_out	int	3	Null
12.	Echonomics	Float		Null
13.	Vs_team	Varchar	20	Null
14.	Bowler_statas	Varchar	20	null

Data Flow Diagrams

Level 1

Snapshot

Live Score Page

Team Page
Schedule Page
Result Page
About Us
Admin side Snapshot

Admin Login
Add Team Page
Add Player Page
Add Match Page
Live Update Batsmanside Page
Live Update Bowler Side Page
Add Umpire Page
Gallery Page