Sports Event Management System Project in VB.net with SMS Notification
This Sports Event Management System Project in VB.net with SMS Notification 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.
Sports Event Management System Project in VB.net : Entity Relationship Diagram(ERD)
Data Dictionaries
These tables below provide the entire database tables details such as FIELD NAME, DESCRIPTION, TYPE and LENGTH
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| sport_id | Sports id number | INT | 11 |
| sport_name | Name of sports | VARCHAR | 30 |
| game_type_code | game type code | VARCHAR | 30 |
| no_of_player | Sports number of player | INT | 11 |
| sport_code | Sports code | VARCHAR | 30 |
Table8:sports
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| equipment_id | Equipment id number | INT | 11 |
| equipment_name | Equipment name | VARCHAR | 30 |
| Quantity | Equipment quantity | INT | 11 |
| available_qty | Equipment available quantity | INT | 11 |
| quantity_out | Equipment quantity out | INT | 11 |
| equipment_code | Equipment code | VARCHAR | 30 |
Table9:equipments
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| facilitator_id | Facilitator id number | INT | 11 |
| facilitator_name | Name of facilitator | VARCHAR | 30 |
| facilitator gender | Gender of facilitator | VARCHAR | 30 |
| facilitator_address | Address of facilitator | TEXT | |
| facilitator_contact | Contact number of facilitator | VARCHAR | 30 |
| facilitator_type | Type of facilitator | VARCHAR | 30 |
| facilitator_status | Status of facilitator | VARCHAR | 30 |
| facilitator_code | Facilitator code | VARCHAR | 30 |
Table10: facilitator
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| player_id | Player id number | INT | 11 |
| player_name | Name of the player | VARCHAR | 30 |
| player_age | Age of the player | INT | 11 |
| player_course | Course of the player | VARCHAR | 30 |
| player_address | Address of the player | TEXT | |
| player_gender | Gender of the player | VARCHAR | 30 |
| school_code | Code of school | VARCHAR | 30 |
| coach_code | Code of coach | VARCHAR | 30 |
| sport_code | Code of sports | VARCHAR | 30 |
| Contact | Contact number of the player | VARCHAR | 30 |
| player_code | Code of the player | VARCHAR | 30 |
Table11: players
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| referee_id | Referee id number | INT | 11 |
| sport_code | Code of sports | VARCHAR | 30 |
| referee_name | Name of the referee | VARCHAR | 30 |
| referee_gender | Gender of the referee | VARCHAR | 30 |
| referee_address | Address of the referee | TEXT | |
| referee_contact | Contact number of the referee | VARCHAR | 30 |
| referee_code | Code of the referee | VARCHAR | 30 |
| referee_status | Status of the referee | VARCHAR | 30 |
Table12: referee
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| coach_id | coach id number | INT | 11 |
| coach_name | Name of the coach | VARCHAR | 30 |
| coach_contact | Contact number of the coach | VARCHAR | 30 |
| coach_address | Address of the coach | TEXT | |
| school_code | Code of school | VARCHAR | 30 |
| coach_code | Code of the coach | VARCHAR | 30 |
Table13: coaches
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| school_id | school id number | INT | 11 |
| school_name | Name of the school | VARCHAR | 30 |
| school_address | Address of the school | TEXT | |
| school_code | Code of the school | VARCHAR | 30 |
Table14: schools
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| game_type_id | school id number | INT | 11 |
| type_of_game | Name of the school | VARCHAR | 30 |
| game_type_code | Address of the school | VARCHAR | 30 |
Table15: game_type
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| team_playerA_id | Team or player A id number | INT | 11 |
| team_playerA_name | Team or player A name | VARCHAR | 30 |
| sport_code | Code of the sport | TEXT | |
| player_code | Code of the player | VARCHAR | 30 |
| coach_code | Code of the coach | VARCHAR | 30 |
| school_code | Code of the school | VARCHAR | 30 |
| school_name | Name of the school | VARCHAR | 30 |
| Status | Status of team or player A | VARCHAR | 30 |
| team_playerA_code | Code of team or player A | VARCHAR | 30 |
Table16: team_player_a
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| team_playerB_id | Team or player B id number | INT | 11 |
| team_playerB_name | Team or player B name | VARCHAR | 30 |
| sport_code | Code of the sport | TEXT | |
| player_code | Code of the player | VARCHAR | 30 |
| coach_code | Code of the coach | VARCHAR | 30 |
| school_code | Code of the school | VARCHAR | 30 |
| school_name | Name of the school | VARCHAR | 30 |
| Status | Status of team or player B | VARCHAR | 30 |
| team_playerB_code | Code of team or player B | VARCHAR | 30 |
Table17: team_player_b
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| match_id | Game match id number | INT | 11 |
| Team_playerA_code | Code of team or player A | VARCHAR | 30 |
| Team_playerB_code | Code of team or player B | VARCHAR | 30 |
| Sport_code | Code of the sport | VARCHAR | 30 |
| referee_code | Code of the referee | VARCHAR | 30 |
| equipment_code | Code of the equipment | VARCHAR | 30 |
| Facilitator_code | Code of the facilitator | VARCHAR | 30 |
| Venue_code | Code of the venue | VARCHAR | 30 |
| Match_date | Date of the game match | TEXT | |
| Match_time | Time of the game match | TEXT | |
| Match_status | Status of the game match | VARCHAR | 30 |
| Match_code | Code of the game match | VARCHAR | 30 |
| school_year | Game match school year | VARCHAR | 30 |
Table18: match_schedule
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| game_result_id | Result of the game id number | INT | 11 |
| match_code | Code of the game match | VARCHAR | 30 |
| sport_code | Code of the sport | VARCHAR | 30 |
| Winner | Result of the game winner | VARCHAR | 30 |
| Losser | Result of the game losser | VARCHAR | 30 |
| facilitator_code | Code of the facilitator | VARCHAR | 30 |
| referee_code | Code of the referee | VARCHAR | 30 |
| venue_code | Code of the venue | VARCHAR | 30 |
| Game_result_code | Code of the game result | VARCHAR | 30 |
Table19: game_result
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| venue_id | Venue id number | INT | 11 |
| Place | Place of the venue | VARCHAR | 30 |
| venue_status | Status of the venue | VARCHAR | 30 |
| venue_code | Code of the venue | VARCHAR | 30 |
Table20: venue
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| winner_id | winner id number | INT | 11 |
| match_code | Code of the game match | VARCHAR | 30 |
| final_score | Winner final score | VARCHAR | 30 |
| school_code | Code of the school | VARCHAR | 30 |
| school_name | Winner name of the school | VARCHAR | 30 |
| winner_code | Code of the winner | VARCHAR | 30 |
Table21: winner
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| losser_id | Losser id number | INT | 11 |
| match_code | Code of the game match | VARCHAR | 30 |
| final_score | losser final score | VARCHAR | 30 |
| school_code | Code of the school | VARCHAR | 30 |
| school_name | name of the school of the losser | VARCHAR | 30 |
| losser_code | Code of the losser | VARCHAR | 30 |
Table22: losser
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| award_id | award id number | INT | 11 |
| school_code | Code of the school | VARCHAR | 30 |
| Total_gold | Award total gold | INT | 11 |
| Total_silver | Award total silver | INT | 11 |
| Total_bronze | Award total bronze | INT | 11 |
| award_code | Code of the award | VARCHAR | 30 |
Table23: awards
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| id | Message In id number | INT | 11 |
| SendTime | Message In send time | DATETIME | |
| RecieveTime | Message In receive time | DATETIME | |
| MessageFrom | Message In From | VARCHAR | 80 |
| MessageTo | Message In To | VARCHAR | 80 |
| SMSC | SMSC | VARCHAR | 80 |
| MessageText | Message In Text | TEXT | |
| MessageType | Message In Type | VARCHAR | 80 |
| MessageParts | Message In Parts | INT | 11 |
| MessagePDU | Message In PDU | TEXT | |
| Gateway | Message In Gateway | VARCHAR | 80 |
| UserId | Message In UserId | VARCHAR | 80 |
Table24: messagein
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| id | Message Log id number | INT | 11 |
| SendTime | Message Log send time | DATETIME | |
| RecieveTime | Message Log receive time | DATETIME | |
| StatusCode | Message Log status code | INT | 11 |
| StatusText | Message Log text status | VARCHAR | 80 |
| MessageTo | Message To | VARCHAR | 80 |
| MessageFrom | Message From | VARCHAR | 80 |
| MessageText | Message Text | TEXT | |
| MessageType | Type of message | VARCHAR | 80 |
| MessageId | Message id number | VARCHAR | 80 |
| MessageGuid | Message guid | TEXT | |
| MessageInfo | Message information | TEXT | |
| ErrorCode | Error code | VARCHAR | 80 |
| ErrorText | Error text | TEXT | |
| Gateway | Message gateway | VARCHAR | 80 |
| MessageParts | Message parts | INT | 11 |
| MessagePDU | Message PDU | TEXT | |
| Connector | Message connector | VARCHAR | 80 |
| UserId | Message UserId | VARCHAR | 80 |
| UserInfo | Message User Information | TEXT |
Table25: messagelog
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| id | Message Out id number | INT | 11 |
| MessageTo | Message To | VARCHAR | 80 |
| MessageFrom | Message From | VARCHAR | 80 |
| MessageText | Message Text | TEXT | |
| MessageType | Message Type | VARCHAR | 80 |
| MessageGuid | Message Guid | TEXT | |
| MessageInfo | Message Information | TEXT | |
| Gateway | Message Gateway | VARCHAR | 80 |
| UserId | Message User Id number | VARCHAR | 80 |
| UserInfo | Message User Information | TEXT | |
| Priority | Message Priority | INT | 11 |
| Scheduled | Message Scheduled | DATETIME | |
| ValidityPeriod | Message Validity | INT | 11 |
| IsSent | Message Is Sent | TINYINT | 1 |
| IsRead | Message Is Read | TINYINT | 1 |
Table26: messagelog
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| user_id | User id number | INT | 11 |
| name | User Name | VARCHAR | 30 |
| username | User username | VARCHAR | 30 |
| password | User password | TEXT | |
| user_type | User type | VARCHAR | 30 |
Table27: user
| FIELD NAME | DESCRIPTION | TYPE | LENGTH |
| sy_id | School Year ID number | INT | 11 |
| school_year | School year | VARCHAR | 30 |
| sy_code | School year code | VARCHAR | 30 |
Table28: school_year
Features of Sports Management System Project in VB.net
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
- How to Connect MySQL To Visual Studio 2019 | 2020 Complete
- How To Insert Image In Access Database Using VB.Net
- Difference Between Modules and Class In VB.NET With Examples
- VB.NET Tutorial for Beginners with Examples
Inquiries
If you have any questions or suggestions about this Sports Event Management System Project in VB.net with Source Code, please feel free to leave a comment below.
help with log in password
username: [email protected]
pass:123
theres so many errors when i put it in vb.net
what version you’ve using vb.net?
vb.net 2013