Construct a clean and concise er diagram for nhl database

Assignment Help Basic Computer Science

Reference no: EM131076080

Suppose you are given the following requirements for a simple database for the National Hockey League (NHL): the NHL 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 May 11th, 1999) and a score (such as 4 to 2). Construct a clean and concise ER diagram for the NHL database.

Reference no: EM131076080

Questions Cloud

Coherence protocol implementation : If we instead implement a directory based cache coherence protocol discussed in the last week, how many bits of state do we need in the entire system for the coherence protocol implementation?

What will be the per capita real incomes of a and b : ECON 321: International Economics Assignment. Suppose two economies, A and B, start out with the same very low per capita real incomes of $1,000, but A grows at 1 percent per year and B grows at 2 percent. What will be the per capita real incomes o..

What was the problem with the way nations were claiming land : In the 1500s European nations began sending explorers to claim land in America. What was the problem with the way the nation's were claiming land?

Problem regarding the cloud profitability : In a two-page paper, discuss whether or not there are cost benefits to cloud computing using specific examples. Be sure to include at least three reference sources. APA rules for formatting, quoting, paraphrasing, citing, and listing of sources a..

Construct a clean and concise er diagram for nhl database : Construct a clean and concise ER diagram for the NHL database.

The mean value and standard deviation of lifetime : The authors of the article from which the data in Exercise 1.27 was extracted suggested that a reasonable probability model for drill lifetime was a lognormal distribution with µ = 4.5 an σ = .8. a.

Create the srv records : You recently discovered that a junior admin deleted some of the SRV records, which caused some users to have problems logging in. What is the best way to re-create the SRV records?

How did electric chicago blues differ from early rock n roll : How did electric Chicago blues of the mid-1950s differ from early rock 'n' roll from that same period? Describe the process by which gospel music morphed into "soul" in the 1950s and 1960s.

External share between the two domains : You have two domains (contoso.com and adatum.com) that have an external share between the two domains. You want to configure selective authentication. What should you do.

User Account

All Pages