created four tables (account_details,branch_details,customer_details,transaction_details) in which account_details is in one to one relationship with branch_details & customer_details and account_details is also in one to one relationship where transaction_details table is with one to many relationship with account_details table and created API for getting the data as per account number .