Question given relation r (A,B,C,D) and the following fd’s. Identify the candidate key for r and highest normal form b->C, d->a question Consider the universal relation R= {A,
Consider the universal relation R= {A,B,C,D,E,F,G,H,I,J} and a set of functional dependencies F= { {AB→ C}, { A → DE}, { B→ F}, {F→ GH}, {D→ IJ}}. What is the key for R? Decompose R into 2NF, then 3NF relations.
Question 3
Give PL/SQL example for the following attributes of cursor
%rowcount
%notfound
Question 4
Enumerate the types of privileges available in SQL.
Privileges
A privilege is a right to execute a particular type of SQL statement or to access another user's object.
A system privilege is the right to perform a particular action, or to perform an action on any schema objects of a particular type. For example, the privileges to create tablespaces and to delete the rows of any table in a database are system privileges. There are over 60 distinct system privileges.
You can grant or revoke system privileges to users and roles. If you grant system privileges to roles, then you can use the roles to manage system privileges. For example, roles permit privileges to be made selectively available.
