State the appropriate data type of MID and ODate. Create a database called FinanceDB and populate it with the given data.

Here are the solutions for the remaining parts of Task A1.

4. State the appropriate data type of MID and ODate.

• MID: VARCHAR(10) (or CHAR(3) if all IDs are 3 characters long, but VARCHAR is more flexible for alphanumeric IDs of varying lengths).
• ODate: DATE

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.

Here are the SQL commands to create the database, tables, and populate them.

Step 1: Create the FinanceDB database.

CREATE DATABASE FinanceDB;
USE FinanceDB;