Back to the 2022 paper
Similar questions
Database Management SystemBriefly explain the ACID property of database system.20187mDatabase Management SystemIn ACID properties, which component ensures that once a transaction is committed, it remains so? (i) Atomicity (ii) Durability (iii) Isolation (iv) Consistency20242mDATABASE MANAGEMENT SYSTEMExplain ACID properties.20247mDatabase Management SystemExplain the different integrity constraints in database system with the help of example.20187m
PreviousRelation 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?NextConsider the transactions T1, T2 and T3 and schedules S1 and S2 given below: T1 : r1 (X); r1(Z); w1 (X); w1 (Z), T2 : r2 (Y); r2 (Z); w2 (Z) T3 : r3 (Y); r3 (X); w3 (Y) S1 : r1 (X); r3(Y); r3(X); r2 (Y); r2(Z); w3(Y); w2 (Z); r1 (Z); w1(X), w1 (Z). S2 : r1 (X); r3 (Y); r2(Y); r3(X); r1(Z); r2(Z); w3 (Y); w1 (X); w2(Z), w1 (Z). Determine which of the above schedules are conflict – serializable.