Sports Event Management System Project with SMS Notification Using VB.Net

0
562

Sports Event Management System Project with SMS Notification Using VB.Net

This Sports Event Management System Project with SMS Notification Using VB.Net will be a great tool to help those sports facilitators to manage their sports events.

This article may also contain downloadable Sports event Management System Project with SMS Notification Using VB.Net source code and Database Design of this project that includes sports management system erd, tables, and schemas.

The efficiency of the sports event management system project and the provision of various records of the transactions, schedules, and venues of each game were the main purposes of this study.

Especially in managing equipment, the facilitator would need a record to keep track of the facilities needed in each match that was already provided. 

Plotting of the schedules of each game is also essential to the facilitators and with the help of this system, plotting of time, venues a designation could be manageable because this system will save up records and schedules of all the activities with less consumption of time and effort.

Also, the facilitator won’t need a lot of individuals to do the facilitating because he has the basis to trace down sports/events that are played at a certain time.

He will also be informed of which venues were already used. And most importantly, this system will provide notification to the facilitator if the event is about to start so that he can inform the participating schools.

It is also convenient for them to announce the flow of events, revealing of the winners and other matters involved in the sports held because they had the records which are essential for hosting a sport and they can still keep a control out of the unexpected incidents that may occur during that events.

Entity Relationship Diagram(ERD)

Data Dictionaries

These tables below provide the entire database tables details such as FIELD NAME, DESCRIPTION, TYPE and LENGTH

FIELD NAMEDESCRIPTIONTYPELENGTH
sport_idSports id numberINT11
sport_nameName of sportsVARCHAR30
game_type_codegame type codeVARCHAR30
no_of_playerSports number of playerINT11
sport_codeSports codeVARCHAR30

Table8:sports

FIELD NAMEDESCRIPTIONTYPELENGTH
equipment_idEquipment id numberINT11
equipment_nameEquipment nameVARCHAR30
QuantityEquipment quantityINT11
available_qtyEquipment available quantityINT11
quantity_outEquipment quantity outINT11
equipment_codeEquipment codeVARCHAR30

Table9:equipments

FIELD NAMEDESCRIPTIONTYPELENGTH
facilitator_idFacilitator id numberINT11
facilitator_nameName of facilitatorVARCHAR30
facilitator genderGender of facilitatorVARCHAR30
facilitator_addressAddress of facilitatorTEXT 
facilitator_contactContact number of facilitatorVARCHAR30
facilitator_typeType of facilitatorVARCHAR30
  facilitator_status  Status of facilitator  VARCHAR  30
facilitator_codeFacilitator codeVARCHAR30

Table10: facilitator

FIELD NAMEDESCRIPTIONTYPELENGTH
player_idPlayer id numberINT11
player_nameName of the playerVARCHAR30
player_ageAge of the playerINT11
player_courseCourse of the playerVARCHAR30
player_addressAddress of the playerTEXT 
player_genderGender of the playerVARCHAR30
school_codeCode of schoolVARCHAR30
coach_codeCode of coachVARCHAR30
sport_codeCode of sportsVARCHAR30
ContactContact number of the playerVARCHAR30
player_codeCode of the playerVARCHAR30

Table11: players

FIELD NAMEDESCRIPTIONTYPELENGTH
referee_idReferee id numberINT11
sport_codeCode of sportsVARCHAR30
referee_nameName of the refereeVARCHAR30
referee_genderGender of the refereeVARCHAR30
referee_addressAddress of the refereeTEXT 
referee_contactContact number of the refereeVARCHAR30
referee_codeCode of the refereeVARCHAR30
referee_statusStatus of the refereeVARCHAR30

 Table12: referee       

FIELD NAMEDESCRIPTIONTYPELENGTH
coach_id  coach id numberINT11
coach_nameName of the coachVARCHAR30
coach_contactContact number of the coachVARCHAR30
coach_addressAddress of the coachTEXT 
school_codeCode of schoolVARCHAR30
coach_codeCode of the coachVARCHAR30

Table13: coaches

FIELD NAMEDESCRIPTIONTYPELENGTH
school_id  school id numberINT11
school_nameName of the schoolVARCHAR30
school_addressAddress of the schoolTEXT 
school_codeCode of the schoolVARCHAR30

Table14: schools

FIELD NAMEDESCRIPTIONTYPELENGTH
game_type_id  school id numberINT11
type_of_gameName of the schoolVARCHAR30
game_type_codeAddress of the schoolVARCHAR30

Table15: game_type

FIELD NAMEDESCRIPTIONTYPELENGTH
team_playerA_idTeam or player   A id numberINT11
team_playerA_nameTeam or player A nameVARCHAR30
sport_codeCode of the sportTEXT 
player_codeCode of the playerVARCHAR30
coach_codeCode of the coachVARCHAR30
school_codeCode of the schoolVARCHAR30
school_nameName of the schoolVARCHAR30
StatusStatus of team or player AVARCHAR30
team_playerA_codeCode of team or player AVARCHAR30

Table16: team_player_a

FIELD NAMEDESCRIPTIONTYPELENGTH
team_playerB_idTeam or player   B id numberINT11
team_playerB_nameTeam or player B nameVARCHAR30
sport_codeCode of the sportTEXT 
player_codeCode of the playerVARCHAR30
coach_codeCode of the coachVARCHAR30
school_codeCode of the schoolVARCHAR30
school_nameName of the schoolVARCHAR30
StatusStatus of team or player BVARCHAR30
team_playerB_codeCode of team or player BVARCHAR30

Table17: team_player_b

