Write the following queries in relational algebra, using the university schema. a. Find the names of all students who have taken at least one Elec. Eng. course.
Added by Victor N.
Step 1
..) - Course(cid, cname, dept, ...) - Takes(sid, cid, ...) --- ** Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 77 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Consider the relational schema below: Students (sid: integer, sname: string, major: string) Courses (cid: integer, cname: string, hours: integer) Enrollment (sid: integer, cid: integer, grade: real) Write a relational algebra expression that satisfies this query? Find the distinct names of all students that take at least three courses and major in "Philosophy".
Akash M.
Consider the University DB with the following relations/tables: Student (studno, name, hons, tutor, year) FK: tutor references Staff (lecturer) Staff (lecturer, roomno) Enrolled (studno, courseno, labmark, testmark) FK: studno references Student (studno) Write queries in relational algebra that return the following: 1) The names of the lecturers who are tutoring a student who had a test mark worse than the lab mark. 2) The names of the lecturers who are tutoring a 3rd year student. 3) The names of the tutors who are tutoring more than one student. 4) The names of the tutors who are tutoring no more than one student.
Shyam P.
Write the following queries in relational algebra, using the university schema. a. Find the ID and name of each instructor in the Physics department. b. Find the ID and name of each instructor in a department located in the building "Watson". c. Find the ID and name of each student who has taken at least one course in the "Comp. Sci." department. d. Find the ID and name of each student who has taken at least one course section in the year 2018. e. Find the ID and name of each student who has not taken any course section in the year 2018.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD