Yurttas/PL/DBL/oracle/F/01/Bank/Borrower-def.sql
Jump to navigation
Jump to search
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));