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

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 phone number is 555- 1234.

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

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

Name C Brown Snoopy 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

Explanation / Answer

a.

?Name ( Phone = "555-1234" (SNAP))

b.

?Name,Course( Room = "Turing Aud." (SNAP ? CSG ? CR))

c.

?Name,Phone ( CP.Course = "CS120" (SNAP ? CSG ? CP))

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.