Database Management System Unit 1 – Introduction and ER Model: AKTU previous year questions
25 AKTU questions from Unit 1 (Introduction and ER Model) asked in 2021–2026, tagged by marks, year and topic. In short: about 30 marks of every paper come from this unit; the most asked topic is Data Model Schema Instances (9 times); 15 questions came back in a later year. The latest ones are listed below; on the page you can filter them by 2-mark or long questions, topic and repeats.
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)
- Discuss three level of abstractions or schemas architecture of DBMS. (7 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)
- Explain the architecture of DBMS in terms of its components with a proper diagram. (7 marks, 2025, Database System Overview)
- Illustrate the concept of data independence and its type with example. Why is it required? (7 marks, 2025, Data Model Schema Instances)
- Explain the process of reducing an ER diagram to tables. Provide a simple example. Given the following ER diagram representing a university database: Entities: Student: Attributes - StudentID (Primary Key), Name, Email Course: Attributes - CourseID (Primary Key), CourseName, Credits Enrollment: Attributes - EnrollmentID (Primary Key), DateEnrolled Relationships: Enrolls: A many-to-many relationship between Student and Course, represented by the Enrollment entity. a) Reduce the ER diagram to relational tables by listing the tables and their corresponding attributes. b) Identify primary keys and foreign keys in the tables you created. (7 marks, 2025, Entity Relationship Model)
- List any four disadvantages of file system approach over database approach. (2 marks, 2023, Database System Overview)
- Differentiate between physical and logical data independence. (2 marks, 2023, Data Model Schema Instances)
- A database is being constructed to keep track of the teams and games of a sport league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of players participating in each game for each team, the positions they play in that game and the result of the game. (i) Design an E-R schema diagram for this application. (ii) Map the E-R diagram into relational model. (10 marks, 2023, Entity Relationship Model)
Most asked Unit 1 topics
- Data Model Schema Instances – asked 9 times
- Database System Overview – asked 8 times
- Entity Relationship Model – asked 8 times
Unit 1 question pattern
- 2-mark questions: 10 asked in 2021–2026
- 7-mark questions: 6 asked in 2021–2026
- 10-mark questions: 9 asked in 2021–2026
- About 30 marks from Unit 1 in every paper
- 15 questions were asked again in a later year
Unit 1 questions year by year
- 2026: 5 Unit 1 questions asked (25 marks across that year's papers)
- 2025: 4 Unit 1 questions asked (23 marks across that year's papers)
- 2023: 5 Unit 1 questions asked (34 marks across that year's papers)
- 2022: 6 Unit 1 questions asked (36 marks across that year's papers)
- 2021: 5 Unit 1 questions asked (34 marks across that year's papers)