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