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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 26, 2024

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

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

image text in transcribed

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