KERALA UNIVERSITY Class 4 database design Question Paper 2020

Practice authentic previous year questions for better exam preparation.

Sample Questions

(a) Consider the ER diagram.
(a) Explain 2PC locking protocol. Whether it guarantee serializability and deadlock free?
What is the need for Query optimization and how relational algebra can help on Query optimization? PART - B Answer any one full questions from each Module. Each question carries 20 marks.
(b) Explain any six relational algebra operators with example.
(a) For the relations schemas given below, identify keys and highest normal forms