Q6. (10 Points) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J) and the set of functional dependencie

[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 23 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