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 3 ****/

STEP 8: PLAN FOR DATA INSERT INTO EACH TABLE CONSIDERING OTHER RELATED TABLES FOR TRANSACTIONAL DATA OPERATIONS EX: WHENEVER NEW BANK BRANCH IS INCLUDED, ITS ADDRESS, TYPE AND BANK ASSOCIATIONS NEEDS TO BE ADDRESSES : SPs, TRIGGERS WITH JOINS AND TXNs

STEP 9: PLAN FOR POSSIBEL COMPUTATIONS IN TRIDITIONAL BANKING SYSTEM

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