P Pre Langsql Cssfilehk1stylet S Instructor Tname Sname U #434
</p> <pre><code class="language-sql">{t | Э s ε instructor (t[name] = s[name] ∧ Э u ε department (u[dept name] = s[dept name] ∧ u[building] = “Watson”))}</code></pre> <p>Which of the following best describes the query?
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.
{t | Э s ε instructor (t[name] = s[name] ∧ Э u ε department (u[dept name] = s[dept name] ∧ u[building] = “Watson”))}
Which of the following best describes the query?
Finds the names of all instructors whose department is in the Watson building
Finds the names of all department is in the Watson building
Finds the name of the dapartment whose instructor and building is Watson
Returns the building name of all the departments
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