Log out Go to App
Go to App

Learning Materials

Features

Discover

Chapter 7: Problem 35

Consider requirements for teams, players and games, and develop a suitable ERD. Each team would have a unique name, have a non-player who is the coach, and have several players. Each player has a first and last name and is identified by a number (1, 2, 3, etc.). One player is designated the captain of the team. Assume a game occurs on some date and time, and is played by two teams where one team is called the home team and the other team is called the visiting team. At the end of the game the score must be recorded.

Short Answer

Expert verified
The entities for this exercise are 'Players', 'Teams', 'Games' and 'Coach'. Relationships are 'Players' belong to 'Teams', 'Teams' possess 'Players' and have a 'Coach', and 'Teams' participate in 'Games'. One 'Player' per 'Team' is designated as the Captain. The ERD visually represents these relationships and entities with their attributes and special roles.

Step by step solution

01

Identify Entities

The entities here are 'Players', 'Teams', 'Games' and 'Coach'. Each entity has certain attributes. 'Players' have first name, last name, and number. 'Teams' have a unique name. 'Games' occur on certain date and time. 'Coach' isn't detailed on attributes, but each team has one coach.
02

Identify Relationships

Relationships between these entities can be established. A 'Player' is a part of one 'Team'. A 'Team' can have several 'Players'. Each 'Team' has one 'Coach'. Two 'Teams' participate in a 'Game' - one can be designated as the Home Team and other as Visiting Team. 'Game' holds the Score at the end.
03

Designate Special Roles

It's mentioned that one player is designated the captain of the team. This can be marked as boolean attribute for a 'Player' entity.
04

Create the ERD

Based on the identified entities, attributes, roles, and their relationships, the ERD can be created. It's important to visualize these on a diagram using symbols like circles for entities, lines for relationships and marking attributes next to the entities. Use a different symbol to mark the captain inside the 'Player' entity.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Start your free trial

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Consider an address attribute. Show that this can be modeled as a multi-level composite attribute where the component attributes include street, city, province, country and where street includes apartment number, street number, street name.

What problems arise if one makes the supervises relationship mandatory for either the supervising employee or the employee who is supervised?

Consider an educational institution that has departments and where each department offers courses. Suppose departments are assigned unique identifiers and so deptCode is a key for the department entity type. Courses are identified within a department by a course number; course numbers are unique within a department but not across departments. So, History may have a course numbered 215, and English could have a course numbered 215 too. In order to identify a particular course we need to know the department and we need to know the course number. Illustrate an ERD including department and course entity types. Include attributes for the Department (department code and department name), and for Course (course number, title, and description).

Consider your educational institution or place of work. 1\. What are some of the entity types that would be useful? 2\. What relationships exist that relate entity types to one another? 3\. What attributes would be useful to describe entities and relationships? 4\. Draw an ERD.

Draw an ERD for marriages between two people. For persons include birthdate, first name, last name, and a unique person id. Consider marriage to be a relationship between two people and suppose we want our model to allow for people to have more than one marriage. Use the date of the marriage as a discriminator.
See all solutions

Recommended explanations on Computer Science Textbooks

Theory of Computation

Read Explanation

Computer Programming

Read Explanation

Data Structures

Read Explanation

Computer Systems

Read Explanation

Computer Organisation and Architecture

Read Explanation

Game Design in Computer Science

Read Explanation
View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free