Sfrgttk

If I delete my router's history can my ISP still provide it to my parents?

Pre-1980's science fiction short story: alien disguised as a woman shot by a gangster, has tentacles coming out of her breasts when remaking her body

Does fast page mode apply to ROM?

Program that converts a number to a letter of the alphabet

Can we use the stored gravitational potential energy of a building to produce power?

Why did this image turn out darker?

What to do when being responsible for data protection in your lab, yet advice is ignored?

Would a National Army of mercenaries be a feasible idea?

Does Windows 10's telemetry include sending *.doc files if Word crashed?

Typing Amharic inside a math equation?

Why is working on the same position for more than 15 years not a red flag?

Should I write a companion book/blog?

Why Normality assumption in linear regression

Contest math problem about crossing out numbers in the table

How to tag distinct options/entities without giving any an implicit priority or suggested order?

Dilemma of explaining to interviewer that he is the reason for declining second interview

Placing an adverb between a verb and an object?

Avoiding morning and evening handshakes

Checking for the existence of multiple directories

Showing size of pie chart in legend of QGIS?

Process to change collation on a database

Can you earn endless XP using a Flameskull and its self-revival feature?

Lick explanation

What's a good word to describe a public place that looks like it wouldn't be rough?

ESports League ERD

Design of fact table(s) and dimensions tables for data warehouseOne to one relationship or another approach?Best practice for entry position indicatorsArchery League Database designHow to design a database that tracks sports player's positionsUnique column values between tablesIs this db/table structure sensible?Django Multi Table Inheritance and Preserving Child and Child HistoryNeed Help Designing Tennis Ladder DatabaseSUM n rows of each group with ORDER BY and LIMIT where the LIMIT is based off of another table

1

I'm creating a database for an esports league and am having some issues putting it all together for an ERD. Here's a quick rundown on how the game works:

There are 2 teams of 5 Players each. These Players have unique positions on the team (5 total positions). The Players use unique characters for the match that can change from one match to the next but cannot change during the match. The players earn kills, assists, gold, etc (different statistics I want to record in the database) throughout the match.

I have the following tables so far:

PLAYER

Player_Name (PK)

Player_Password

Player_Picture

TEAM

Team_Name (PK)

Team_Logo

Player_ID (FK)

MATCH

Match_ID

Team_ID (FK) (Team_1 & Team_2) (Associative entity needed?)

Game_Time

Game_Date

Game_Length

I'm also stuck on where to put the STATS table and where to put the CHARACTER table and which tables these two need to connect to.

Additional notes and considerations:

-Each player uses a character for each match. This character can change from match to match. I was planning on adding a CHARACTER table but I'm unsure where to connect it.

-I would also like to keep track of different statistics for each match, for both the team and the individual players (kills, assists, gold, etc). I'm not sure where to add this table and which other tables it should be connected to. The team stats are essentially a rollup of the individual player stats (Team total kills = summation of its players' kills). I want to be able to analyze a Player's stats overall and the Player's stats for each individual character that they use.

-Each Player also has a unique position (there are 5 players/positions per team). I would also like to be able to analyze each player's stats by position.

Any help would be greatly appreciated.

database-design erd

share|improve this question

asked Oct 15 '15 at 0:36

Chris KChris K

61

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

1

I'm creating a database for an esports league and am having some issues putting it all together for an ERD. Here's a quick rundown on how the game works:

There are 2 teams of 5 Players each. These Players have unique positions on the team (5 total positions). The Players use unique characters for the match that can change from one match to the next but cannot change during the match. The players earn kills, assists, gold, etc (different statistics I want to record in the database) throughout the match.

I have the following tables so far:

PLAYER

Player_Name (PK)

Player_Password

Player_Picture

TEAM

Team_Name (PK)

Team_Logo

Player_ID (FK)

MATCH

Match_ID

Team_ID (FK) (Team_1 & Team_2) (Associative entity needed?)

Game_Time

Game_Date

Game_Length

I'm also stuck on where to put the STATS table and where to put the CHARACTER table and which tables these two need to connect to.

Additional notes and considerations:

-Each player uses a character for each match. This character can change from match to match. I was planning on adding a CHARACTER table but I'm unsure where to connect it.

-I would also like to keep track of different statistics for each match, for both the team and the individual players (kills, assists, gold, etc). I'm not sure where to add this table and which other tables it should be connected to. The team stats are essentially a rollup of the individual player stats (Team total kills = summation of its players' kills). I want to be able to analyze a Player's stats overall and the Player's stats for each individual character that they use.

-Each Player also has a unique position (there are 5 players/positions per team). I would also like to be able to analyze each player's stats by position.

Any help would be greatly appreciated.

database-design erd

