Skip to content

Database Systems

SWE · Quiz · Summer 26

Paper 5 of 5Section 45 CSwitch

Section 45 C

Paper 5 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 C Course Code: SE223; Course Title: Database System Marks- 15 40 min Question 1: Daffodil International University uses an integrated portal called SmartEdu to manage academic operations through two major interfaces: the Teacher Portal and the Student Portal. In this system, each student is assigned a unique permanent Student_ID (e.g., 252-35-XXX). The system stores the student's NID_Number, Full_Name, Institutional_Email, and Current_CGPA. A group of students is assigned under the mentorship of a particular faculty member. Faculty members access the Teacher Portal using a unique Employee_ID. The system records each faculty member's Full_Name, Official_Email, Department_Code, and Phone_No. The university consists of several departments, each identified by a unique Dept_Code and Dept_Name. Courses are identified by a unique Course_Code (e.g., SE 223) and contain Course_Title and Credits. Each course belongs to a specific department. Before every semester (e.g., Summer 2026), the mentor reviews a student's previous academic result and registers the student into a particular course section taught by a specific teacher. The enrollment information is maintained by the system. After completion of the semester, the student's Marks and Final Alphanumeric Grade are recorded in the result section. Students can view their results through the Student Portal. a) Identify the entities and design the relational schema for the SmartEdu system outlining attributes with their types, Pk, Fk and relations. (5 Marks) b) Regarding the SmartEdu system explain the three levels of the DBMS Three-Schema (4 Marks) c) Considering “Student” entity Identify the following Keys (3 Marks) 1. Super Key() 2. Candidate Key(s) 3. Primary Key 4. Foreign Key(s) 5. Unique Key(s) d) Identify the best suited architecture for to implement Smart-Edu database and justify your answer (3 marks)