Create a database called FinanceDB with tables Member, Transaction, and Operation. Populate these tables using provided data.

CREATE TABLE Transaction (
    TID VARCHAR(10) PRIMARY KEY,
    TType VARCHAR(50),
    Amount DECIMAL(10, 2)
);

CREATE TABLE Operation (
    MID VARCHAR(10),
    TID VARCHAR(10),
    ODate DATE,
    PRIMARY KEY (MID, TID)
);

INSERT INTO Member (MID, MName, MAdd) VALUES
('M10', 'Mbong', 'Buea'),
('L05', 'Lyonga', 'Bamenda'),
('O20', 'Otia', 'Wum'),
('O15', 'Omar', 'Garoua'),
('S04', 'Susan', 'Douala'),
('L12', 'Linus', 'Bertoua'),
('G11', 'Gertrude', 'Yaounde'),
('T07', 'Tita', 'Maroua');

INSERT INTO Transaction (TID, TType, Amount) VALUES
('T01', 'Loan', 100000.00),
('T02', 'Savings', 50000.00),
('T03', 'Loan', 200000.00),
('T04', 'Savings', 75000.00),
('T05', 'Loan', 150000.00),
('T06', 'Savings', 120000.00),
('T07', 'Loan', 300000.00),
('T08', 'Savings', 90000.00),
('T09', 'Loan', 250000.00),
('T10', 'Loan', 50000.00),
('T11', 'Loan', 100000.00),
('T12', 'Savings', 60000.00);

INSERT INTO Operation (MID, TID, ODate) VALUES
('M10', 'T01', '2023-01-15'),
('L05', 'T02', '2023-01-20'),
('O20', 'T03', '2023-02-01'),
('M10', 'T04', '2023-02-10'),
('O15', 'T05', '2023-02-15'),
('S04', 'T06', '2023-03-01'),
('L12', 'T07', '2023-03-05'),
('G11', 'T08', '2023-03-10'),
('T07', 'T09', '2023-03-15'),
('M10', 'T10', '2023-03-20'),
('L05', 'T11', '2023-03-25'),
('O20', 'T12', '2023-04-01');

ALTER TABLE Operation
ADD CONSTRAINT FK_MID
FOREIGN KEY (MID) REFERENCES Member(MID);

ALTER TABLE Operation
ADD CONSTRAINT FK_TID
FOREIGN KEY (TID) REFERENCES Transaction(TID);

SELECT
    M.MName,
    M.MAdd,
    T.Amount,
    O.ODate
FROM
    Member AS M
JOIN
    Operation AS O ON M.MID = O.MID
JOIN
    Transaction AS T ON O.TID = T.TID
WHERE
    T.TType = 'Loan';

LoanF
+----------+-----------+----------+------------+
| MName    | MAdd      | Amount   | ODate      |
+----------+-----------+----------+------------+
| Mbong    | Buea      | 100000.00| 2023-01-15 |
| Otia     | Wum       | 200000.00| 2023-02-01 |
| Omar     | Garoua    | 150000.00| 2023-02-15 |
| Linus    | Bertoua   | 300000.00| 2023-03-05 |
| Tita     | Maroua    | 250000.00| 2023-03-15 |
| Mbong    | Buea      | 50000.00 | 2023-03-20 |
| Lyonga   | Bamenda   | 100000.00| 2023-03-25 |
+----------+-----------+----------+------------+

Operation
+-----+-----+------------+
| MID | TID | ODate      |
+-----+-----+------------+
| M10 | T01 | 2023-01-15 |
| L05 | T02 | 2023-01-20 |
| O20 | T03 | 2023-02-01 |
| M10 | T04 | 2023-02-10 |
| O15 | T05 | 2023-02-15 |
| S04 | T06 | 2023-03-01 |
| L12 | T07 | 2023-03-05 |
| G11 | T08 | 2023-03-10 |
| T07 | T09 | 2023-03-15 |
| M10 | T10 | 2023-03-20 |
| L05 | T11 | 2023-03-25 |
| O20 | T12 | 2023-04-01 |
+-----+-----+------------+