Explaining concept of referential integrity in dbms

Question

Answer the following questions.

Question 1) Write the SQL commands for Grant and Revoke. And also describe the role of stored procedures in database management system?

Question 2) Explain the use of four character functions; LOWER, UPPER, INITCAP and LENGH.

Question 3) Describe the different operations that can performed in relational algebra.

Question 4) What are indexes, Package, Cursor and Views? Describe briefly with SQL examples.

Question 5) Describe the basic operations that can perform using relational algebra. Also describe the concept of referential integrity in database management system.

Question 6) The students passing in the different subjects are as follows:

STUDENT TABLE

Write the Relational Model for the following:

(i) Determine the courses and marks of the student S901.

(ii) Determine the marks of the students who have opted for the course C20.

Question 7) What are various types of normalization? Also describe the difference between BCNF and 3^rd NF briefly.