May an entity can be an attribute for another entity?Design of fact table(s) and dimensions tables for data...
Count repetitions of an array
Was there a pre-determined arrangement for the division of Germany in case it surrendered before any Soviet forces entered its territory?
What is the draw frequency for 3 consecutive games (same players; amateur level)?
Should a new user just default to LinearModelFit (vs Fit)
Are all power cords made equal?
Democratic Socialism vs Social Democracy
How do you get out of your own psychology to write characters?
Why didn't Tom Riddle take the presence of Fawkes and the Sorting Hat as more of a threat?
why typing a variable (or expression) prints the value to stdout?
Coombinatorics- The number of ways of choosing with parameters
How to deal with an underperforming subordinate?
Why is Shelob considered evil?
Why is "rm -r" unable to delete this folder?
What is a good way to explain how a character can produce flames from their body?
Prevent Nautilus / Nemo from creating .Trash-1000 folder in mounted devices
What species should be used for storage of human minds?
What would be some possible ways of escaping higher gravity planets?
How much light is too much?
Why do neural networks need so many examples to perform?
How to not let the Identify spell spoil everything?
Other than edits for international editions, did Harry Potter and the Philosopher's Stone receive errata?
Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?
If angels and devils are the same species, why would their mortal offspring appear physically different?
Is there a non trivial covering of the Klein bottle by the Klein bottle
May an entity can be an attribute for another entity?
Design of fact table(s) and dimensions tables for data warehouseHow to link a customer to a country when the city/state isn't knownRelationships between subtypes of an entityHow to handle table design with variable columnsWhen normalizing a relational database, should multiple “type” tables be combined into one?ESports League ERDCan i pair multivalued attribute with an entity?Designing a database for a video game business domain with multiple many-to-many relationshipsAn entity may or may not be an existing customerNeed Help Designing Tennis Ladder Database
For ER/EER Diagram
I have one entity Stadium and another entity Match. In Match entity I have the stadium as an attribute.
The SOCCER database shall keep information about the stadiums used as venues for the
matches. Each STADIUM has a stadium id (SId – a surrogate key), stadium name
(SName), City, and Capacity (max. no. of spectators).
For each MATCH (game) played, we will keep track of the following information:
match/game id (GId – a surrogate key), game type (GType – see description below in
item 7), date the match was played (GDate), the venue where the game was played
(Stadium), first team (Team1), second team (Team2), first team score (Score1), and
second team score (Score2).
database-design
New contributor
add a comment |
For ER/EER Diagram
I have one entity Stadium and another entity Match. In Match entity I have the stadium as an attribute.
The SOCCER database shall keep information about the stadiums used as venues for the
matches. Each STADIUM has a stadium id (SId – a surrogate key), stadium name
(SName), City, and Capacity (max. no. of spectators).
For each MATCH (game) played, we will keep track of the following information:
match/game id (GId – a surrogate key), game type (GType – see description below in
item 7), date the match was played (GDate), the venue where the game was played
(Stadium), first team (Team1), second team (Team2), first team score (Score1), and
second team score (Score2).
database-design
New contributor
add a comment |
For ER/EER Diagram
I have one entity Stadium and another entity Match. In Match entity I have the stadium as an attribute.
The SOCCER database shall keep information about the stadiums used as venues for the
matches. Each STADIUM has a stadium id (SId – a surrogate key), stadium name
(SName), City, and Capacity (max. no. of spectators).
For each MATCH (game) played, we will keep track of the following information:
match/game id (GId – a surrogate key), game type (GType – see description below in
item 7), date the match was played (GDate), the venue where the game was played
(Stadium), first team (Team1), second team (Team2), first team score (Score1), and
second team score (Score2).
database-design
New contributor
For ER/EER Diagram
I have one entity Stadium and another entity Match. In Match entity I have the stadium as an attribute.
The SOCCER database shall keep information about the stadiums used as venues for the
matches. Each STADIUM has a stadium id (SId – a surrogate key), stadium name
(SName), City, and Capacity (max. no. of spectators).
For each MATCH (game) played, we will keep track of the following information:
match/game id (GId – a surrogate key), game type (GType – see description below in
item 7), date the match was played (GDate), the venue where the game was played
(Stadium), first team (Team1), second team (Team2), first team score (Score1), and
second team score (Score2).
database-design
database-design
New contributor
New contributor
New contributor
asked 6 mins ago
Potato23Potato23
1
1
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
Potato23 is a new contributor. Be nice, and check out our Code of Conduct.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230642%2fmay-an-entity-can-be-an-attribute-for-another-entity%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Potato23 is a new contributor. Be nice, and check out our Code of Conduct.
Potato23 is a new contributor. Be nice, and check out our Code of Conduct.
Potato23 is a new contributor. Be nice, and check out our Code of Conduct.
Potato23 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230642%2fmay-an-entity-can-be-an-attribute-for-another-entity%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown