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,



Download 1.99 Mb.
Page1/5
Date21.11.2021
Size1.99 Mb.
#57743
  1   2   3   4   5
DBMS ASSIGNMENT 2

Question 1

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 2

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

privilege is a right to execute a particular type of SQL statement or to access another user's object.

Privileges perform operations like, connecting to the database, creating a table, Selecting rows from another user's table.

There are two distinct categories of privileges:

  • System Privileges


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.
  1   2   3   4   5




The database is protected by copyright ©ininet.org 2024
send message

    Main page