Bachelor of Computer Science - May 2024
TEB1103:Data and Information Management
Project Title: E-Sport Tournament Matching
Brief Description
Our group has chosen E-Sport tournament matching as our relational database. The reason why
we chose this as our database is due to its rapidly expanding relevance especially among youths.
It is indeed a growing industry thus requiring a good data management system. With a good
database, organisations that want to host an e-sport tournament can streamline their operations
such as their scheduling for players, maintain data from previous matches and track player
performance.
List of Entities
1. Tournament
2. Team
3. Player
4. Match
5. Game
6. Round
7. Bracket
8. Venue
9. Sponsor
10. Match Statistic
11. Streaming Platform
12. Broadcast
13. Referee
14. Commentator
15. Ticket
16. Buyer
17. Match Schedule
18. Media Partner
19. Prize
20. Feedback
Relational Schema
TOURNAMENT(tour_id , tour_name, tour_date)
BRACKET(team_id, tour_id, bracket_type)
TEAM(team_id, team_country, team_name, team_ranking, tour_id, winner_id)
PLAYER(player_id, player_age, player_name, player_nationality, player_position, team_id)
FEEDBACK(feedback_id, feedback_comments, audience_id, player_id)
AUDIENCE(audience_id, audience_contact, audience_name, broadcast_id, ticket_id)
BROADCAST(broadcast_id, broadcast_channel, broadcast_team, broadcast_language,
match_id)
MATCH_SCHEDULE(match_id, broadcast_id, match_date, match_time)
MATCH(match_id, round_number , tour_id, venue_id)
SETTINGS(match_id, referee_id)
REFEREE(referee_id, referee_contact, referee_name)
VENUE(venue_id, venue_capacity, venue_facilities, venue_name)
MATCH_STATISTIC(statistics_id, match_highlight, match_result, match_statistics,
commentator_id)
COMMENTATOR_MATCH_STATISTIC(commentator_id ,statistics_id,
match_information)
COMMENTATOR(commentator_id, commentator_contact, commentator_name,
broadcast_id)
WINNER(winner_id, match_id, prize_id, winner_placement)
PRIZE(prize_id, prize_pool, prize_placement)
ROUND(round_number, round_name, tour_id)
GAME(game_id, game_developer, game_rules, tour_id)
ORGANIZER(organizer_id, organizer_contact, organizer_name, organizer_website, tour_id)
MEDIA_TEAM(media_contact, media_details, media_name, organizer_id)
STREAMING_PLATFORM(platform_url, platform_name, platform_viewcount,
media_contact)
LICENSING_FEE(platform_url, broadcast_id, licensing_amount)
TICKET(ticket_id, ticket_seatnum, ticket_purchasedate, organizer_id)
SPONSOR(sponsor_id, sponsor_contact, sponsor_level, sponsor_name, tour_id)
Data Dictionary
TOURNAMENT
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
tour_id NUMBER 6 P No Unique
number ID
for all
tournaments
tour_name VARCHAR2 60 No Full name of
tournament
tour_date DATE 10 No Date in
which the
tournament
will be held
BRACKET
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
team_id NUMBER 6 P, F No Unique
number ID
for all teams
tour_id NUMBER 6 P, F No Unique
number ID
for all
tournaments
bracket_type VARCHAR2 5 No The type of
bracket,
whether
“UPPER” or
“LOWER”
TEAM
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
team_id NUMBER 6 P No Unique
number ID
for all teams
team_countr VARCHAR2 60 No The country
y of origin of
the team
team_name VARCHAR2 40 No Full name of
the team
team_rankin VARCHAR2 5 No The ranking
g of the team
in a specific
tournament
tour_id NUMBER 6 F Yes Unique
number ID
for all
tournaments
winner_id NUMBER 6 F Yes Unique
number ID
for all
winners
PLAYER
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
player_id NUMBER 6 P No Unique
number ID
for all
players
player_age NUMBER 3 No Age of
player in
years only
player_name VARCHAR2 100 No Full name of
player
player_natio VARCHAR2 60 No Country of
nality origin of
player
player_positi VARCHAR2 20 No The specific
on role a player
is assigned
to during the
game, e.g.
“support”,
“attacker”
team_id NUMBER 6 F No Unique
number ID
for all teams
FEEDBACK
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
feedback_id NUMBER 6 P No Unique
number ID
for all
feedbacks
feedback_co VARCHAR2 300 No Feedback
mments from either
the audience
or the player
regarding
any aspects
of the
tournament
audience_id NUMBER 6 F Yes Unique
number ID
for all
audiences
player_id NUMBER 6 F Yes Unique
number ID
for all
players
AUDIENCE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
audience_id NUMBER 6 P No Unique
number ID
for all
audiences
audience_co NUMBER 15 No Contact
ntact number of
audience
audience_na VARCHAR2 60 No Full name of
me audiences
broadcast_id NUMBER 6 F Yes Unique
number ID
for all
broadcasts
BROADCAST
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
broadcast_id NUMBER 6 P No Unique
number ID
for all
broadcast_ch VARCHAR2 60 No Full name of
annel broadcast
channel
broadcast_te VARCHAR2 60 No Crew
am involved in
the broadcast
channel
broadcast_la VARCHAR2 40 No The specific
nguage language a
game is
being
broadcasted
in
match_id NUMBER 6 F No Unique
number ID
for all
matches
MATCH_SCHEDULE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
match_id NUMBER 6 P, F No Unique
number ID
for all
matches
broadcast_id NUMBER 6 P, F No Unique
number ID
for all
broadcasts
match_date DATE 10 No The exact
date a match
takes place
in
match_time TIMESTAM 26 No The exact
P time a match
takes place
at
MATCH
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
match_id NUMBER 6 P No Unique
number ID
for all
matches
round_numb NUMBER 6 F No Unique
er number ID
for all
referees
tour_id NUMBER 6 F No Unique
number ID
for all
tournaments
venue_id NUMBER 6 F No Unique
number ID
for all
venues
SETTINGS
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
match_id NUMBER 6 P, F No Unique
number ID
for all
matches
referee_id NUMBER 6 P, F No Unique
number ID
for all
referees
REFEREE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
referee_id NUMBER 6 P No Unique
number ID
for all
referees
referee_nam VARCHAR2 60 No The full
e name of
referee
referee_cont NUMBER 15 No The contact
act number of
referee
VENUE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
venue_id NUMBER 6 P No Unique
number ID
for all
venues
venue_capac NUMBER 4 No The seating
ity capacity of
the venue
venue_facilit VARCHAR2 60 No The facilities
ies provided at a
venue for the
convenience
of
organizers,
players, and
audience
venue_name VARCHAR2 60 No The full
name of
venue
MATCH_STATISTIC
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
statistics_id NUMBER 6 P No Unique
number ID
for all
statistics
match_statist VARCHAR2 11 No The kill,
ics death, and
assist
statistics in a
specific
match
match_highli VARCHAR2 60 No The
ght highlights of
a match
match_result VARCHAR2 120 No The results
of the winner
of the match
commentator NUMBER 6 F No Unique
_id number ID
for all
commentator
s
COMMENTATOR_MATCH_STATISTIC
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
commentator Integer 6 P, F No Unique
_id number ID
for all
commentator
s
statistics_id Integer 6 P, F No Unique
number ID
for all
match_infor VARCHAR2 60 No Information
mation regarding the
match
COMMENTATOR
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
commentator NUMBER 6 P No Unique
_id number ID
for all
commentator
s
commentator NUMBER 15 No Contact
_contact number of
commentator
commentator VARCHAR2 60 No Full name of
_name commentator
broadcast_id INTEGER 6 F No Unique
number ID
for all
broadcasts
WINNER
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
winner_id INTEGER 6 P No Unique
number ID
for all
winners
match_id INTEGER 6 F No Unique
number ID
for all
matches
prize_id INTEGER 6 F No Unique
number ID
for all prizes
PRIZE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
prize_id NUMBER 6 P No Unique
number ID
for all prizes
given
prize_pool NUMBER 7 No Total amount
of prize
money for
the winners
prize_place VARCHAR2 5 No The
ment placement
for each
prizes
ROUND
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
round_numb NUMBER 1 P No The current
er round
number of
the match
round_name VARCHAR2 10 No The name of
the round
tour_id NUMBER 6 F No Unique
number ID
for all
tournaments
GAME
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
game_id NUMBER 6 P No Unique
number ID
for all games
game_develo VARCHAR2 60 No Full name of
per the game
developer
game_rules VARCHAR2 200 No Detailed
rules of the
game
tour_id NUMBER 6 F Yes Unique
number ID
for all
tournaments
ORGANIZER
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
organizer_id NUMBER 6 P No Unique
number ID
for all
organizers
organizer_co NUMBER 15 No Contact
ntact number of
the organizer
organizer_na VARCHAR2 60 No Full name of
me the organizer
organizer_w VARCHAR2 100 Yes URL address
ebsite of the
organizer’s
website
tour_id NUMBER 6 F No Unique
number ID
for all
tournaments
MEDIA_TEAM
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
media_conta NUMBER 15 P No Unique
ct number ID
for all
media_detail VARCHAR2 60 No Details
s regarding the
media
department
media_name VARCHAR2 60 No Full name of
the media
department
organizer_id NUMBER 6 F Yes Unique
number ID
for all
organizers
STREAMING_PLATFORM
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
platform_url VARCHAR2 100 P No Unique URL
address of
the
streaming
platform
platform_na VARCHAR2 60 No Full name of
me the
streaming
platform
platform_vie NUMBER 6 No The total
wcount number of
viewers that
watch a
particular
stream
media_conta NUMBER 15 F No Unique
ct contact
number for
media crew
LICENSING_FEE
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
platform_url VARCHAR2 100 P, F No Unique URL
address of
the
streaming
platform
broadcast_id NUMBER 6 P, F No Unique
number ID
for all
broadcasts
licensing_am NUMBER 7 No The amount
ount of money
that needs to
be paid to
obtain the
broadcast
license
TICKET
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
ticket_id NUMBER 6 P Unique
number ID
for all tickets
ticker_seatnu NUMBER 4 The seat the
m ticket grants
access to
ticket_purch DATE 10 The exact
asedate date the
ticket is
purchased
organizer_id NUMBER 6 F Unique
number ID
for all
organizers
SPONSOR
Attribute Data type Field size Primary/Fore Nullable Description
ign Key
(P/F)
sponsor_id NUMBER 6 P No Unique
number ID
for all
sponsors
sponsor_cont NUMBER 15 No Contact
act number of
the sponsor
sponsor_leve VARCHAR2 10 No The level of
l the sponsor
in order to
determine
the tokens of
appreciation
and
advertising
which the
sponsor
receives
sponsor_nam VARCHAR2 60 No Full name of
e the sponsor
tour_id NUMBER 6 F No Unique
number ID
for all
tournaments
