Statement I: Any retrieval request that can be specified in basic relational algebra can also be specified in relational calculus.
Statement II: Any retrieval request that can be specified in relational calculus can also be specified in basic relational algebra.
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Both Statement I and Statement II are true.
Explanation
Codd's theorem: relational algebra and safe relational calculus have equivalent expressive power.More Database Management Systems questions
- Which of the following queries would retrieve the roll numbers and names of students who have enrolled in ALL the prerequisite courses of c…
- Given the query SELECT s.rollno FROM student s WHERE s.sex = ALL (SELECT f.sex FROM professor f WHERE f.empid = s.advisor); which retrieves…
- Which of the following queries computes, for each department, the total credits of all the courses offered by the department?
- Which of the following queries retrieves the deptid and name of all departments whose total credits of offered courses is strictly greater…
- Given the query SELECT s.rollno, s.name FROM student s WHERE EXISTS (SELECT c.courseid FROM course c WHERE c.deptno = 5 AND EXISTS (SELECT…
- Identify the incorrect statement.