Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
742 B
2
Indexable
Never
create table branch(
    branchName varchar(100) primary key,
    branchCity varchar(100),
    assets varchar(100));

create table account(
    accountNumber varchar(100) primary key,
    branchName varchar(100),
    balance varchar(100));

create table customer(
    customerName varchar(100) primary key,
    customerStreet varchar(100),
    customerCity varchar(100));

create table loan(
    loanNumber varchar(100) primary key,
    branchName varchar(100),
    amount varchar(100));

create table depositer(
    customerName varchar(100),
    accountNumber varchar(100),
primary key(customerName, accountNumber));

create table borrower(
    customerName varchar(100),
    loanNumber varchar(100),
primary key(customerName, loanNumber));