Develop an ER model for the NCAA database based on the scenario below. If you discover while drawing the diagram that the scenario is incomplete, make up reasonable ex planations to complete the story. Supply your explanations along with the diagram The ERDs you make look like the Tiny College ERD shown in Figure 4.35. That is, your ERD must show o Entity: The proper number of entities and their names o All needed attributes of cach entity: Even though the question doesn't describe them, you should add them based orn Primary key and Foreign key common sense o Relationship Max. and Min. cardinalities: Ifneeded, you can put your justifications on you answer document about why you use the cardinality Description (text) of relationship between entities (e.g, takes, advises, has, ete. in Figure 435) The correct number of relationships between entities In drawing the model, use Crow's foot model (notation) In drawing the diagram, you can use any (diagraming) software, such as Drawio, Microsoft Visio, LucidChart, or even Microsoft Word .Copy and paste the diagram to Microsoft Word or convert them PDF and Submit the Word file or PDF file o o Include diagram ONLY, not entire software screen Your submission should be readable Put your name on your document Due date: Sept. 23 (Sunday) 1:59PM Eastern Time Scenario 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 (e.g, the University of Houston belongs to Conference USA; the University of Cincinnati belongs to the Big East Conference, tc) but a few teams 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 twenty (20) players and a minimum of thirteen (13) players. Each player can play for only one team. Each team from three (3) to se ven (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 uni versities is played at a given location only one time a year. Three referees from alarger pool of referees are assigned to each game. A referee can work several games; however, some referees ay not be assigned to any game. 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 se ored, rebounds, assists, minutes played, and Informati on cD 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, l fouls committed) are recorded for each player for every game about a game includes the final score, the attendince, and the date of the game