Dears,

I have this Homework we need these requirments:

1- ER Diagram.

2- All schemas before and after normalization.

3- All SQL statements of (creating tables, inserting data in tables)

4- 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.

the description of requested database are:

A database system for football championship calendar. The database 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.