Back to the 2022 paper
Similar questions
DATABASE MANAGEMENT SYSTEMWhich key cannot be null - (i) Unique key - (ii) Primary key - (iii) Super key - (iv) Foreign key20237mDatabase 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 SystemKey to represent relationship between tables is called (i) primary key (ii) secondary key (iii) foreign key (iv) None of the above20202mDatabase 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 normal form is considered adequate for normal relational database design? (i) 2 NF (ii) 5 NF (iii) 4 NF (iv) 3 NFNextConsider R (A, B, C, D, E) with following FDs:- A → B, A → C, CD → E, B → D, E → A which of the following FDs is not implied by above set? (i) CD → AC (ii) BD → CD (iii) BC → CD (iv) AC → BC