Skip to content

Database Systems

SWE · Quiz · Summer 26

Paper 4 of 5Section 45 HSwitch

Section 45 H

Paper 4 of 5

This browser can’t show the PDF here

Open it, and your phone’s PDF viewer takes it, or download it.

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)