Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IBIBCbank aims to automate banking transactions after the demonetization. They consulted IT sector to implement PLSQL block which performs deposit and withdraw operation. Mr .

IBIBCbank aims to automate banking transactions after the demonetization. They consulted IT sector to implement PLSQL block which performs deposit and withdraw operation. Mr.Sam created an Oracle PLSQL procedure that performs money deposits. He wants to create a withdrawal procedure in oracle pl/sql. Help him by writing the procedure which performs withdrawal for the given relation table. The procedure is taking two arguments: first argument is the account number, second argument is the amount to be withdrawn. The minimum balance to be maintained is 1000. Update the Account table, after transaction and create an entry in Transaction table, after each successful transaction. In Transaction table, TransactionType is "withdrawal" for withdrawal operation. Account (AccNo, BranchName, BalanceAmount). Transaction (AccNo, TransactionDate, TransactionType, AmountWithdrawn , BalanceAmount)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Structure Of The Relational Database Model

Authors: Jan Paredaens ,Paul De Bra ,Marc Gyssens ,Dirk Van Gucht

1st Edition

3642699588, 978-3642699580

More Books

Students also viewed these Databases questions

Question

For what is HTTP used? What are its major parts?

Answered: 1 week ago

Question

What are the APPROACHES TO HRM?

Answered: 1 week ago