(Solved): Exercise 1: Given following diagram, write SQL query based on diagram given STUDENT \{StudentD, Shu ...

Exercise 1: Given following diagram, write SQL query based on diagram given STUDENT \{StudentD, Shudenthdame] FaCt. Ty (Farulyid. Faculyhixne) BECTION ISectionks, Bemeater, Counw D) a. Display the course ID and course name for all courses with an ISM prefix. b. Display courses information (CourselD and CourseName) for which Professor Berndt has been qualified. c. Write an SQL query to answer the following question: Which faculty names are qualified to teach ISM 3113 ? d. Write an SQL query to answer the following question: List all faculties qualified to teach ISM 3113? e. Write $SQL$ queries to answer the following questions: (1) How many students were enrolled in section 2714 during semester I-2008? (2) How many students were enrolled in ISM 3113 during semester I-2008? f. Write an SQL query to answer the following question: f. Write an SQL query to answer the following question: Which students were not enrolled in any courses during semester I-2008?