Explain the architecture of Database Management Systems with neat diagram?
What is Null Attribute? With suitable diagram explain Weak and Strong Entity Set.
Discuss about File Organization and Access methods.
How to write the queries in Relational Algebra? Explain with examples.
What do you understand by Tuples and Attributes? Explain with examples.
Discuss about Joins with suitable examples.
Explain normalization using (1NF, 2NF, 4NF) with suitable examples?
What are the steps to be followed to convert a relation in 3NF to BCNF?
Compute the closer of the following set of functional dependencies for a relation scheme. R(A, B, C, D, E), F = { A → BC, CD → E, B → D, E → A } List out the candidate keys of R.
State and explain shadow paging with suitable example.
Discuss about Timestamp Based Concurrency Control.
What do you understand by Deadlocks, Explain Avoidance and Prevention in deadlock?
Write an algorithm to implement project and join operation of relational algebra.
Compare Single and Multilevel indices.
Write short notes on any two:
i) Complexity Measures
ii) Components of DBMS
iii) Triggers
iv) Recoverability
