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));