Question: 3. Using the database instance below and for each query to the right, give: a relational algebra expression a) List the names of students whose

3. Using the database instance below and for each query to the right, give: a relational algebra expression

3. Using the database instance below and for each query to the

right, give: a relational algebra expression a) List the names of students

a) List the names of students whose phone number is 555- 1234.

Name
C Brown
Snoopy

b) Find the names and corresponding course numbers of all students who have a class in the Turing Aud.

Name Course
C Brown CS101
L Van Pelt CS101
Snoopy CS101

c) Find the name and phone number of students taking any of the immediate prerequisites of CS120.

Name Course
C Brown 555-1234
L Van Pelt 555-5678
Snoopy 555-1234

SNAP tudentID Name ddress Phone 2345 Brown 12 Apple St. 55-1234 7890 . Van Pelt 34 Pear Ave 55-5678 Patt 6 Grape Blvd. 555-9999 noo 12 Apple St 55-1234 CR ourse oom S101 uring Aud E20025 Ohm Hall 100 Newton Lab CDH ourse Day our S101 M S101 S101 AM AM AM E200 10AM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!