Back to the 2024 paper
Similar questions
Database Management SystemExplain the terms ‘partial functional dependency’ and ‘transitive dependency’. Define 2NF and 3 NF in relation with these terms.20227mDatabase Management SystemConsider the universal relation R = \{A, B, C, D, E, F, G, H, I\} and the set of functional dependencies F = \{\{A, B\} \rightarrow \{C\}, \{A\} \rightarrow \{D, E\}, \{B\} \rightarrow \{F\}, \{F\} \rightarrow \{G, H\}, \{D\} \rightarrow \{I, J\}\} What is the key for R? Decompose R into 2NF, then 3NF relations.201814mDatabase Management SystemWhich of the following is true? (i) Every relation in 3NF is also in BCNF (ii) A relation R is in 3NF if very non-prime attribute of R is fully functionally dependent on every key of R (iii) Every relation in BCNF is also in 3NF (iv) No relation can be in both BCNF and 3NF20192mDatabase Management SystemConsider the relation scheme R = {E, F, G, H, I, J, K, L, M, N} and the set of functional dependencies {{E, F} → {G}, {F} → {I, J}, {E, H} → {K, L}, K → {M}, L → {N}} on R. What is the key for R? (i) {E, F} (ii) {E, F, H} (iii) {E, F, H, K, L} (iv) {E}20192m
PreviousWhich of the following ensures no data is lost after a system crash? (i) Commit log (ii) View (iii) Recovery manager (iv) TriggerNextWhich of the following is true about object-oriented databases? (i) They use tables only (ii) They allow encapsulation (iii) No support for complex data (iv) Only support numeric data