2024 - BCA [3rd Semester] - Database Management System - Purnea University

Note: Candidates are required to give the answers in their own words us far as practicable. The questions are of equal value. Answer any five questions.

1. What are the advantages and disadvantages of a 3-level architecture model in a DBMS?
   
   
2. Explain the differences between strong and weak entities in an ER diagram.
   
   
3. Define a foreign key and explain its role in maintaining referential integrity.
   
   
4. Describe the different types of joins in relational algebra, including theta join and equi join.
   
   
5. What are the key differences between First Normal Form (INF) and Third Normal Form (3NF)?
   
   
6. Explain the concept of functional dependency and its importance in database design.
   
   
7. What is the difference between static and dynamic hashing in database indexing?
   
   
8. Describe the structure and use of a B-tree index in database systems.
   
   
9. What is the role of buffer management in database recovery?
   
   
10. Explain the concept of shadow paging in transaction recovery.
    
    
    ***