Notes

USE db_bank_kazi;
CREATE TABLE Customer (
customer_id INTEGER PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
address VARCHAR(100),
phone_number VARCHAR(15)
);

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

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

INSERT INTO Customer (name, address, phone_number) VALUES
('Kazi', '123 Dhaka', '01748461142'),
('Sunny', 'Sylhet 1200', '01848486570');

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

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

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;