Tables are as follows (For reference purposes):

TABLE COURSES

TABLE STUDENTS

TABLE INSTRUCTORS

TABLE CLASSES

TABLE ENROLLMENTS

COURSE_ID TITLE DURATION DURAT DATE_FIRS DATE_LAST DELIVERY SECTION_CODE 1001 Introduction to PL/SQL 1002 Algebra I 1003 Calculus I 1004 Java Programming II 17 Weeks 08-JAN-04 17 Weeks 08-JAN-02 17 Weeks 08-JAN-02 34 Weeks 08-JAN-02 In-class In-class In-class In-class 2005 2001 2001 2005 STU_ID FIRST_NAME LAST_NAME CONTACT_PHO EMAIL EXPECTED_ADDRESS1 ADD CITY ST POSTA COUNTRY 101 Mary 102 Jennifer 103 Jennifer 104 Jack 105 Frank Lou Loppez Johnsons Bason Davis 919-8665360 mlou@gmail.com 20-MAY-20 234 Lynn Road 919-8665359 jloppez@gmail.com 20-MAY-20 110 Six Forks Road 919-8665350 jjohnsons@gmail.com 20-MAY-20 124 Spring Road, 919-8665340 jbason@gmail.com 20-MAY-20 789 New Berns Road 919-8665330 fdavis@gmail.com 20-MAY-20 119 Ray Road Raleigh NC 27612 USA Raleigh NC 27614 USA Raleigh NC 27617 USA Raleigh NC 27619 USA Raleigh NC 27610 USA INSTRUCTOR_ID FIRST_NAME LAST_NAME WORK_PHONE EMAIL, OFFICE_LOCATION OS 3001 Jennifer 3002 Richard 3003 Gunther Jacobs Santos Haas 555-2399876 555-2399955 555-2395429 Bldg. 10 Room 52 Bldg. 10 Room 52 Bldg. 10 Room 53 CLASS_ID START_DAT PERIOD FREQUENCY INSTR_ID COURSE_ID 1 08-DEC-04 First 2 08-DEC-04 Second 3 08-DEC-04 Fifth 4 08-DEC-04 Mon-Wed 5 08-DEC-04 First 6 08-DEC-04 Mon-Wed Daily Daily Daily Weekly Daily Weekly 3003 3003 3003 3001 3001 3001 1002 1002 1002 1001 1003 1004 6 rows selected. ENROLLMEN CLASS_ID STU_ID FINAL_NUMERIC_GRADE F STATUS 12-JAN-04 12-JAN-04 12-JAN-04 12-JAN-04 eHHHH 101 102 103 104 Enrolled Enrolled Enrolled Incomplete STU_ID FIRST_NAME LAST_NAME Mary 1. Write a query to display stu_id column, first_name column, and last_name column from students table and enrollments table. Display all students' stu_id, first_name, and last_name data if students have taken classes with the class_id 1. Jennifer 103 Jennifer Loppez Johnsons 8. Write a query to display stu_id column, first_name column, and last_name column from students table and other tables. Display all students' stu_id, first_name, and last_name data if students have only taken the first period classes. STU_ID FIRST_NAME LAST_NAME ---- ---------- 101 Mary Lou 102 Jennifer Loppez 193 Jennifer Johnsons 104 Jack Bason 5. Create a query to display course_id column and title column from courses table, classes table and enrollments table. Display all course_id column and title column data if the class or classes has or have more than one enrollments. STU_ID FIRST_NAME LAST_NAME ---- --- ----- 101 Mary Lou 102 Jennifer Loppez 103 Jennifer Johnsons 194 Jack Bason 2. Create a query to display class_id column from classes table and enrollments table. Display all class_id data if the class or classes has or have more than one enrollments. COURSE_ID TITLE 1002 Algebra I DURATION 17 Weeks CLASS_ID 6. Write a query to display stu_id column, first_name column, and last_name column from students table, classes table, instructors table, and enrollments table. Display all students' stu id, first name, and last_name data if students have taken classes with Professor Gunther Haas. 3. Write a query to display instructor_id column, first_name column, last_name column, and office_location column from instructors table and classes table. Display all instructor's instructor_id, first_name, last_name, and office_location data if instructor(s) has or have worked daily frequency class and has taught more than one class. STU_ID FIRST_NAME LAST_NAME ------ -- -------- --- ------ 101 Mary Lou 102 Jennifer Loppez 103 Jennifer Johnsons 104 Jack Bason INSTRUCTOR_ID FIRST_NAME LAST_NAME OFFICE_LOCATION ------- 3003 Gunther Haas Bldg. 10 Room 53 7. Write a query to display instructor_id column, first_name column, last_name column, and work_phone column from instructors table and classes table. Display all instructor's instructor_id, first_name, last_name, and work_phone data if instructor(s) has or have taught more than one different course. 4. Write a query to display stu_id column, first_name column, and last_name column from students table and enrollments table. Display all students' stu_id, first_name, and last_name data if students have successfully enrolled classes on January 12, 2004. INSTRUCTOR_ID FIRST_NAME LAST_NAME WORK_PHONE 3001 Jennifer Jacobs 555-2399876