11. Which ONE of the following threats does not cause loss of integrity? ( ) Program alteration. ( ) Wire tapping. ( ) Electronic interference and radiation. ( ) Data corruption due to power loss or surge. 12. What type of functional dependency is present in the following dependencies? staffNo -> sName, position, salary, branchNo, bAddress branchNo -> bAddress ( ) Partial functional dependency ( ) Transitive dependency ( ) Determinant dependency ( ) Partial transitive dependency 13.Consider the following set of functional dependencies on a relation R(A, B, C).
11. Which ONE of the following threats does not cause loss of integrity?
( ) Program alteration.
( ) Wire tapping.
( ) Electronic interference and radiation.
( ) Data corruption due to power loss or surge.
12. What type of functional dependency is present in the following dependencies?
staffNo -> sName, position, salary, branchNo, bAddress
branchNo -> bAddress
( ) Partial functional dependency
( ) Transitive dependency
( ) Determinant dependency
( ) Partial transitive dependency
13.Consider the following set of functional dependencies on a relation R(A, B, C).
A->BC
B->C
A->B
AB->C
14. The minimal set of functional dependencies is
( ) A->BC and B->C
( ) A->BC and AB->C
( ) A->BC and A->B
( ) A->B and B->C
15. Why can unary operations and set operations nest with each other?
( ) because a set operation of relational algebra can be viewed as nested unary operations.
( ) because output from one operation is a relation, which can become input to another operation.
( ) because the output from nested set operations must be input into a unary operation.
( ) because output of set operations is always equal to the output of nested unary operations.
Step by step
Solved in 3 steps
