Description
i. Write command and execute and paste screen shots and make a pdf. You need to show screen shot to demonstrate the correctness of your code/query. ii. Submit one file .pdf file containing all answers. The name should be _assignment.pdf iii. Write the questions before the answers. iv. Write a justification of your solution. v. The code should be executable and show output. ____________________________________________________________________________ A. Do following tasks using University Database:- (1.5) a. Check if the event scheduler is ON. If not on, then set it ON. b. Create an event to increment budget of all departments by 5% after 1 minute. c. Show the details of the events in an easy to read format. d. Modify the above event so that, it will increment budget of all departments by 100 in every minute for next 5 minutes. B. Do Following Tasks:- (1.5) a. Set profiling ON b. Show list of processes running in your DB. c. Import database from “largeRelationsInsertFile.sql” and execute following queries and point out the bottlenecks (most costly task in terms of space and time). i. select all departments having budget greater than 50000. ii. fetch details of students from the student table whose name is ‘wood’. C. Create a trigger that will not allow to enter any record into the takes table with a grade that is not used before in any record in the takes table. (2)
