Related questions
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 account may belong to multiple clients (e.g., spouses, business partners).
-
The client record is used for identification and contact data.
-
For each account, the bank maintains the current balance on hand.
-
Clients are identified by a five digit number starting with 10001.
-
Accounts are identified by a seven digit number starting with 1000001.
When an account is first opened, its balance is set to zero. During the course of day-to-day business, Erehwon Bank applies transactions to accounts, including deposits, withdrawals, bill payments, and debit purchases or returns. For each transaction, the date and time, amount, and account are recorded, along with reference data applicable to that type of transaction:
-
Deposits and withdrawals require the branch number to be recorded.
-
Bill payments, and debit purchases or returns require the merchant number.
Code the PL/SQL module for each of the following:
-
Trigger to enforce the referential integrity for the Transaction Ref_Nbr:
-
Deposit or Withdrawal transaction to Bank Branch
-
Bill Payment, Debit Purchase, or Return transaction to Merchant
-
- Trigger to update the Account balance for each new transaction entered (assume that a transaction will never be updated or deleted).
-
A procedure that displays a nicely formatted audit statement for a given account number (as a parameter). This will show each transaction in date / time sequence along with the running balance.
To test that the triggers are correctly implemented, do the following:
-
Truncate the Transaction table
-
Reset the Tx_Nbr sequence back to 1
-
Update the Account table, setting the Balance back to zero
-
Re-run the INSERT statements for the transactions
-
Use simple queries to demonstrate that the results in the Transaction and Account tables are as expected
| TX_TYPE | |||
| Code | Description | ||
| D | Deposit | ||
| W | Withdrawal | ||
| B | Bill Payment | ||
| P | Purchase | ||
| R | Return | ||
| BRANCH | |||
| Nbr | Name | ||
| 101 | … make up your own name | ||
| 102 | … make up your own name | ||
| 103 | … make up your own name | ||
| 104 | … make up your own name | ||
| MERCHANT | |||
| Nbr | Name | ||
| 301 | … make up your own name | ||
| 302 | … make up your own name | ||
| 303 | … make up your own name | ||
| 304 | … make up your own name |
Step by stepSolved in 2 steps
- When a validation rule is violated, Access displays the text in the Validation Text property box. Why is it important that this text is helpful to the user?arrow_forwardAn attribute controls most form controls' display during programme execution.arrow_forwardTitle System Requirements 4. Hotel Management System You are asked to build an application used in Hotels by hotel's receptionist Modules Reservations and Guest module: . ● . The receptionist should be able to enter the guest's data (name, age, ID number, check in date, check out date, deposit left by the guest.... etc.). You are supposed to have in your hotel different classes of rooms and also of guests. On opening the application, it should display a list of the guests whose checkout date is within less than one day. When entering a new guest, the application should display all the available rooms with their data (room number, number of beds, .... etc.). Additional services module: The receptionist should be able to enter the data of any additional services used by the guest (gym, SPA, Safari, glass boat, transportation......etc.). Any additional services used by the guest should be added automatically to the total cache that will be paid at the end of the residence period.arrow_forward
- Select the if statement that assigns .2 to commissionRate if the monthlySales is greater than 10000. if monthlySales > 10000: .2 = commissionRate if monthlySales > 10000: commissionRate if monthlySales > 10000 commissionRate .2 if monthlySales > 10000: commissionRate == .2arrow_forwardWhat is the capitalisation of a book title?arrow_forwardWhat is the capitalisation of a book title?arrow_forward
- Instructions You are working as a computer programmer for a mortgage company that provides loans to consumers for residential housing. Your task is to create an application to be used by the loan officers of the company when presenting loan options to its customers. The application will be a mortgage calculator that determines a monthly payment for loans and produces an amortization schedule for the life of the loan. The company offers 10-, 15-, and 30-year fixed loans. Inputs The program should initially prompt the user (the loan officer) for the principal of the loan (i.e. the amount that is being borrowed). It should then ask him or her to enter an annual interest rate for the loan. The final input should be the number of years that the loan will be outstanding. Because the company only offers three different terms (10-, 15-, and 30-year loans), the program should ensure that no other terms are entered. Payment Calculator The formula to calculate the monthly payment for a fixed…arrow_forwardusing Java GUI Interface languagearrow_forwardTools for validators should be specified.arrow_forward
- please helparrow_forwardTitle System Requirements 4. Hotel Management System You are asked to build an application used in Hotels by hotel's receptionist Modules Reservations and Guest module: . ● . The receptionist should be able to enter the guest's data (name, age, ID number, check in date, check out date, deposit left by the guest.... etc.). You are supposed to have in your hotel different classes of rooms and also of guests. On opening the application, it should display a list of the guests whose checkout date is within less than one day. When entering a new guest, the application should display all the available rooms with their data (room number, number of beds, .... etc.). Additional services module: The receptionist should be able to enter the data of any additional services used by the guest (gym, SPA, Safari, glass boat, transportation......etc.). Any additional services used by the guest should be added automatically to the total cache that will be paid at the end of the residence period.arrow_forwardSQL PROGRAM Create a function that takes Celsius temperature and returns a Fahrenheitarrow_forward
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSON
Computer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier Science
Network+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning 
Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage Learning
Prelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson Education
Sc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY