DBMS

[GATE 2015 (Set-3) : 2 M]5.21: Consider the following partial Schedule S involving two transactions T1 and T2. Only the read and the write operations have been shown. The read operation on data item P is denoted by read(P) and the write operation on data item P is denoted by write(P).Schedule:Time instance 1: T1 –

5.1 [GATE 1999 : 2 Marks] For the schedule given below, which of the following is correct?1 Read A2 Read B3 Write A4 Read A5 Write A6 Write B7 Read B8 Write B(a) This schedule is serializable and can occur in a scheme using 2PL protocol.(b) This schedule is serializable but cannot occur in a

2.51 [GATE 2021 Set-2 : 2 Marks] Question:Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S and T:P -> QRRS -> TWhich of the following functional dependencies can be inferred from the above?(a) PS -> T(b) P -> R(c) R -> T(d) PS -> Q Answer: (a) PS

2.26 [GATE 2006 : 2 Marks] Question:The following functional dependencies are given: AB -> CD, AF -> D, DE -> F, C -> G, F -> E, G -> A. Which one of the following options is false?(a) {CF}+ = {ACDEFG}(b) {BG}+ = {ABCDG}(c) {AF}+ = {ACDEFG}(d) {AB}+ = {ABCDFG} Answer: (c) {AF}+ = {ACDEFG}

DBMS Normalization – 1NF 2NF 3NF Explained for GATE CSE 2026 Normalization is the most important topic of DBMS for GATE. Every year 1-2 questions are asked. Let’s understand with easy Hinglish + English. What is Normalization? Normalization is used to remove redundancy (duplicate data) and improve data integrity. 1NF – First Normal Form Rule:

Complete DBMS Notes for GATE CSE, UGC NET, PSU exams. Here you will get ER Model, Normalization, SQL, Transactions, PYQs and PDF download. DBMS Syllabus for GATE CSE DBMS Complete Super Notes for GATE 2026 – 1800 Words DBMS se GATE me har saal 6-8 marks pakka aata hai. Ye notes PYQ analysis se bane