Database Management System Importance [MU SEM-3 IT]

Module-1: Database System Concepts and Architecture

• What is Database and what are its characteristics. [5M]
• Difference between File System and Database System. [5M]
• What is Data Independence? [5M]
• State the DBMS System Architecture. [5M]
• Who is Database Administrator and state the role of DBA. [10M]

Module-2: Entity-Relationship Model

• What is Entity Relationship (ER) Model? Explain the following concepts. [10M]

1. Entity Type
2. Entity Sets
3. Attributes and Keys
4. Weak Entity Types
   (Give Definition, Notation and one example of the following concepts.)

• Explain the concept of Generalization, Specialization and Aggregation. (Any 1 or Any 2) [5M-10M]
• Design and ER model for any real time case study. [10M]
  (Refer past 5 year’s Question Papers)

Module-3: Relational Model & Relational Algebra

• State the rules for mapping the ER and EER Model to Relational Model. [5M]
• State the Relation Algebra expressions for Unary Relational Operations. [10M]
  (Give Definition, Notation and one example of the following concepts.)
• Map the ER Model designed to Relational Schema. [5M-10M]

Module-4: Structured Query Language (SQL) & Indexing

• State the Aggregate Functions. [5M]
• What are Recursive Queries and Nested Queries. [5M]
• Explain the concept of View and Trigger. [5M-10M]
• What are Integrity Constraints in SQL. [5M]
• State all JDBC Drivers. [5M]
• Differentiate between Functions and Procedures in SQL. [5M-10M]
• Explain primary and secondary index. [5M]

Module-5: Relational Database Design

• State the types of Normalization. [10M]
  (Give Definition, Notation and one example of the following concepts.)
• Sums on Normalization. [5M-10M]
• Sums on Functional Dependencies. [5M-10M]

Module-6: Transactions Management and Concurrency and Recovery

• Explain the concept of Transaction and state its diagram. [5M]
• State the Acid Properties. [5M]
• Explain the Serializability Conflict and View. [5M]
• What are Lock-based protocols, Deadlock Handling and Timestamp-based protocols. (Any 1 or Any 2) [5M-10M]
• Explain the Log-based recovery (Shadow Paging). [5M]