Refer to this queries for quick table creation:

CREATE TABLE tms$\_$tbl $($TeamID INT PRIMARY KEY,

Name VARCHAR$(100),$

City VARCHAR$(100),$

Founded DATE $)$;

CREATE TABLE plr$\_$tbl $($ PlayerID INT PRIMARY KEY,

Name VARCHAR$(100),$

TeamID INT,

Position VARCHAR$(50),$

Salary DECIMAL $(10,2),$

Birthdate DATE,

FOREIGN KEY $($TeamID$)$ REFERENCES tms$\_$tbI$($TeamID$))$;

CREATE TABLE gme$\_$tbl $($GameID INT PRIMARY KEY,

HomeTeamID INT,

AwayTeamID INT,

Date DATE,

HomeTeamScore INT,

AwayTeamScore INT, FOREIGN KEY $($HomeTeamID$)$ REFERENCES tms$\_$tbI$($TeamID$),$

FOREIGN KEY $($AwayTeamID$)$ REFERENCES tms$\_$tbI$($TeamID$))$;