Database Management System Unit 1 – Introduction and ER Model: important questions for AKTU
Unit 1 (Introduction and ER Model) questions that AKTU repeats most often. This unit carries about 30 marks per paper. Start with the repeated questions, then the most asked topics.
Most repeated Unit 1 questions
- Explain the architecture of DBMS in terms of its components with a proper diagram. (7 marks, 2025, Database System Overview) – also asked in 2022, 2026
- Illustrate the concept of data independence and its type with example. Why is it required? (7 marks, 2025, Data Model Schema Instances) – also asked in 2022, 2023
- Discuss three level of abstractions or schemas architecture of DBMS. (7 marks, 2026, Database System Overview) – also asked in 2025
Most important Unit 1 topic
- Data Model Schema Instances (Unit 1: Introduction and ER Model) – asked 9 times in 2021, 2022, 2023, 2025, 2026
Most asked Unit 1 topics
- Data Model Schema Instances – asked 9 times
- Database System Overview – asked 8 times
- Entity Relationship Model – asked 8 times
More Unit 1 previous year questions
- Explain Logical data Independence. (2 marks, 2026, Data Model Schema Instances)
- Write Advantages of Database. (2 marks, 2026, Database System Overview)
- Compare Generalization, Specialization and Aggregation with suitable examples. (7 marks, 2026, Entity Relationship Model)
- Draw an ER diagram of Hospital or Bank with showing the Specialization, Aggregation, Generalization. Also convert it in to relational schemas and SQL DDL. (7 marks, 2026, Entity Relationship Model)
- Define candidate key and super key with example. (2 marks, 2025, Entity Relationship Model)
Unit 1 syllabus topics
- Database System Overview
- Data Model Schema Instances
- Entity Relationship Model