You are given the following schema of a University, where primary keys of each table are underlined and symbol (#) symbolises foreign keys: Student (student_id, first_name, last_name, date_of_birth) Course (course_id, #professor_id, course_name, credits, programme) Exam (#student_id, #course_id, exam_date, grade) Professor (professor_id, first_name, last_name, research_field) -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)
You are given the following schema of a University, where primary keys of each table are
underlined and symbol (#) symbolises foreign keys:
Student (student_id, first_name, last_name, date_of_birth)
Course (course_id, #professor_id, course_name, credits, programme)
Exam (#student_id, #course_id, exam_date, grade)
Professor (professor_id, first_name, last_name, research_field)
-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)
Step by step
Solved in 3 steps
