he South African Sports Group (SASG) has just started going digital for all their information needs to make it nore accessible to the public. To test their new project, they have decided to first focus only on all rugby eams in the country. n order to help the SASG keep track of all the rugby teams in the country, they have asked you to draw an Entity elationship Diagram to show the structure of the database. hey have provided you with the following extra information: • They would like you to keep track of every rugby team in the country (name of the team, name of the team's founder, and date on which the team was founded) • They would like to keep track of all the rugby players in the country (their name, and date of birth, and which rugby team they belong to) One rugby team can have many rugby players, and one rugby player can only play for one rugby team. They would like to keep track of all the rugby games happening in the country (name of the game, date of the start of the game, and name of the main sponsor of the game), • They would like to know which rugby teams are participating in each of the rugby games, and the number of tries the team has scored in those games. One rugby team can participate in many rugby games, and one rugby game can have multiple teams participating in it.
he South African Sports Group (SASG) has just started going digital for all their information needs to make it nore accessible to the public. To test their new project, they have decided to first focus only on all rugby eams in the country. n order to help the SASG keep track of all the rugby teams in the country, they have asked you to draw an Entity elationship Diagram to show the structure of the database. hey have provided you with the following extra information: • They would like you to keep track of every rugby team in the country (name of the team, name of the team's founder, and date on which the team was founded) • They would like to keep track of all the rugby players in the country (their name, and date of birth, and which rugby team they belong to) One rugby team can have many rugby players, and one rugby player can only play for one rugby team. They would like to keep track of all the rugby games happening in the country (name of the game, date of the start of the game, and name of the main sponsor of the game), • They would like to know which rugby teams are participating in each of the rugby games, and the number of tries the team has scored in those games. One rugby team can participate in many rugby games, and one rugby game can have multiple teams participating in it.
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...
Related questions
Question
Transcribed Image Text:The South African Sports Group (SASG) has just started going digital for all their information needs to make it
more accessible to the public. To test their new project, they have decided to first focus only on all rugby
teams in the country.
In order to help the SASG keep track of all the rugby teams in the country, they have asked you to draw an Entity
Relationship Diagram to show the structure of the database.
They have provided you with the following extra information:
They would like you to keep track of every rugby team in the country (name of the team, name of the
team's founder, and date on which the team was founded)
• They would like to keep track of all the rugby players in the country (their name, and date of birth, and
which rugby team they belong to)
• One rugby team can have many rugby players, and one rugby player can only play for one rugby team.
• They would like to keep track of all the rugby games happening in the country (name of the game, date
of the start of the game, and name of the main sponsor of the game),
• They would like to know which rugby teams are participating in each of the rugby games, and the number
of tries the team has scored in those games.
One rugby team can participate in many rugby games, and one rugby game can have multiple teams
participating in it.
A. Given the information above, draw an ER Diagram showing the following:
• Entities,
• Attributes,
• Show all key attributes,
Data types for each attribute, and
All relationships between the entities
NB: You may use one of the standardised ERD notations.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY