Description
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)
