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.62 KiB) Viewed 34 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