table.sql

CREATE TABLE Customer
(
    Cust_id     VARCHAR2(12)  NOT NULL,
    Cust_name   VARCHAR2(12),
    Cust_dob    DATE,
    Cust_street VARCHAR2(12),
    Cust_city   VARCHAR2(12)
);

CREATE TABLE Account
(
    Account_id  VARCHAR2(12)  NOT NULL,
    Balance     NUMBER(20,5),
    TYPE        VARCHAR2(8)
);

CREATE TABLE Branch
(
    Branch_name VARCHAR2(14)  NOT NULL,
    Branch_city VARCHAR2(10),
    Assets      NUMBER(20,5)
);

CREATE TABLE Employee
(
    Employee_id VARCHAR2(12),
    Employee_name   VARCHAR2(20),
    Employee_dob    DATE,
    Employee_street VARCHAR2(20),
    Employee_city   VARCHAR2(20),
    Employee_startdate DATE,
    Salary      NUMBER(10,3),
    MGR     VARCHAR2(12)
);

CREATE TABLE SALGRADE
(
    GRADE   VARCHAR2(5)  NOT NULL,
    LOSAL   NUMBER(10,3),
    HISAL   NUMBER(10,3)
);

CREATE TABLE Loan
(
    Loan_id     VARCHAR2(12)  NOT NULL,
    Amount      NUMBER(20,5)
);
CREATE TABLE RETURN
(
    Payment_id  VARCHAR2(12)  NOT NULL,
    Loan_id     VARCHAR2(12)  NOT NULL
);

CREATE TABLE Loan_return
(
    Payment_id  VARCHAR2(12)  NOT NULL,
    Payment_amount  NUMBER(20,5),
    Payment_date    DATE
);

CREATE TABLE InfoTran
(
    Transaction_id   VARCHAR2(20) NOT NULL,
    Transaction_date DATE,
    TYPE         VARCHAR2(8),
    Amount       NUMBER(20,5)
);

CREATE TABLE TRANSACTION
(
    Transaction_id   VARCHAR2(20) NOT NULL,
    Account_id   VARCHAR2(12) NOT NULL
);
CREATE TABLE Borrower
(
    Cust_id     VARCHAR2(12)  NOT NULL,
    Loan_id     VARCHAR2(12)  NOT NULL
);
CREATE TABLE Depositor
(
    Cust_id     VARCHAR2(12)  NOT NULL,
    Account_id   VARCHAR2(12) NOT NULL
);

CREATE TABLE Cust_banker
(
    Customer_id     VARCHAR2(12)  NOT NULL,
    Employee_id VARCHAR2(12)  NOT NULL
);
CREATE TABLE Loan_Branch
(
    Loan_id     VARCHAR2(12)  NOT NULL,
    Branch_name VARCHAR2(14)  NOT NULL
);