Find The Names Of All Instructors In The Physics Department #439
Find the names of all instructors in the Physics department together with the course id of all courses they teach:
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Relational Algebra - Tuple Relational Calculus and Domain Relational Calculus - Quiz No.1.
Find the names of all instructors in the Physics department together with the course id of all courses they teach:
{< c > | Э s (< c, a, s, y, b, r, t >ε section ∧s = “Fall” ∧ y = “2009” ∨Эu (< c, a, s, y, b, r, t >ε section ∧s = “Spring” ∧ y = “2010”
{< n, c > | Э i, a (< i, c, a, s, y > ε teaches ∧ Э d, s (< i, n, d, s > ε instructor ∧ d = “Physics”))}
{< n > | Э i, d, s (< i, n, d, s > ε instructor ∧ s > 80000)}
{< i, n, d, s > | < i, n, d, s > ε instructor ∧ s > 80000}
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes