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













0















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).









share







New contributor




Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    0















    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).









    share







    New contributor




    Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      0












      0








      0








      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).









      share







      New contributor




      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      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





      share







      New contributor




      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.










      share







      New contributor




      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.








      share



      share






      New contributor




      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 6 mins ago









      Potato23Potato23

      1




      1




      New contributor




      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Potato23 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          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.










          draft saved

          draft discarded


















          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.










          draft saved

          draft discarded


















          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

          Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

          How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...