Database Management System
CSE · Quiz · Summer 25
Paper 4 of 4Batch 65_OSwitch
Batch 65_O
Paper 4 of 4
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 Computer Science & Engineering
Quiz-02, Semester: Summer 2025, Batch: 65_O
Course Code: CSE311, Course Title: Database Management System
Time: 30 minutes
Marks: 15
Name :
ID :
1. Consider the following schema for a university management system:
Courses (Course_id , Course_name, Credits, Dept_id)
Departments (Department_id , Department_name, Location)
Faculty (FID, Faculty_name, Salary, Dept_id)
Students ( SID , Name, Major, Year, GPA)
Enrollments (Enrollment_id , Course_id, Student_id, Semester, Grade)
Advisors (Advisor_id , Faculty_id, Student_id)
ResearchProjects (Project_id , Project_name, Dept_id, Supervisor_id)
Answer the following questions using WITHOUT Join operations (Write SQL query)
a) Find all students advised by specific faculty members with FID from 101 and 105. [1]
b) Find the total number of students. [1]
c) Find the average GPA of students in their final year. [1]
d) Find the department with the maximum number of courses. [1]
e) Find the average number of credits across all courses. [1]
f) List names of students who have GPA above the average GPA. [2]
g) Find faculty members whose salary is below the average salary. [2]
h) Find students who are not enrolled in any course. [2]
i) Find course IDs of courses that no student has enrolled in. [2]
j) Find departments that offer the maximum number of research projects. [2]