Download the Northwoods University's database installation script OracleNorthwoods from Midterm Exam folder on myCourses and run it
Question:
Download the Northwoods University's database installation script OracleNorthwoods from Midterm Exam folder on myCourses and run it in your APEX to create the database. Take screenshots of your SQL statements along with test result to answer the following questions. Submit your results to the Midterm Exam Assignment folder. Please choose 5 questions out of 7 questions.
1. List Assistant professors and their supervisor's names by creating a self-join on the FACULTY table.
2. List the first and last names of all students who have the same S_CLASS value as a student Jorge Perez by creating a nested query.
3. List the names of courses that satisfy both of these requirements: 1) taken only by students who were not seniors 2) were offered in term 6.
4. List building code (ascending) and total capacity of each building which has equal or more than 100 seats.
5. Write a query to search for a COURSE_NO value from the COURSE table in which the third to last character is the number 1.
6. List the total number of students who took the course "Systems Analysis" in term 4, 5 and 6.
7. List first name, last name, building code and office room number of the faculty who taught the Database Management course in term 6.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last