AndyWangSFU/Database-Design---FootballHome

In this simple database design practice, we plan to design a database called "FootballHome" for football fans to help them look up relative football information. It could be widely used in almost all football matches related web applications or football fans forum. Some examples of entity sets are: Matches (gameDate, location, Teams), Football Team (TeamName, country, founded) and Team Players (name, height, position). Typical real-world constraints are like gameDate is past (we do not plan for future) and there should be only one head-coach for each team. Suppose you are a football fans. Through this application you can search relative information on your favorite team (honours, headcoach, history, etc), information on team players including retired players and past matches. You can also add or modify the information as long as they are truth and legal (using triggers to detect inputs).

Jupyter Notebook