Code the PL/SQL module for:

• Trigger to enforce the referential integrity for the Transaction Ref_Nbr: (3 marks)

  • Deposit or Withdrawal transaction to Bank Branch

  • Bill Payment, Debit Purchase, or Return transaction to Merchant

Below are the tables needed for this question.

Tx_Type table will contain the code and description for the transaction.

ie. Tx_Type_Code: D, Tx_Type_Descript: Deposit

TRANSACTION TX_TYPE_LOOKUP_FK TX_TYPE Tx Type Code Tx Type Descript Tx Nbr Account Nbr Tx Type Code Tx Date Tx Amount Ref Nbr MERCHANT BANK_BRANCH Branch Nbr Branch Name Merchant Nbr Merchant_Name TRANSACTION TX_TYPE_LOOKUP_FK TX_TYPE Tx Type Code Tx Type Descript Tx Nbr Account Nbr Tx Type Code Tx Date Tx Amount Ref Nbr MERCHANT BANK_BRANCH Branch Nbr Branch Name Merchant Nbr Merchant_Name