FIELD NAMEDESCRIPTIONTYPELENGTH
match_idGame match id numberINT11
Team_playerA_codeCode of team or player AVARCHAR30
Team_playerB_codeCode of team or player BVARCHAR30
Sport_codeCode of the sportVARCHAR30
referee_codeCode of the refereeVARCHAR30
equipment_codeCode of the equipmentVARCHAR30
Facilitator_codeCode of the facilitatorVARCHAR30
Venue_codeCode of the venueVARCHAR30
Match_dateDate of the game matchTEXT 
Match_timeTime of the game matchTEXT 
Match_statusStatus of the game matchVARCHAR30
Match_codeCode of the game matchVARCHAR30
school_yearGame match school yearVARCHAR30

Table18: match_schedule

FIELD NAMEDESCRIPTIONTYPELENGTH
game_result_idResult of the game id numberINT11
match_codeCode of the game matchVARCHAR30
sport_codeCode of the sportVARCHAR30
WinnerResult of the game winnerVARCHAR30
LosserResult of the game losserVARCHAR30
facilitator_codeCode of the facilitatorVARCHAR30
referee_codeCode of the refereeVARCHAR30
venue_codeCode of the venueVARCHAR30
Game_result_codeCode of the game resultVARCHAR30

Table19: game_result

FIELD NAMEDESCRIPTIONTYPELENGTH
venue_idVenue id numberINT11
PlacePlace of the venueVARCHAR30
venue_statusStatus of the venueVARCHAR30
venue_codeCode of the venueVARCHAR30

Table20: venue

Advertisement
FIELD NAMEDESCRIPTIONTYPELENGTH
winner_idwinner id numberINT11
match_codeCode of the game matchVARCHAR30
final_scoreWinner final scoreVARCHAR30
school_codeCode of the school VARCHAR30
school_nameWinner name of the schoolVARCHAR30
winner_codeCode of the winnerVARCHAR30

Table21: winner

FIELD NAMEDESCRIPTIONTYPELENGTH
losser_idLosser id numberINT11
match_codeCode of the game matchVARCHAR30
final_scorelosser final scoreVARCHAR30
school_codeCode of the schoolVARCHAR30
school_namename of the school of the losserVARCHAR30
losser_codeCode of the losserVARCHAR30

Table22: losser

FIELD NAMEDESCRIPTIONTYPELENGTH
award_idaward id numberINT11
school_codeCode of the schoolVARCHAR30
Total_goldAward total goldINT11
Total_silverAward total silverINT11
Total_bronzeAward total bronzeINT11
award_codeCode of the awardVARCHAR30

Table23: awards

FIELD NAMEDESCRIPTIONTYPELENGTH
idMessage In id numberINT11
SendTimeMessage In send timeDATETIME 
RecieveTimeMessage In receive timeDATETIME 
MessageFromMessage In FromVARCHAR80
MessageToMessage In ToVARCHAR80
SMSCSMSCVARCHAR80
MessageTextMessage In TextTEXT 
MessageTypeMessage In TypeVARCHAR80
MessagePartsMessage In PartsINT11
MessagePDUMessage In PDUTEXT 
GatewayMessage In GatewayVARCHAR80
UserIdMessage In UserIdVARCHAR80

Table24: messagein

FIELD NAMEDESCRIPTIONTYPELENGTH
idMessage Log id numberINT11
SendTimeMessage Log send timeDATETIME 
RecieveTimeMessage Log receive timeDATETIME 
StatusCodeMessage Log status codeINT11
StatusTextMessage Log text statusVARCHAR80
MessageToMessage ToVARCHAR80
MessageFromMessage FromVARCHAR80
MessageTextMessage TextTEXT 
MessageTypeType of messageVARCHAR80
MessageIdMessage id numberVARCHAR80
MessageGuidMessage guidTEXT 
MessageInfoMessage informationTEXT 
ErrorCodeError codeVARCHAR80
ErrorTextError textTEXT 
GatewayMessage gatewayVARCHAR80
MessagePartsMessage partsINT11
MessagePDUMessage PDUTEXT 
ConnectorMessage connectorVARCHAR80
UserIdMessage UserIdVARCHAR80
UserInfoMessage User InformationTEXT 

Table25: messagelog

FIELD NAMEDESCRIPTIONTYPELENGTH
idMessage Out id numberINT11
MessageToMessage ToVARCHAR80
MessageFromMessage FromVARCHAR80
MessageTextMessage TextTEXT 
MessageTypeMessage TypeVARCHAR80
MessageGuidMessage GuidTEXT 
MessageInfoMessage InformationTEXT 
GatewayMessage GatewayVARCHAR80
UserIdMessage User Id numberVARCHAR80
UserInfoMessage User InformationTEXT 
PriorityMessage PriorityINT11
ScheduledMessage ScheduledDATETIME 
ValidityPeriodMessage ValidityINT11
IsSentMessage Is SentTINYINT1
IsReadMessage Is ReadTINYINT1

Table26: messagelog

FIELD NAMEDESCRIPTIONTYPELENGTH
user_idUser id numberINT11
nameUser NameVARCHAR30
usernameUser usernameVARCHAR30
passwordUser passwordTEXT 
user_typeUser typeVARCHAR30

Table27: user

FIELD NAMEDESCRIPTIONTYPELENGTH
sy_idSchool Year ID numberINT11
school_yearSchool yearVARCHAR30
sy_codeSchool year codeVARCHAR30

Table28: school_year

Features of Sports Management System Project

Sports Event Management System Project Features

  • Manage Equipment

  • Sending of Information via SMS

  • Manage Participant

  • Manage Sports Information

  • Scheduling of Sports

  • Viewing of Sports Schedule

  • Receiving of SMS

Downloadable File

More Resources

Inquiries

If you have any questions or suggestions about this Sports Event Management System Project, please feel free to leave a comment below.

Looking for more source code? Type your keyword here here!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.