setup_database.sql

CREATE TABLE IF NOT EXISTS Customer (
    Cust_ID INT AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(50),
    Address VARCHAR(100),
    Phone VARCHAR(15),
    DOB DATE
);

CREATE TABLE IF NOT EXISTS Account (
    Acc_Number INT AUTO_INCREMENT PRIMARY KEY,
    Acc_Type VARCHAR(20),
    Balance DECIMAL(10,2),
    Cust_ID INT,
    FOREIGN KEY (Cust_ID) REFERENCES Customer(Cust_ID)
);


CREATE TABLE IF NOT EXISTS TransactionTbl (
    Trans_ID INT AUTO_INCREMENT PRIMARY KEY,
    Date DATETIME,
    Amount DECIMAL(10,2),
    Type VARCHAR(20),
    From_Acc INT,
    To_Acc INT
);


INSERT INTO Customer (Name, Address, Phone, DOB) VALUES
('Kirtan', 'Mumbai', '9876543210', '2004-08-26'),
('Aayush', 'Delhi', '9988776655', '2003-05-10'),
('Riya', 'Pune', '9123456780', '2004-01-15');


INSERT INTO Account (Acc_Type, Balance, Cust_ID) VALUES
('Savings', 5000.00, 1),
('Current', 2000.00, 1),
('Savings', 8000.00, 2),
('Savings', 10000.00, 3);


INSERT INTO TransactionTbl (Date, Amount, Type, From_Acc, To_Acc) VALUES
(NOW(), 500, 'Transfer', 1, 2),
(NOW(), 200, 'Transfer', 3, 4);


SELECT 'Customers:' as Info;
SELECT * FROM Customer;

SELECT 'Accounts:' as Info;
SELECT * FROM Account;

SELECT 'Transactions:' as Info;
SELECT * FROM TransactionTbl;