Using relational algebra, Find the students (sid and name) that have taken at le

Question

Using relational algebra, Find the students (sid and name) that have taken at least one of the prerequisite(s) of course ‘CS595’ and got an ‘A’ grade in this prerequisite course.

Course Student dept credits title Databases sid name dept 001 Alic CS 002 BobEE 003 Car CS 004 David PHYS cid CS425 CS595Database SecurityCS EE591Microcomputers EE EE401 CS VLSI Design PHYS571Radiation PhysicsPHYS Enroll grade gradepoint Ci 51 Prereq CS425 00A CS595 00B CS595 002A EE401 001A EE401 002B EE401 004A PHYS571 002C 4.0 3.0 4.0 4.0 3.0 4.0 2.0 4.0 cid pid CS595CS425 EE591 EE401 PHYS571 004 Hints:

Explanation / Answer

The student who has taken at least one of the prerequisite(s) of course ‘CS595’ and got an ‘A’ grade in this prerequisite course is Sid: 001 Name:Alice. Prerequesite of CS595 according to Prereq table is CS425. Only Alice has got an A in CS425.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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