I. I. Instructions: 1.This project will evaluated as in the following: a. Design the database, following an ER model. b. Normalize the tables ( each table should be in 3NF at least) c. Use MySQL or any other database to create the normalized tables and populate your tables with at least 5 rows. d. Execute the sample requested queries. 2. Each student has to submit one report about his/her chosen Project containing the following: a. ER Diagram. b. All schemas before and after normalization. c. All SQL statements of:    creating tables inserting data in tables queries. 3. Screenshots from MySQL (or any other software you use) of all the tables after population and queries results. 4. Use Times New Roman font for all your answers. Football championship calendar This project supposed to develop a database system for football championship calendar. The system contains information about teams, stadiums, referees, and matches. A match is composed by local team, visitor team, date of match, referee and stadium and the score. You should design the system to contain entities and attributes to store data that makes the system able manage the championship and to organize the different matches. Note that the winner has 3 points and the loser 0 point. In draw case, 1 point for each team. The referee is identified by his ID. The team is identified by his name. SQL Queries: 1. List the matches of the current day. 2. List the matches with score of the last journey. 3. List the winners for each journey. 4. Insert the matches of the next journey and the date. 5. List the available stadium with the capacity. 6. List the championship standings.
Purchase answer to see full attachment