Data base systmes:Design an ER schema diagram for a sport league database to keep track of the teams and games of it.The database is organized into teams. Each team has a unique name, a unique number, and particular colors. A team may have several colors.Each team plays several games. It is desired to keep track of the result of each game.A team has a number of players, not all of whom participate in each game. Each player has a unique name, a unique number, and a particular position. It is desired to keep track of the players participating in each game for each team, the performance they played in that game, and the time played by each player in each game.

Answered: Data base systmes: Design an ER schema…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Data base systmes:

Design an ER schema diagram for a sport league database to keep track of the teams and games of it.

The database is organized into teams. Each team has a unique name, a unique number, and particular colors. A team may have several colors.
Each team plays several games. It is desired to keep track of the result of each game.
A team has a number of players, not all of whom participate in each game. Each player has a unique name, a unique number, and a particular position. It is desired to keep track of the players participating in each game for each team, the performance they played in that game, and the time played by each player in each game.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions