Question: I NEED AN ER DIAGRAM MADE NOTHING ELSE, THANK YOU 18. The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track

I NEED AN ER DIAGRAM MADE NOTHING ELSE, THANK YOU 18. The

I NEED AN ER DIAGRAM MADE NOTHING ELSE, THANK YOU

18. The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about college basketball. Each team can have a maximum of twenty (20) players and a minimum of thirteen (13) players. Each player can play for only one team. Players are called players because they play in games, in fact, several games. A game involves at least ten players. It is possible that some players simply sit on the bench and do not play in any game. Player performance statistics (i.e., points scored, rebounds, assists, minutes played, and personal fouls committed) are recorded for each player for every game. Information collected about a game includes the game number, the final score, the attendance, and the date of the game. A player can be identified by student number (i.e., Social Security number) only. The other attributes for a player include name, major, and grade point average. A team is identified by the name of the university (i.e., team). Other team attributes include current ranking, capacity of home court, and number of players. A game can be identified by game number only. Develop a Presentation Layer ER model for the NCAA database. The ERD should be fully specified with the unique identifiers, other attributes for each entity type, and the relationship types that exist among the various entity types. All business rules that can be captured in the ERD must be present in the ERD. Any business rule that cannot be captured in the ERD should be specified as part of a list of semantic integrity constraints. Hint: No more than three entity types are needed to complete this design

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!