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 DesignSpecific conceptual ER model for the following business requirements to answer questions from
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 players and a minimum of thirteen 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 ie 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 ie 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 ie 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 convertdecompose
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
