Question
The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about college basketball. Each university team belongs to only
The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about college basketball. Each university team belongs to only one conference (the University of Houston belongs to Conference USA; the University of Cincinnati belongs to the Big East Conference, etc.), but a team may not belong to any conference. A conference has several teams; no conference has less than five (5) teams. Each team can have a maximum of 20 players and a minimum of 13 players. Each player can play for only one team. Each team has from three (3) to seven (7) coaches on its coaching staff, and a coach works for only one team. Lots of games are played in each university location every year, but a game between any two universities is played at a given location only one time a year. Three referees from a larger pool of referees are assigned to each game. A referee can work several games; however, some referees may not be assigned to any game. Players are called players because they play in gamesin fact, several games. A game involves at least 10 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 final score, the attendance, and the date of the game. During the summer months, some of the players serve as counselors in summer youth basketball camps. These camps are identified by their unique campsite location (e.g., Mason, Bellaire, Kenwood, League City, etc.). Each camp has at least three (3) players who serve as counselors, and a player serving as a counselor may work in a number of camps. 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. For a coach, relevant attributes include name, title (e.g., head coach, assistant coach), salary, address, and telephone number. Attributes for a referee include name, salary, years of experience, address, telephone number, and certifications. Both coaches and referees are identified by their personal NCAA identification number. 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. Each conference has a unique name, number of teams, and an annual budget. For the basketball camps, data is available on the campsite (i.e., location) and the number of courts. 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 relation- ship 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 seven entity types are needed to complete this design.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started