Create the FinanceDB database and select it for use.

Okay, nkemdivo, let's continue with the database tasks.

5. Using an appropriate database management system, create a database called FinanceDB containing the three tables defined above. Populate all the tables taking data from Table 1 above.

Step 1: Create the FinanceDB database and select it for use.

CREATE DATABASE FinanceDB;
USE FinanceDB;

Step 2: Create the Member table.

CREATE TABLE Member (
    MID VARCHAR(10) PRIMARY KEY,
    MName VARCHAR(50),
    MAdd VARCHAR(50)
);

Step 3: Create the Transaction table.

CREATE TABLE