Projects pertaining to EE565 at Purdue FY2019
- Find the age of the oldest student who is either a CS major or is enrolled in a course taught by Prof. Brown.
- Find the names of all classes that either meet in room 115 or have five or more students enrolled.
- Find the names of all students who are enrolled in two classes that meet at the same time.
- Find the names of faculty members who teach in every room in which some class is taught.
- Find the names of faculty members for whom the combined enrollment of the courses that they teach is more than eight.
- Print the Level and the average age of students for that Level, for all Levels except JR.
- Find the names of students who are enrolled in the maximum number of classes.
- Find the names of students who are not enrolled in any class.
- For each age value that appears in Students, find the level value that appears most often. For example, if there are more FR level students aged 18 than SR, JR, or SO students aged 18, you should print the pair (18, FR).
- Compute and print the difference between the average number of students being taught by a EE faculty member and the average number of students taught by CS faculty member.
- Print the name of the faculty member whose number of students is greater than the average number of students of EE Professor.
- Find the name(s) of faculty member(s) who can substitute Prof. Wasfi for both of his classes when Prof. Wasfi is out of town. A faculty member can substitute another faculty member if he/she is from the same department and is not teaching at the same time.
- Find the students who are taking courses that do not have any prerequisite course.
- Find all courses that can be taken simultaneously in a semester with their immediate prerequisite courses. Two or more courses can be taken simultaneously in a semester if they do not meet at same time.
- Find an instructor who teaches both a course and its immediate prerequisite courses.
- Find all courses that have no more than three extended prerequisite courses.
- Find the names of students who have taken courses which have only one extended prerequisite course. Also list the course and its extended prerequisite course.
- A view that shows the Faculty ID, faculty name and the name of the class he/she teaches.
- A view that shows the student id, student name, course number of the classes he/she is enrolled in.
- Raghu Ramakrishnan and Johannes Gehrke. 2000. Database Management Systems (2nd ed.). McGraw-Hill, Inc., New York, NY, USA.
- https://github.com/mobeent/SQL-Queries
- https://www.chegg.com/homework-help/database-management-systems-3rd-edition-chapter-5-solutions-9780072465631