The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about
Question:
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 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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Question Posted: