Page 1 of 1
Q6. (10 Points) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J) and the set of functional dependencie
Posted: Fri May 20, 2022 2:54 pm
by answerhappygod
- Q6 10 Points Consider The Universal Relation R A B C D E F G H I J And The Set Of Functional Dependencie 1 (49.96 KiB) Viewed 24 times
Q6. (10 Points) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J) and the set of functional dependencies F = {{A, B}-> {C}, {A}->{D, E}, {B}-> {F}, {F}-> {G,H}, {D} -> {I,J}. What is the candidate key? Show the detail work. Q7. (10 Points) a. All candidate keys are super key. True/False b. Establishing Foreign key helps in retrieving data faster. True/False c. You can use shared locks to avoid deadlock issue. True/False d. Using % in the where clause speed ups the query. True/False e. Order by is always associated with aggregation. True/False f. Tuples are fields whereas records are columns. True/False g. You can use the same field in multiple indexes unless it is a PK. True/False