Database Systems
SWE · Quiz · Summer 26
Paper 4 of 5Section 45 HSwitch
Section 45 H
Paper 4 of 5
Read the questions as text
Read off the PDF by AI, so it may have mistakes. The PDF is the original.
Daffodil International University
Department of Software Engineering
Quiz 1, Summer 2026, Section: 45 H
Course Code: SE223; Course Title: Database System
Marks- 15
40 min
Question 1:
[Figure: ER diagram showing STUDENT, LIBRARIAN, DEPARTMENT, BOOK, BORROW, and RESERVATION entities and their attributes, types, keys, and relationships]
a) Identify and Illustrate the best suited architecture for to implement the above DIU-Library Management System database and justify your answer (4 marks)
b) Regarding the SmartEdu system explain the three levels of the DBMS Three-Schema (4 Marks)
c) How Two types of Data Independence has been achieved in the above Scenario, Explain with proper justification. (3 Marks)
d) Identify the Super key, Candidate key and alternate key from student table and explain the necessity of PK and FK for above Scenario (4 Marks)