• Attempt any five questions.
• All questions carry equal marks.
Describe basic architecture of Database Management System in detail.
Explain the Functions of Database Administrator.
What is ER-model? Explain the basic symbols used of entities, attributes and relationships.
What is an Attribute? Explain various types of attribute with examples.
Explain integrity constraint over relations.
How to alter, destroy and views table? Explain with suitable queries.
Explain Fundamental operations in relational algebra with examples.
What are the steps to be followed to convert a relation in 3NF to BCNF?
Explain Optimization methods.
i) Heuristic based
ii) Cost Estimation based
How to test Serializability of Schedule? Explain with example.
Explain log-based recovery Protocol.
Explain Multiple Granularity Concurrency Control scheme.
What is view? Give brief note on view.
State and explain various File Organization Methods.
Assertions
Web and Mobile database
Hierarchical queries
Validation based protocols
