Database Management System Unit 1 Notes AKTU (BCS501)

AKTU · BTECH · Semester 5 · Database Management System · Unit 1 · Notes

AKTU Database Management System (BCS501) Unit 1 notes for B.Tech Semester 5 – Introduction and ER Model. Topics: Database System Overview, Data Model Schema…

Open the interactive reader to study this resource on AcademicArk.

Unit 1: Introduction and ER Model – AKTU syllabus topics

  • Database System Overview: Database vs File System, Database System Architecture
  • Data Model Schema Instances: Data Independence, DDL and DML
  • Entity Relationship Model: ER Model Concepts Notation, Keys Super Candidate Primary, Mapping Constraints ER to Tables, Extended ER Generalization Aggregation

Most asked AKTU PYQ questions from Unit 1

  1. Q1b. Differentiate between physical and logical data independence. (2 marks, 2022-23)
  2. Q1a. What is the significance of Physical Data Independence? (2 marks, 2021-22)
  3. Q1a. Explain Logical data Independence. (2 marks, 2025-26)
  4. Q1a. What is Data Independency in DBMS? (2 marks, 2020-21)
  5. Q2a. Explain the architecture of DBMS in terms of its components with a proper diagram. (7 marks, 2024-25)
  6. Q3a. Illustrate the concept of data independence and its type with example. Why is it required? (7 marks, 2024-25)
  7. Q3b. What are the different types of Data Models in DBMS? Explain them. (10 marks, 2022-23)
  8. Q2a. Draw the overall structure of DBMS and explain its various components. (10 marks, 2021-22)
  9. Q3b. Explain the following with example (i) Generalization (ii) Specialization (iii) Aggregation (10 marks, 2020-21)
  10. Q2a. Discuss three level of abstractions or schemas architecture of DBMS. (7 marks, 2025-26)

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

More versions of this resource

Browse all notes · Semester 5 notes