Relations Team(country, coach) A tuple in this relation represents the team of a country that participates in the competition. country is the team's country name, and coach is the name of the team's coach Player(PID, fname, lname, position, goals, country) A tuple in this relation represents a football player who is participating in the contest. PID is the player's ID, fname is their first name, lname is their last name, position is the position they are playing on the pitch, goals is the number of goals the player has scored so far in the competition, and country is the country of the team they are playing for. . Stadium(SID, capacity, city) A tuple in this relation represents a stadium where a match takes place. SID is the stadium's ID, capacity is the capacity of the stadium, and city is the city where the stadium is located. Match(MID, date, time, SID) A tuple in this relation represents a match. MID is the id of the match, date is the date the match is scheduled on, time is the time the match is scheduled on, and SID is the SID of the stadium where the match takes place Ticket(TID, datelssued, timeIssued, MID) A tuple in this relation represents a ticket that was purchased. TID is the ticket's id, datels- sued is the date that it was purchased, timelssued is the time that it was purchased, and MIID is the MID of the match it was purchased for. . Competes(MID, countryl, country2, goalsl, goals2) A tuple in this relation represents which teams are competing in a match. MID is the id of the match, country1 is the country of the first team, country2 is the country of the second team, goals 1 is the number of goals scored by the first team, and goals2 is the number of goals scored bv the second team Integrity constraints ayer(countryl STeamcountry] Match[SID] C Stadium|SID] . Ticket MID] C Match[MID] . Competes MID C Match MID] Competes[countryl] C Team[country] Competes[country2 C Team[country] Part 1 [20%-4 marks each: Additional Integrity Constraints Below are some additional integrity constraints on our schema. Express each of them using the notation from Section 2.5.1 of your textbook. If a constraint cannot be expressed using this notation, simply write "cannot be expressed" 1. No team can play against itself 2. All tickets for a match have to be purchased before the time of the match 3. The number of tickets purchased for a match should not exceed the capacity of the stadium where the match takes place 4. A coach can only coach one team 5. A player's position should be one of 'G', 'D', 'M' or 'S' representing a goalkeeper, defender, midfielder or striker, respectively