Small php+mysql website

Prepare creation script for the database to store rally data. a) Create a table 'competition' for the storage of competition. Fields: (i) Name (ii) Location (State, county, etc.) (iii) The start date of the event (iv) End date of the event b) Create a table for the list of competition sponsors 'sponsors'. Link the table to the 'competition' table with "one to many" relations. Fields: (i) Name of sponsor (company name) (ii) the URL to the sponsor's website. (iii) Image of the sponsor's company logo (filename). Store logo images in a separate folder. (iv) Remarks 3) Populate the database with the test data: a) 6 entries for competitions, 2 competitions each year, e.g. 2018-2020 (b) 3-4 sponsors for each competition. 4) create two web pages: (a) Display a list of competitions grouped by year: I) Sort the years descending and create a dedicated header to display each year. (ii) Display in each group the competition data in the form of a table. Sorted by date (start date). (iii) For each competition show both dates, names, and location. (iv) When you click the competition name, the new window must open (as a parameter race primary key identifier to be used) with detailed information. (b) Display the selected competition data — all competition data and the list of sponsors. (i) Display the logo and the name of the company in the Sponsors list. (ii) Both the logo and the company name of the sponsor should have hyperlinks to open they website URL on a separate browser tab. 5) the website must comply with to the HTML5 format.