Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write Procedural code for SQL, MYSQL DBMS, to perform the following tasks and submit your code in one PDF file with enough comments. 1)

Write Procedural code for SQL, MYSQL DBMS, to perform the following tasks and submit your code in one PDF file with enough comments. 1) Create a function that will return the second maximum salary, integer attribute, from the Employees table, where the table schema is Employees(eid, ename, dno, job, salary). You have to use CURSOR to solve this task. 2) Create a trigger that will archive the update process on the customer s' balance, in Customer table, only into the BalanceUpdate table. The trigger will not archive any update of the other attributes in the Customer table. For your solution consider the following schemas: - Customer(cid, cname, caddress, accountNo, accountType, balance) - BalanceUpdate(user, updateTime, cid, accountNo, oldBalance, newBalance)

Step by Step Solution

3.42 Rating (165 Votes )

There are 3 Steps involved in it

Step: 1

1 fuction secondMaxsalary local sql SELECT salar... 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

Quantitative Analysis for Management

Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha

12th edition

133507335, 978-0133507331

More Books

Students also viewed these Programming questions

Question

Why is the central limit theorem so important in quality control?

Answered: 1 week ago