database management system

FratBro23
Category:
Programming

Question description

 Scenario

A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Try to design an ER schema diagram for this application, stating any assumptions you make. Choose your favorite sport (soccer, Cricket or Tennis).

Some of the assumptions can be as followed:

  • Each game in the schedule is identified by a unique Game#, and a game is also identified uniquely by the combination of Date, starting Time, and Field where it is played. The Performance attribute of PARTICIPATE is used to store information on the individual performance of each player in a game. 
  • A player would be laying for a team in a particular game which may be played on home ground or away.
  • List all what you identify for your favorite Game….

Answer the following Questions:

  • List and explain the Entities in the Scenario.   
  • List all the attributes that you feel necessary to represent an Entity. 
  • List and explain all the relationship types (for example Binary, Ternary  ...)
  • Draw the ER diagram. (You can use any software MS-Word (flow chart tools), Irwin, Rational Rose). 
  • Give the Relational schema for the Database that you have designed in question #4. 
  • Identify all the keys needed and explain why you have selected a particular candidate key as primary key.
  • List any Specialization and Generalization Hierarchies.  





      

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: Boston College
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1822 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors