a) Find names and surnames of professors who teach a course in the "Biology" program: π(first_name, last_name)(σ(course_name = "Biology")(Course ⨝ Professor)) b) Find the student IDs and names of students who have not taken any exam (from any course): π(student_id, first_name, last_name)(Student - π(student_id)(Exam)) c) Find student IDs of students who have passed every exam from the "Data Science" program: π(student_id)(Student ⨝ (σ(programme = "Data Science")(Course) ⨝ (Student.student_id = Exam.student_id) ⨝ (Exam.grade >= 5))) d) Find the course IDs and names of courses that have been passed by at least two different students: π(course_id, course_name)(Course ⨝ Exam) ÷ ρ(count(students_passed), count(students_passed)(Course ⨝ Exam)) do these solutions fulfil these requirements 2. Use RELATIONAL ALGEBRA to write the following queries: a) Find names and surnames of professors, who teach a course in "Biology" programme b) Find the student IDs and names of students who have not taken any exam (from any course) c) Find student IDs of students who have passed every exam from "Data Science" programme d) Find the course IDs and names of courses that have been passed by at least two different students (If a course was taken, it means that a student wrote an exam on that course)
a) Find names and surnames of professors who teach a course in the "Biology" program: π(first_name, last_name)(σ(course_name = "Biology")(Course ⨝ Professor)) b) Find the student IDs and names of students who have not taken any exam (from any course): π(student_id, first_name, last_name)(Student - π(student_id)(Exam)) c) Find student IDs of students who have passed every exam from the "Data Science" program: π(student_id)(Student ⨝ (σ(programme = "Data Science")(Course) ⨝ (Student.student_id = Exam.student_id) ⨝ (Exam.grade >= 5))) d) Find the course IDs and names of courses that have been passed by at least two different students: π(course_id, course_name)(Course ⨝ Exam) ÷ ρ(count(students_passed), count(students_passed)(Course ⨝ Exam)) do these solutions fulfil these requirements 2. Use RELATIONAL ALGEBRA to write the following queries: a) Find names and surnames of professors, who teach a course in "Biology" programme b) Find the student IDs and names of students who have not taken any exam (from any course) c) Find student IDs of students who have passed every exam from "Data Science" programme d) Find the course IDs and names of courses that have been passed by at least two different students (If a course was taken, it means that a student wrote an exam on that course)
Chapter9: Working With Text Functions And Creating Custom Formats
Section: Chapter Questions
Problem 1.7CP
Related questions
Question
a) Find names and surnames of professors who teach a course in the "Biology"
π(first_name, last_name)(σ(course_name = "Biology")(Course ⨝ Professor))
b) Find the student IDs and names of students who have not taken any exam (from any course):
π(student_id, first_name, last_name)(Student - π(student_id)(Exam))
c) Find student IDs of students who have passed every exam from the "Data Science" program:
π(student_id)(Student ⨝ (σ(programme = "Data Science")(Course) ⨝ (Student.student_id = Exam.student_id) ⨝ (Exam.grade >= 5)))
d) Find the course IDs and names of courses that have been passed by at least two different students:
π(course_id, course_name)(Course ⨝ Exam) ÷ ρ(count(students_passed), count(students_passed)(Course ⨝ Exam)) do these solutions fulfil these requirements
2. Use RELATIONAL ALGEBRA to write the following queries:
a) Find names and surnames of professors, who teach a course in "Biology" programme
b) Find the student IDs and names of students who have not taken any exam (from any course)
c) Find student IDs of students who have passed every exam from "Data Science" programme
d) Find the course IDs and names of courses that have been passed by at least two different
students (If a course was taken, it means that a student wrote an exam on that course)
2. Use RELATIONAL ALGEBRA to write the following queries:
a) Find names and surnames of professors, who teach a course in "Biology" programme
b) Find the student IDs and names of students who have not taken any exam (from any course)
c) Find student IDs of students who have passed every exam from "Data Science" programme
d) Find the course IDs and names of courses that have been passed by at least two different
students (If a course was taken, it means that a student wrote an exam on that course)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage