Answer the following problems.
problem 1) prepare the SQL commands for Grant and Revoke. And also describe the role of stored procedures in database management system?
problem 2) describe the use of four character functions; LOWER, UPPER, INITCAP and LENGH.
problem 3) Describe the different operations that can performed in relational algebra.
problem 4) What are indexes, Package, Cursor and Views? Describe briefly with SQL exs.
problem 5) Describe the basic operations that can perform using relational algebra. Also describe the concept of referential integrity in database management system.
problem 6) The students passing in the different subjects are as follows:
prepare 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.
problem 7) What are various types of normalization? Also describe the difference between BCNF and 3rd NF briefly.