Yurttas/PL/DBL/mssql/F/01/Movies/StarsIn-cre.sql

 1/*
 2REM
 3REM
 4REM StarsIn-cre.sql
 5REM
 6REM
 7*/
 8
 9CREATE TABLE StarsIn(title VARCHAR(24) NOT NULL,
10                     year INTEGER NOT NULL,
11                     name VARCHAR(24) NOT NULL,
12         PRIMARY KEY(title, year, name),
13         FOREIGN KEY(title, year) REFERENCES Movie(title, year),
14         FOREIGN KEY(name) REFERENCES MovieStar(name));