Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations...

Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to- any relationship between faculty and sections.

Write SQL queries to answer the following questions:

a. What are the courses included in the Section table? List each course only once.

b. List all students in alphabetical order by StudentName.

c. List the students who are enrolled in each course in Semester I, 2008. Group the students by the sections in which they are enrolled.

d. List the courses available. Group them by course prefix. (ISM is the only prefix shown, but there are many others throughout the university.)