Yurttas/PL/DBL/oracle/F/01/Movie/StarsIn-def.sql

 1REM
 2REM
 3REM StarsIn-def.sql
 4REM
 5REM
 6
 7CREATE TABLE StarsIn(title VARCHAR2(24) NOT NULL,
 8                     year NUMBER(4) NOT NULL,
 9                     name VARCHAR2(24) NOT NULL,
10         PRIMARY KEY(title, year, name),
11         FOREIGN KEY(title, year) REFERENCES Movie(title, year),
12         FOREIGN KEY(name) REFERENCES MovieStar(name));