project last

A non-profit basketball organization facilitates game scheduling and tracking for several different basketball teams.
• A team can be active or inactive.
• Each team is identified (i.e. named) with a Name.
• There are several basketball players.
• Each basketball team employs several players.
• At any time, a player can belong to only one basketball team for each year.
• Teams are designated according to level (Novice, Midget, Bantam, PeeWee) and each level has an upper age limit.
• Games are played at one of the many courts in K-W. Courts charge an hourly rental fee that varies from court to court but is never less than $100 per hour.
• Games are scheduled between 2 teams and are scheduled for a specific court, date and time
• Every team has only one manager.
• A manager may manage more than one team.
• No two teams can play each other more than once a day.



 [3] At least 3 records of valid data in every table.
 add yourself as a manager, managing more than 1 team.


You will need to add in any table:

o [2] At least 2 Different validation rules and text.
o [3] At least 3 Different input Masks
o [1] At least 2 Different Formats


Write Queries for this basketball organization: [yi = your initials]
1. [2] A list of all the players on a given team during a given year.
o Name: yiTeamPlayers.
2. [2] A list of a team’s standings based on points. Points are calculated as 2 for a win, 1 for a tie, and 0 for a loss.
o Name: yiTeamStandings.
3. [4] A list of managers of teams that have won more than 50% of their games.
o yiTeamsWonMore.
4. [2] A list of overage players (players who are older than the age limit for the team).
 Name: yiPlayersToResign