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)

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter9: Working With Text Functions And Creating Custom Formats

Section: Chapter Questions

Problem 1.7CP

See similar textbooks

Related questions

Question

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)

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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.