week 1

CREATE TABLE Customer (
	customerName VARCHAR(25) PRIMARY KEY,
	street VARCHAR(25),
	customerCity VARCHAR(25));

CREATE TABLE Branch (
	branchName VARCHAR(25),
	branchCity VARCHAR(25),
	Assets DECIMAL(10,2) DEFAULT 0,
	PRIMARY KEY (branchName));


CREATE TABLE Deposit (
	customerName VARCHAR(25),
	branchName VARCHAR(25),
	accountNumber INT PRIMARY KEY,
	balance INT,
	FOREIGN KEY (branchName) REFERENCES Branch(branchName),
	FOREIGN KEY (customerName) REFERENCES Customer(customerName));
	

CREATE TABLE Loan (
	amount INT,
	loanNumber INT,
	branchName VARCHAR(25),
	customerName VARCHAR(25),
	PRIMARY KEY (loanNumber),
	FOREIGN KEY (branchName) REFERENCES Branch(branchName),
	FOREIGN KEY (customerName) REFERENCES Customer(customerName));

INSERT INTO Branch (branchName, Assets, branchCity)
VALUES ('Yorkshire', 10000, 'Nottingham');