Due in 8 hours

profileecila

Do Problem #3 from the Problems section of the chapter 4. Remember to use Visio where necessary. Ignore question f; for question e use crows foot and ignore Chen; ignore question c and instead show all connectivity and cardinality. WARNING: the solution to the problem is identical to that of a professional team or an amateur league like NCAA . For example, your design should be able to find answers to the following questions: who plays on what team, who coaches which team, the score for each team per game, where the game was played, the number of points a player scored in a given game, the average number of rebounds for a player’s career, what position does a player play, etc. These are just some examples of questions. One or more relationships may not be explicitly mentioned because the DB designer is expected to know these relationships exist. Therefore, you should investigate the relationship between tables to identify this (or these) relationships that may not pop out at you. There is one relationship that most students miss and there are two the some students miss. Let’s see if you could find it/them. Make sure to include all of the necessary fields to store all of the information for each table. 

 

 

Deliverables:

You are handing in one complete ERD where information from a, b,… e are represented in a single diagram. In summary, it is a DB design where all P-Keys, Fkeys, Fields, connectivities, and cardinalities are shown. 

  • 9 years ago
  • 10
Answer(0)
Bids(0)