DBMS 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]
