Yurttas/PL/DBL/oracle/F/01/Movie/StarsIn-def.sql
Jump to navigation
Jump to search
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));