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

 1REM
 2REM
 3REM Movie-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Movie(title VARCHAR2(24) NOT NULL,
 8                   year NUMBER(4) NOT NULL,
 9                   length NUMBER(4),
10                   filmtype VARCHAR2(5),
11                   studioname VARCHAR2(36) NOT NULL,
12                   producercn NUMBER(4) NOT NULL,
13       PRIMARY KEY(title, year),
14       FOREIGN KEY(studioname) REFERENCES Studio(name),
15       FOREIGN KEY(producercn) REFERENCES MovieExec(cn));