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 ...

Question: 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

Code the PL/SQL module for: Trigger to enforce the referential integrity for

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I will thumbs up definitely, if you solve this correctly! PL/SQL code ( 10 marks ) Code the PL/SQL module for each of the following: Trigger to enforce the referential integrity for the Transaction...

Narrative Description The National Bank of Erehwon handles money and maintains bank accounts on behalf of clients. A client is a person who does business with the bank. A client may have any number...

The National Bank of Erehwon handles money and maintains bank accounts on behalf of clients. A client is a person who does business with the bank. A client may have any number of accounts, and an...

Do not copy and paste from the other solutions To facilitate queries, three views are required. Answer SQL script(s) as well as a SELECT * FROM listing of each view. Join of Transaction to Type...

You previously completed an assignment for me and forgot to answer the question below. 2. REVIEW THE CHAIRMAN?S LETTER TO THE SHAREHOLDERS. Summarize the major points made in the letter. Use complete...

I have attached both the chapters from which you will be answering the following question. Ch 8 (p 387 of text or p 35 of the pdf) ?Exercise D. Prepare the bank reconciliation and any required...

Kindly provide answer and supporting workings for Qn 1b & Qn 3a,3b for ACC217. ACC217 Accounting Information Systems Assignment 2 - Group-based Assignment January 2017 Presentation ACC217 Assignment...

MINI-PROJECT Implement a Software-Engineering Process stages by selecting any topic which is mention below or you can select your desired any other topic. Website Administration Airport checking-in...

Computerized Accounting with Sage 50 Level 1 Chris's Welding INTRODUCTION This project will test your understanding of the Sage 50 Accounting application and your ability to apply the features of...

OVOU 7. Did they withdraw more than they deposited POMA1 nanas If yes, how much more? 8. Give advice on how this person could save more money, W Making it Balance Worksheet For the purpose of your...

Write a paper on Google Cloud Services

When Deana Byers married Steven Byers, she was pregnant with another mans child. Shortly after the marriage, Deana gave birth. The marriage lasted only two months, and the couple separated. In...

Suppose you believe in the efficient markets hypothesis. Which of the following is true? a . You do not believe that there is positive relationship between risk and return. b . You believe that stock...

Propane is oxidized in a continuous reactor according to the following reaction: C3H8(g)+502(g) 3002(g)+4H20() The reactor is fed 100 mol/s of propane at 25 C and an air current at 200 C that ensures...

How do Data Types perform data validation?

How does Referential Integrity work?

What are Dimensional Relational Databases designed to hold primarily?