Question

Consider the below schema of the university database (keys are in bold and underline):

Students(stuID: Integer, stuName: String, gender: String, age: Integer, gpa: Float)

Departments(deptName: String, numPhDs: Integer)

ProfessorWorks(profID: Integer, profName: String, deptName: String)

CoursesOffer(cNo: String, cTitle: String, deptName: String)

Majors(deptName:  String, stuID: Integer, degreeProgram: String; attendYear: String, attendSemester: String)

Sections(cNo: String, academicYear: String, semester: String, sectNo: Integer, profID: Integer)

Enrolls(stuID: Integer, cNo: String, academicYear: String, semester: String, sectNo: Integer, grade: String)

Write the following queries in Relational algebra.

Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016.

Find the names of students who are enrolled in the maximum number of classes in Fall 2016.

Print the age difference between the oldest and youngest student(s) per department.

Print the name(s) and GPA of student(s) who major in B.S. in Information Technology in the Computer Technology department, attending the program after Fall 2016.  Note that B.S. in Information Technology, Computer Technology, 2016, and Fall are a degree program, a department name, an attending year, and an attending semester, respectively.

Find the names of students who have not enrolled in any course yet Fall 2016.  

Answer 1

Please see the below answer.

Answer: