Untitled

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