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

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