InterviewSolution
Saved Bookmarks
| 1. |
Which of the option(s) is/are correct ?Note – This question is multiple select questions (MSQ).(A) Relation R have attributes {a1, a2, a3,…,an} can have maximum number of super keys are 2(n-1)(B) Relation R have attributes {a1, a2, a3,… ,an} and the candidate key is “a1 a2 a3” then the possible number of super keys are 2(n-3).(C) A relation R(A, B, C, D, E, F, G, H) with set of functional dependencies {CH → G, A → BC, B → CFH, E → A, F → EG} has 120 superkeys.(D) The maximum number of superkeys for the relation schema R(E,F,G,H) with E as the key is 4. |
| Answer» | |