Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along w...

Problems and Exercises 1 through 5 are based on the class schedule 3NF relations along with some sample data in Figure 7-16. For Problems and Exercises 1 through 5, draw a Venn or ER diagram and mark it to show the data you expect your query to use to produce the results.

Write SQL retrieval commands for each of the following queries:

a. Display the course ID and course name for all courses with an ISM prefix.

b. Display all courses for which Professor Berndt has been qualified.

c. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212.