Suppose you are given the following requirements for a simple database for the Oman National Hockey Team (ONHT):The ONHT has many teams,Each team has a name, a city, a coach, a captain, and a set of players,Each player belongs to only one team,Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records,A team captain is also a player,A game is played between two teams (referred to as host_team and guest_team) and has a date (such as June, 12th, 2021) and a score (Such as 6 to 4). Construct a clean and concise ER diagram for the ONHT database.

Answered: Suppose you are given the following…

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

Suppose you are given the following requirements for a simple database for the Oman National Hockey Team (ONHT):

The ONHT has many teams,
Each team has a name, a city, a coach, a captain, and a set of players,
Each player belongs to only one team,
Each player has a name, a position (such as left wing or goalie), a skill level, and a set of injury records,
A team captain is also a player,
A game is played between two teams (referred to as host_team and guest_team) and has a date (such as June, 12th, 2021) and a score (Such as 6 to 4).

Construct a clean and concise ER diagram for the ONHT database.

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