Back to the 2022 paper
Similar questions
Database Management SystemFor relation: R(A,B,C); FDs={A \rightarrow B, B \rightarrow A}. Which statement is true? (i) A and B both are candidate keys (ii) Only A is key (iii) Only B is key (iv) Neither A nor B is key20252mDATABASE MANAGEMENT SYSTEMFind the highest normal form of a relation R(ABCD) with FD set (B→A, A→C, BC→D, AC→BE).20247mDATABASE MANAGEMENT SYSTEMA relation R(A,C,D,E,H) is having two functional dependencies sets F={A→C, AC→D, E→AD, E→H} and set G {AC→D, E→AH}, then check F and Gare equivalent or not.20247mDatabase Management SystemRelation R (ABCDEFGH) contains only atomic values for all of its attributes. F = {CH → G, A → BC, B → CFH, E → A, F → EG} is a set of functional dependencies (FDs) so that F is exactly the set of FDs that hold for R. (i) Find all the candidate keys the relation R have? (ii) Find the highest normal form with justification in which R exist?20227m
PreviousWhich of the following is not a super key in R(V, W, X, Y, Z) with primary key VY? (i) VXYZ (ii) VWXZ (iii) VWXY (iv) VWXYZNextWhich of the following is a concurrency control protocol. (i) Strict 2-phase locking protocol (ii) Timestamp based protocol (iii) Graph based protocol (iv) All of the above