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
iii. Write the questions before the answers.
iv. Write a justification of your solution.
v. The code should be executable and show output.
Vi. Use University Database to do the following tasks
____________________________________________________________________________
A. Create a variable avg_cred to store the average of total credits of students. Show
names of the students with total credit more than twice the average of total credits
using variable avg_cred.[1]
B. show the details of the departments which have budgets more than the average
budget across all departments. First show it without defining any function, then
show it by defining a function avg_budget that return average budget across all
departments.[1]
C. Create a procedure top_budg that when called will accept a number N and return
budgets of top N departments. Use N=3 and N=5 to verify your procedure.[1]
D. Create a procedure which will be used by a system admin whenever a new student
joins. The procedure will create a view such that, each student can see details of
all students except their total credit, but the student can see all information about
him/her. Demonstrate this procedure with examples[atleast 2 examples].[2]
