Create a database in PHPMyAdmin called WorldCup

You need to implement the schema above by creating the tables and constraints.

Your database should enforce basic constraints, such as: Referential integrity. Multiple referential integrity constraints can be extracted from the specification. Domain. Attribute values are restricted to the allowed data types. Key and Entity integrity constraints. Semantic constraints if any/as given in the Universe of Discourse.

4.2 Sample Data

Populate the database with enough meaningful sample data (at least 5 tuples per table) to allow us to test the functionality offered by your information system. This data can be made up or sourced from any websites you choose.

Provided Schema

The schema to be implemented for this part of the assignment is given below:

COUNTRY[ Name , Population]

TOURNAMENT [ Year , Country]

TEAM[ Year, ID , Country]

MEMBER[ ID , Name]

HOMECLUB[ Name, Country]

SUPPORTSTAFF[ ID , Role]

PLAYER[ ID , Position , HomeClubName ]

TEAMMEMBER [ Year, TeamID , MemberID]

MATCH [ ID , Date, Time, Stadium , Home Year, HomeTeamID, AwayYear, AwayTeamID ]

POOLGAME [ ID ]

ELIMINATIONGAME[ ID , Stage, HomePenalties, AwayPenalties]

GOALS[ PlayerID, MatchID , Count]

SAVES[ PlayerID, MatchID, Count]

CUSTOMER[ ID , Name, Email, CountryName]

TICKET[ MatchID, Ticket# , CustomerID, Price]

Foreign Keys:

TOURNAMENT .Country references COUNTRY.Name

TEAM.Country references COUNTRY.Name

TEAM.Year references TOURNAMENT .Year

SUPPORTSTAFF.ID references MEMBER .ID

HOMECLUB.Country re ferences COUNTRY.Name

PLAYER.ID references MEMBER .ID

PLAYER .HomeClubName references H OMECLUB.Name

TEAMMEMBER.(Year, TeamID) references TEAM.(Year, ID )

TEAMMEMBER.MemberID references MEMBER.ID

MATCH.(HomeYear, HomeTeamID) references Team.(Year, I D )

MATCH.(AwayYear, AwayTeamID) references Team.(Year, I D )

POOLGAME.ID references MATCH .ID

ELIMINATIONGAME.ID references MATCH .ID

GOALS.PlayerID references PLAYER.ID

GOALS.MatchID references MATCH.ID

SAVES.PlayerID references PLAYER.ID

SAVES.MatchID references MATCH.ID

TICKET.CustomerID references CUSTOMER.ID

TICKET.MatchID references M atch.ID