Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure primary keys are clear.

Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure primary keys are clear.

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: • We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs. • Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses. • Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. • For each match we need to keep track of the following: • The date on which the game is played • The final result of the match • The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card (Represent this as Match-Player Entity Type) • During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place. • Each match has exactly three referees. For each referee we have an ID (unique identifier), name, DoB, years of experience. One referee is the main referee and the other two are assistant referee Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure primary keys are clear.
Transcribed Image Text:Assume we have the following application that models soccer teams, the games they play, and the players in each team. In the design, we want to capture the following: • We have a set of teams, each team has an ID (unique identifier), name, main stadium, and to which city this team belongs. • Each team has many players, and each player belongs to one team. Each player has a number (unique identifier), name, DoB, start year, and shirt number that he uses. • Teams play matches, in each match there is a host team and a guest team. The match takes place in the stadium of the host team. • For each match we need to keep track of the following: • The date on which the game is played • The final result of the match • The players participated in the match. For each player, how many goals he scored, whether or not he took yellow card, and whether or not he took red card (Represent this as Match-Player Entity Type) • During the match, one player may substitute another player. We want to capture this substitution and the time at which it took place. • Each match has exactly three referees. For each referee we have an ID (unique identifier), name, DoB, years of experience. One referee is the main referee and the other two are assistant referee Design an ER diagram to capture the above requirements. State any assumptions you have that affects your design. Make sure primary keys are clear.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS