Create a class diagram for the intramural basketball league explained in this problem. Create a new schema, add tables, and fields for each table. Assign proper data types and sizes to all fields. Determine primary and foreign keys to make it a schema for a relational database. Ensure it is in first, second, and third normal form.

3. 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 Referee, phone playoff y Player Student/faculty/staff Height Opponent Points Won/Loss Opponent Points