RDBMS 2018 Question Paper — Government College of Engineering and Tec…

The 2018 RDBMS previous year question paper (Government College of Engineering and Technology, Jammu), with every question and its marks.

Instructions

There are eight questions of 20 marks each.
Question Nos. 1 to 4 are from section A.
Question Nos. 5 to 8 are from section B.
Examinees are required to attempt 5 questions in all, selecting at least two questions from each section.

Q1. (a) What is a Database ? What is a DBMS ? What are its advantages and limitations ? (b) Find the essential attributes and calculate candidate key for relation R with attributes (I, J, K, L, M) and functional dependencies (IJ -> KL; L -> I; JK -> LM). Also find (KLM)+. [20 marks]
Q2. (a) Explain the different notations used in Entity Relationship Diagrams. (b) Draw an ER diagram for the database of a college. [20 marks]
Q3. (a) How are tuples identified in a relation ? What are different types of keys in a DB ? (b) Write a note on Relational Algebra with suitable example. [20 marks]
Q4. (a) What are functional dependencies ? How are relations normalized using functional dependencies ? (b) Differentiate between lossless and lossy decomposition using suitable example. [20 marks]

Q5. (a) Explain Log-Based Recovery. (b) Describe Database Buffer Management. [20 marks]
Q6. (a) Explain Lock-Based protocols in concurrency control. (b) What is Phantom Read phenomenon ? Explain with an example. [20 marks]
Q7. (a) Compare different notions of serializability. (b) Write a note on conflict serializability. [20 marks]
Q8. (a) What is a transaction ? What properties a transaction should have ? (b) What are different states of a transaction ? [20 marks]