In the problem below use MySQL and develop a class diagram for the intramural basketball league. Develop a new schema, add tables, and add fields for every table. Assign the appropriate types of data and sizes to every field. Identify the primary and foreign keys in order to make it a schema for a relational database.

You have been hired by the student sports director to build a database for the intramural basketball leagues. The leagues have several teams each year. For the most part the teams get to select the level of competition: A, B, or C. There is more prestige to winning the A (or B) league so the better teams select into that league. There is also a league for teams composed of players all under 6 feet, and there is also a co-ed league that requires at least 2 women on the floor for each game. For the most part, players are assigned to a single team, but they do have the ability to switch to a different team if they desire. So players sign up for each team game but no one tracks points scored by each person. Only the total team points and win/loss are tracked.

Team Name League

Game Date, Time, Court playoff y/n

Referee, phone

Player	Student/faculty/staff	Height

Opponent

Points Opponent Points

Won/Loss