Question

For Problem 4, Problem 5 use the tables provided below. Assume that the table may change in the future.

Problems 4 and 5 do NOT have the same solution.

Table = Courses

StudentID	Fname	Lname	CourseID
11	Minnie	Mouse	21
13	Mickey	Mouse	16
15	Donald	Duck	18
14	Daisy	Duck	21
16	Huey	Duck	18
12	Dewey	Duck	24
12	Dewey	Duck	21
18	Louie	Duck	27
11	Minnie	Mouse	24

Problem 4 (15 points):

Write a relational algebra expression to list the students taking ANY course that Dewey Duck is taking. Display StudentID, Fname, Lname, CourseId for that student. Do not show Dewey Duck in the output. Show the actual results.

Problem 5 (15 points)

Write a relational algebra expression to list the students taking ALL of the courses that Dewey Duck is taking. Display StudentID. Show the actual results.

Answer 1