Untitled

mail@pastecode.io avatarunknown
plain_text
a month ago
712 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 depositor(
customerName varchar(100) ,
accountNumber varchar(100),
primary key(customerName, accountNumber));

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 borrower(
customerName varchar(100) ,
loanNumber varchar(100),
primary key(customerName, loanNumber));