# 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. Turn in your work to the assignment link. 1. Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016. 2. Print the age difference between the oldest and youngest student(s). 3. Print the age difference between the oldest and youngest student(s) per department. 4. Print the name(s) and GPA(s) of student(s) who major in B.S. in Information Technology in the Computer Technology department, attending the program after Fall 2015. Note that B.S. in Information Technology, Computer Technology, 2013, and Spring are a degree program, a department name, an attending year, and an attending semester, respectively. 5. Find the names of students who have not enrolled in any course yet Fall 2016.

TEMTFK The Asker · Computer Science

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. Turn in your work to the assignment link. 1. Print the name(s) and sid(s) of the student(s) enrolled in more than three classes in Fall 2016. 2. Print the age difference between the oldest and youngest student(s). 3. Print the age difference between the oldest and youngest student(s) per department. 4. Print the name(s) and GPA(s) of student(s) who major in B.S. in Information Technology in the Computer Technology department, attending the program after Fall 2015. Note that B.S. in Information Technology, Computer Technology, 2013, and Spring are a degree program, a department name, an attending year, and an attending semester, respectively. 5. Find the names of students who have not enrolled in any course yet Fall 2016.

More