Identify connectivity of each relationship

Assignment Help Computer Engineering

Reference no: EM132952

Question

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in county has one team as its representative. Each team has a maximum of 12 players and a minimum of nine players. Each team also has up to three coaches (offensive, defensive, and physical training coaches). Throughout season, each team plays two games (home and visitor) against each of other teams. Given those circumstances, does following-

a. identify connectivity of each relationship?

b. Identify the type of dependency that exists between CITY and TEAM.

c. Identify the cardinality between teams and players and between teams and city.

d. Identify dependency between coach and team and between team and player.

Plan an ER diagram for this application. Specify key attributes of each entity type and structural constraints on each relationship type. Write down any unspecified requirements, and any assumptions that you need to make the specification complete.

Reference no: EM132952

Questions Cloud

Determine the income from the business : Determine the income from the business, excluding the profit on the sale of the tugboat?

Determine the direct labor rate variance : Determine the direct labor rate variance? Evaluate the standard direct labor rate?

Which of the costs would be explained as an opportunity cost : Which of the costs would be explained as an opportunity cost? Which is a sunk cost?

What are the errors : What are the errors

Identify connectivity of each relationship : Identify connectivity of each relationship

What affect will this have on operating income : What affect will this have on operating income

Suggest all sources using APA style : Suggest all sources using APA style

Comment-essential to establish only target market objectives : In setting prices, it is essential to establish only target market objectives. Comment If a company is to respond accurately to price changes, it must thoroughly understand its competitors. Discuss

Write down a css rule : Write down a CSS rule

User Account

All Pages