With reference to the given diagram, please perform the following:

STEP 1: Design / Create a database with Files and File groups. Assume size is 100 MB per file for now. STEP 2: Design / Create Tables with appropriate columns, provide correct/relevant data types and keys. Include Schemas for ease of access (as and where needed). STEP 3: Define Relations between the tables (based on the arrow marks in the given schema) STEP 4: Insert some data in each table (minimum of 3 to 10 values in each table) based on the relations. This way you would easily verify the correctness of if the data type for each column.

/**** PHASE 1 ****/

STEP 1: CREATE DATABASE WITH FILES & FILEGROUPS STEP 2: CREATE SCHEMAS ON ABOVE DATABASE STEP 3: CREATE TABLES USING ABOVE SCHEMAS STEP 4: DEFINE RELATIONS USING ABOVE TABLES AND SCHEMAS STEP 5: ADD SAMPLE DATA INTO EACH TABLES TO VERIFY DATA TYPES TO VERIFY RELATIONS

Banks Bank_ID Bank_Details PHASE 3: DATA INSERTS: DYNAMIC TO TABLES TO VIEWS USING SPS, TRIGGERS PHASE 1: DB CREATION, TABLE CREATION, TEST DATA INSERTION PHASE 2: POSSIBLE JOINS, VIEWS, POSSIBLE COMPUTATIONS REVIEW Addresses Address_ID Line_1 Line 2 Town_Cty Zip_Postcode State_Province_County Country Other_Details Branches Branch_ID Address_ID Bank_ID Branch Type_Code Branch_Details Ref_Branch Types Branch_Type_Code Branch_Type_Description eg Large Urban, Smal Rural Customers Customer JO Address_ID Branch_10 Personal Details Contact Details Ref_Transaction_Types Transaction_Type_Code Transaction_type_Description eg Deposit, Withdrawal Ref_Account_Status Account Status_Code Account_Status_Description eg Active, Closed Transactions Transaction_ID Account Number @@@@ Ref_Account_Types * Account_Type_Code Account Type Description eg Checking, Savings etc. Accounts Account_Number Account_Status_code Account_Type_Code - Customer D Current_Balance Other_Detals FX Transaction_type_Code Transaction Date_Time Transaction Amount Other_Details