Consider the following relational schema: Student (sid, sname, dept) Enroll (cid, sid, grade, semester) Course (cid, cname, dept, credit) Prereq (cid, pid) Write the following queries in Relational Algebra expression: a) For students who have received an A in a course, return name of students and title of the course. b) Find name and id of students taken at least one of the prerequisite of CS595 course and got an A grade in this prerequisite course.
Consider the following relational schema: Student (sid, sname, dept) Enroll (cid, sid, grade, semester) Course (cid, cname, dept, credit) Prereq (cid, pid) Write the following queries in Relational Algebra expression: a) For students who have received an A in a course, return name of students and title of the course. b) Find name and id of students taken at least one of the prerequisite of CS595 course and got an A grade in this prerequisite course.
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter2: Data Models
Section: Chapter Questions
Problem 11P
Related questions
Question
Consider the following relational schema:
Student (sid, sname, dept)
Enroll (cid, sid, grade, semester)
Course (cid, cname, dept, credit)
Prereq (cid, pid)
Write the following queries in Relational Algebra expression:
a) For students who have received an A in a course, return name of students and title
of the course.
b) Find name and id of students taken at least one of the prerequisite of CS595
course and got an A grade in this prerequisite course.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning