viYzaafD

1DROP TABLE IF EXISTS film;
2DROP TABLE IF EXISTS actorfilm;
3DROP TABLE IF EXISTS actor;
4
5CREATE TABLE actor (
6    actorNo INT NOT NULL,
7    actorName VARCHAR(50),
8    dob DATE,
9    death DATE,
10    filmName VARCHAR(100),
11    PRIMARY KEY(actorNo),
12    FOREIGN KEY (filmName) REFERENCES film(filmName)
13);
14
15CREATE TABLE actorfilm (
16    actorNo INT NOT NULL,
17    filmName VARCHAR(100),
18    PRIMARY KEY(actorNo,filmName)
19);
20
21CREATE TABLE film (
22    filmName VARCHAR(100),
23    filmDate DATE,
24    actorNo INT NOT NULL,
25    PRIMARY KEY (filmName)
26    FOREIGN KEY (actorNo) REFERENCES actor(actorNo)
27);