share|improve this question

asked Oct 15 '15 at 0:36

Chris KChris K

61

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I'm creating a database for an esports league and am having some issues putting it all together for an ERD. Here's a quick rundown on how the game works:

There are 2 teams of 5 Players each. These Players have unique positions on the team (5 total positions). The Players use unique characters for the match that can change from one match to the next but cannot change during the match. The players earn kills, assists, gold, etc (different statistics I want to record in the database) throughout the match.

I have the following tables so far:

PLAYER

Player_Name (PK)

Player_Password

Player_Picture

TEAM

Team_Name (PK)

Team_Logo

Player_ID (FK)

MATCH

Match_ID

Team_ID (FK) (Team_1 & Team_2) (Associative entity needed?)

Game_Time

Game_Date

Game_Length

I'm also stuck on where to put the STATS table and where to put the CHARACTER table and which tables these two need to connect to.

Additional notes and considerations:

-Each player uses a character for each match. This character can change from match to match. I was planning on adding a CHARACTER table but I'm unsure where to connect it.

-I would also like to keep track of different statistics for each match, for both the team and the individual players (kills, assists, gold, etc). I'm not sure where to add this table and which other tables it should be connected to. The team stats are essentially a rollup of the individual player stats (Team total kills = summation of its players' kills). I want to be able to analyze a Player's stats overall and the Player's stats for each individual character that they use.

-Each Player also has a unique position (there are 5 players/positions per team). I would also like to be able to analyze each player's stats by position.

Any help would be greatly appreciated.

database-design erd

share|improve this question

asked Oct 15 '15 at 0:36

Chris KChris K

61

share|improve this question

asked Oct 15 '15 at 0:36

Chris KChris K

61

share|improve this question

asked Oct 15 '15 at 0:36

Chris KChris K

61

asked Oct 15 '15 at 0:36

Chris KChris K

61

asked Oct 15 '15 at 0:36

Chris KChris K

61

1 Answer
1

active

oldest

votes

0

In my opinion:
Create your CHARACTER, MATCHSPLAYERSSTATS and POSITION(Top, Mid, Jungle, etc I suppose?).

Then, assuming the MATCHSPLAYERSSTATS table will have a line for each player of the match, you could for PK the keys CharacterPK(s), Match_ID and Player_Name(although I recommend not using the name as a PK), and a FK pointing to the POSITION table

This way, each MATCH would have 10 stats, each one for one player, and linking to the character used in that Match

share|improve this answer

edited Oct 16 '15 at 12:10

answered Oct 16 '15 at 12:05

HDDHDD

12

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f118091%2fesports-league-erd%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

In my opinion:
Create your CHARACTER, MATCHSPLAYERSSTATS and POSITION(Top, Mid, Jungle, etc I suppose?).

Then, assuming the MATCHSPLAYERSSTATS table will have a line for each player of the match, you could for PK the keys CharacterPK(s), Match_ID and Player_Name(although I recommend not using the name as a PK), and a FK pointing to the POSITION table

This way, each MATCH would have 10 stats, each one for one player, and linking to the character used in that Match

share|improve this answer

edited Oct 16 '15 at 12:10

answered Oct 16 '15 at 12:05

HDDHDD

12

add a comment | 

0

In my opinion:
Create your CHARACTER, MATCHSPLAYERSSTATS and POSITION(Top, Mid, Jungle, etc I suppose?).

Then, assuming the MATCHSPLAYERSSTATS table will have a line for each player of the match, you could for PK the keys CharacterPK(s), Match_ID and Player_Name(although I recommend not using the name as a PK), and a FK pointing to the POSITION table

This way, each MATCH would have 10 stats, each one for one player, and linking to the character used in that Match

share|improve this answer

edited Oct 16 '15 at 12:10

answered Oct 16 '15 at 12:05

HDDHDD

12

add a comment | 

In my opinion:
Create your CHARACTER, MATCHSPLAYERSSTATS and POSITION(Top, Mid, Jungle, etc I suppose?).

Then, assuming the MATCHSPLAYERSSTATS table will have a line for each player of the match, you could for PK the keys CharacterPK(s), Match_ID and Player_Name(although I recommend not using the name as a PK), and a FK pointing to the POSITION table

This way, each MATCH would have 10 stats, each one for one player, and linking to the character used in that Match

share|improve this answer

edited Oct 16 '15 at 12:10

answered Oct 16 '15 at 12:05

HDDHDD

12

share|improve this answer

edited Oct 16 '15 at 12:10

answered Oct 16 '15 at 12:05

HDDHDD

12

answered Oct 16 '15 at 12:05

HDDHDD

12

answered Oct 16 '15 at 12:05

HDDHDD

12