CREATE TABLE dept(
ND int(11) NOT NULL,
NOM varchar(14),
VILLE varchar(13),
PRIMARY KEY(ND)
) ;
CREATE TABLE emp (
NE int(11) NOT NULL,
NOM varchar(10),
JOB varchar(9),
DATEMB date,
SAL float(7,2),
COMM float(7,2),
ND int(11),
NEchef int(11),
PRIMARY KEY(NE),
FOREIGN KEY(ND) REFERENCES dept(ND),
FOREIGN KEY(NEchef) REFERENCES emp(NE)
);
On considère les tables suivantes :
id | player |
---|---|
1 | Adam |
2 | Boris |
3 | Christopher |
4 | Dennis |
id |
player1 | player2 | date | winner |
---|---|---|---|---|
1 | 1 | 2 | 2007-07-03 | 1 |
2 | 2 | 4 | 2008-01-04 | 4 |
3 | 2 | 3 | 2008-03-22 | 2 |
4 | 1 | 4 | 2008-05-21 | 4 |