Creat.e a view student_enrollment_details to see enrollment details of students for the Fall 2021 Term. Don't forget to writ and test your SELECT query before using it to creat the view. Filter the data to see details of classes which are not Online. (Hint: Use meeting_days column to filter out the courses which are not Online) Note: Once you've createed the view you can easily run it with the following code: SELECT * FROM student_enrollment_details;

The database:

  

Transcribed Image Text:

course_sections Columns section_id section_number semester year meeting_days start_time end_time course_id instructor_id delivery_id format_id location_id Indexes Foreign Keys Triggers courses Columns course_id course_code course_number course_description course_syllabus course_prereq credits enrollments Columns person_id section_id Indexes Foreign Keys Triggers people Columns person_id Iname fname email college department title start_date Indexes Foreign Keys Triggers AAA course_sections Columns section_id section_number semester year meeting_days start_time end_time course_id instructor_id delivery_id format_id location_id Indexes Foreign Keys Triggers courses Columns course_id course_code course_number course_description course_syllabus course_prereq credits enrollments Columns person_id section_id Indexes Foreign Keys Triggers people Columns person_id Iname fname email college department title start_date Indexes Foreign Keys Triggers AAA