online resources online resources see the following online resources for more information on the python database apilibrary exercises in this exercise you will create database and tables based on set of transactions stored in current account you can use the account class you created in the csv and excel for this you will need two tablesone for the account information and one for the transaction history the primary key of the account information table can be used as the foreign key for the transaction history table then write function that takes an account object and populates the tables with the appropriate data to create the account information table you might use the following ddlcreate table acc_info (idacc_info int not nullname varchar( not nullprimary key (idacc_info)while for the transactions table you might usecreate table transactions (idtransactions int not nulltype varchar( not nullamount varchar( not nullaccount int not nullprimary key (idtransactions))remember to be careful with integers and decimals if you are creating an sql string such asstatement "insert into transactions (idtransactionstypeamountaccountvalues (str(id"'action "'str(amount"str(account_number")