DATABASE MANAGEMENT SYSTEMS (PE – IV) B.Tech. IV Year I Semester JNTUH R-18

• How did file systems evolve into Database Management Systems (DBMS)?

• What are the key advantages of using a DBMS compared to file systems?

• Describe the different levels of abstraction in a DBMS and their significance.

• Explain the concept of data independence and its importance in database design.

• Illustrate how Entity-Relationship diagrams (ERDs) can be used for conceptual database design.

Unit II: Introduction to the Relational Model

• What are integrity constraints and how do they ensure data consistency in relational databases?

• Explain how to query relational data using SQL SELECT statements.

• Describe the importance of views in logical database design and how they are created.

• Compare and contrast relational algebra and tuple/domain relational calculus for data manipulation.

Unit III: SQL: Queries, Constraints, Triggers

• Write queries using various SQL clauses like JOIN, UNION, INTERSECT, and EXCEPT.

• Explain how aggregation operators like SUM, COUNT, and AVG can be used for data analysis.

• Discuss the role of NULL values in SQL and how to handle them effectively.

• Describe how triggers can be used to automate database operations based on specific events.

• Explain the concepts of normalization and how it helps reduce data redundancy and improve efficiency.

• Differentiate between FIRST, SECOND, THIRD, and BCNF normal forms.

Unit IV: Transaction Concept and Concurrency Control

• Define the properties of ACID transactions (Atomicity, Consistency, Isolation, Durability) and their importance.

• Discuss different techniques for implementing atomicity and durability of transactions.

• Explain the challenges of concurrent execution and the concept of serializability.

• Compare and contrast different concurrency control mechanisms like lock-based, timestamp-based, and validation-based protocols.

• Describe the concept of recovery and how log-based recovery ensures data integrity after failures.

Unit V: Data on External Storage and Indexing

• Discuss the benefits and limitations of storing data on external storage devices.

• Explain different file organization methods like sequential, indexed sequential, and hashed files.

• Describe the benefits of using indexes for query performance optimization.

• Compare and contrast different types of indexes like primary, secondary, and cluster indexes.

• Analyze the structure and performance characteristics of B+ trees as a popular indexing structure.