Yurttas/PL/DBL/oracle/F/01/Bank/Depositor-def.sql

 1REM
 2REM
 3REM Depositor-def.sql
 4REM
 5REM
 6
 7CREATE TABLE Depositor(branchname VARCHAR2(16) NOT NULL,
 8                       accountnumber NUMBER(4) NOT NULL,
 9                       customername VARCHAR2(16) NOT NULL,
10                       balance NUMBER(8),
11           PRIMARY KEY(accountnumber),
12           FOREIGN KEY(branchname) REFERENCES Branch(branchname),
13           FOREIGN KEY(customername) REFERENCES Customer(customername));