• Attempt any five questions.
• All questions carry equal marks.
Describe the architecture of DBMS. Explain each component briefly.
Define E-R model with example. How to convert an E-R model into Tables? Explain.
Define database system. Summarize the advantages of database system.
What is database schema? Describe Physical schema and Logical schema.
List out the various join operations and explain briefly with suitable examples.
Discuss the following Relational Algebra operations with examples. SELECT, PROJECT, DIVISION
State BCNF. How does it differ from 3 NF? Explain.
What is Functional Dependency? Describe the properties of FD's.
Define optimization. Discuss the steps involved in query optimization.
Explain different types of Advanced Recovery Techniques.
List and explain various types of specialized locking techniques used in DBMS.
What do you understand by distributed databases? Give the various advantages and disadvantages of distributed database management system.
Describe the usage of parameters in procedures.
Discuss the limitations of user defined functions.
Single level and multilevel indices.
Referential integrity constraints.
Problems with null valued and dangling tuples.
Triggers
