Question: Using the look near notation, please develop a Design - Specific conceptual ER model for the following business requirements to answer questions from 2 2

Using the "look near" notation, please develop a Design-Specific conceptual ER model for the following business requirements to answer questions from 22-28.
Business Requirements
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.
If a team is canceled, all links to the players for that team should be dropped. (This sentence is about deletion rules).
Your predecessor, Justin Rees, before leaving for Wales to pursue a career as a sheep farmer, began mapping and provided the following start to defining the Entity types:
Player (
Team (
Game (
How many relationships can you identify from the above description before you convert/decompose

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 Programming Questions!