ZXC

-- Create the tables
CREATE TABLE customer (
    customer_id INT PRIMARY KEY,
    customer_name VARCHAR(50),
    balance DECIMAL(10, 2)
);

CREATE TABLE customer_detail (
    customer_id INT,
    address VARCHAR(100),
    phone_number VARCHAR(20),
    FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
);

CREATE TABLE mini_statement (
    customer_id INT,
    transaction_date DATE,
    amount DECIMAL(10, 2),
    description VARCHAR(100),
    FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
);

CREATE TABLE micro_statement (
    customer_id INT,
    transaction_id INT,
    transaction_date DATE,
    amount DECIMAL(10, 2),
    description VARCHAR(100),
    FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
);

CREATE TABLE deleted_customer (
    customer_id INT,
    deleted_date DATE,
    reason VARCHAR(100),
    FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
);

-- Insert data into the customer table
INSERT INTO customer VALUES (100, 'Manu', 12000);
INSERT INTO customer VALUES (101, 'Remya', 2500);
INSERT INTO customer VALUES (102, 'Anu', 13500);
INSERT INTO customer VALUES (103, 'Sonu', 10000);
INSERT INTO customer VALUES (104, 'Achu', 12500);