Notes

-- Create Database


CREATE DATABASE BankDB;
USE BankDB;

-- Create Tables
CREATE TABLE Customer (
customer_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
address VARCHAR(100),
phone_number VARCHAR(15)
);

CREATE TABLE Account (
account_id INT PRIMARY KEY AUTO_INCREMENT,
customer_id INT,
account_type VARCHAR(10),
balance DECIMAL(10, 2),
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id)
);

CREATE TABLE Branch (
branch_id INT PRIMARY KEY AUTO_INCREMENT,
branch_name VARCHAR(50),
branch_address VARCHAR(100)
);

-- Insert Data
INSERT INTO Customer (name, address, phone_number)
VALUES ('John Doe', '123 Main St', '555-1234'),
('Jane Smith', '456 Oak St', '555-5678');

INSERT INTO Account (customer_id, account_type, balance)
VALUES (1, 'Savings', 5000.00),
(2, 'Checking', 3000.00);

INSERT INTO Branch (branch_name, branch_address)
VALUES ('Main Branch', '789 Elm St'),
('West Branch', '101 Pine St');

-- Query Data
SELECT * FROM Customer;

SELECT a.account_id, a.account_type, a.balance, c.name
FROM Account a
JOIN Customer c ON a.customer_id = c.customer_id;


select now(), database(), user();