The database administrator at a university wants to create a view to simplify access to information about courses and the number of students enrolled in them for the 'Fall' 2017 semester. The view should include the course title, department name, and the total number of students enrolled in each course.LAM.pdf
LAM.pdf
takes ID course_id sec id semester year grade
student
ID name dept_name tot_cred
section course_id sec_id semester year building room_no time_slot_id
course course_id title dept_name credits
department dept_name building budget
advisor s_id i_id
time_slot time_slot_id day start_time end_time
prereq course_id prereq_id
instructor
classroom building room no capacity
ID name dept_name salary
teaches ID course_id sec_id semester year