create and insert the following Database sql tables . ---be careful in the last table (penlties)

Sports Club Project Given the sports club tables below: Construct the database tables with the designated data. You must submit the notepads and spool files. Answer all the questions below. Grade is on answering the 11 questions not creating the tables and inserting the records. The mark of the project will be after discussing it with each student individually in a separate zoom meeting. The PLAYERS table HOUSENO 80 23 16A 43 PLAYERNO NAME 6 Parmenter 44 Baker 83 Hope 2 Everett 27 Collins 104 Moorman 7 Wise 57 Brown 39 Bishop 112 Bailey 8 Newcastle 100 Parmenter 28 Collins 95 Miller INITIALS R E PK R DD D GWS M D IP B P P BIRTH 1964 1963 1956 1948 1964 1970 1963 1971 1956 1963 1962 1963 1963 1963 S JOINED STREET M 1977 Haseltine Lane M 1980 Lewis Street M1982 Magdalene Road M 1975 Stoney Road F 1983 Long Drive F 1984 Stout Street M 1981 Edgecombe Way M 1985 Edgecombe Way M 1980 Eaton Square F 1984 Vixen Road F 1980 Station Road M 1979 Haseltine Lane F 1983 Old Main Road M 1972 High Street 804 65 39 16 78 8 4 80 10 33A POSTCODE TOWN PHONENO LEAGUENO 1234KK Stratford 070-476537 8467 4444LJ Inglewood 070-368753 1124 1812UP Stratford 070-353548 1608 3575NH Stratford 070-237893 2411 8457DK Eltham 079-234857 2513 9437AO Eltham 079-987571 7060 9758VB Stratford 070-347689 4377CB Stratford 070-473458 6409 9629CD Stratford 070-393435 6392LK Plymouth 010-548745 1319 6584RO Inglewood 070-458458 2983 1234KK Stratford 070-494593 6524 1294QK Midhurst 071-659599 57460P Douglas 070-867564 The TEAMS table: TEAMNO PLAYERNO 1 6 2 27 DIVISION first second Page 1 of 3 The GAMES table: TEAMNO PLAYERNO 1 6 1 44 1 83 1 2 1 57 1 8 2 27 2 104 2 112 2 8 WON 9 7 3 4 5 0 11 8 4 4 LOST 1 5 3 8 0 1 2 4 8 4 NNNL UNL The PENLTIES table: PAYMENTNO PLAYERNO 1 6 2 44 3 27 4 104 5 44 6 8 7 44 8 27 PEN DATE AMOUNT 12/08/80 100.00 05/05/81 75.00 09/10/83 100.00 12/08/84 50.00 12/08/80 25.00 12/08/80 25.00 12/30/82 30.00 11/12/84 75.00 From TEAMS to PLAYERS: Each captain of a team is also a player. The set of player numbers from the TEAMS table is a subset of the set of player numbers from the PLAYERS table. From GAMES to PLAYERS: Each player who competes for a particular team must appear in the PLAYERS table. The set of player numbers from the GAMES table is a subset of the set of player numbers from the PLAYERS table. From GAMES to TEAMS: Each team that appears in the GAMES table must also be present in the TEAMS table, because a player can only compete for registered teams. The set of team numbers from the GAMES table is a subset of the of team numbers from the TEAMS table. From PENLTIES to GAMES: A penalty can only be imposed on the players who have participated in the competition. The set of player numbers from the PENLTIES table is a subset of the set of player numbers of the GAMES table. Be careful. Page 2 of 3