Back to the 2019 paper
Similar questions
Database Management SystemA relation is in BCNF if: (i) Every non-prime attribute depends on key (ii) Every FD is trivial (iii) Every determinant is a superkey (iv) Every attribute is atomic20252mDatabase 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) a super-key is always a candidate key. (ii) every 3NF schema is also a BCNF. (iii) generalization is bottom-up approach. (iv) none of these.20222mDATABASE MANAGEMENT SYSTEMA normal form in which every non-prime attribute is fully dependent on prime attribute is - (i) 1 NF - (ii) 2 NF - (iii) 3 NF - (iv) BCNF20237m
PreviousA level that describes how a record is stored is: (i) physical (ii) logical (iii) user (iv) viewNextConsider 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}