Answered step by step
Verified Expert Solution
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started