Skip to content

Database Management System

CSE · Quiz · Summer 25

Paper 4 of 4Batch 65_OSwitch

Batch 65_O

Paper 4 of 4

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 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]