Problem: (NCAA Basketball) Each university basketball team has an internal ID in the conference that uniquely identifies it. Each team also has a name and carries its current rank with it. Each team has many players. A player has ID, name, height, weight and position(s) they play. A player may play multiple positions. Each team also has head coaches. Some head coaches are part timer and work for many schools. The coach's ID, name, and salary will be stored in the database. When a head coach teaches players, his role and coaching hour are captured.
a) Identify the entity types:
b) Identify attributes of each entity type:
c) Determine identifier attribute of each entity type:
d) Identify the attributes of an associative entity, if any:
e) State the relationships among the entities
f) Draw relational data model.