[lmikle]

Ну и в чем проблема?

Код:

CREATE TABLE Clubs (
ID INTEGER PRIMARY KEY,
Name VARCHAR(100) NOT NULL,
City VARCHAR(100) NOT NULL
);

CREATE TABLE Seasons (
ID INTEGER PRIMARY KEY,
ClubID INTEGER REFERENCES Clubs(ID),
SeasonYear VARCHAR(4),
Points INTEGER
);