Given below are the two statements:
Statement I : Any retrieval request that is specified in the basic relational algebra can also be specified in relational calculus.
Statement II : Any retrieval request that is specified in the relational calculus can also be specified in basic relational algebra. In the light of the above statements, choose the correct answer from the options given below:
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: basic relational algebra and safe relational calculus have the same expressive power, so each can express every query of the other.
More Database Management Systems questions
- Which of the following queries would retrieve the roll number and names of students who have enrolled for all the prerequisite courses of t…
- Given query: select s.rollno from students where s.sex = ALL (select f.sex from professor f where f.empid = s.advisor). Consider the follow…
- Which of the following queries would compute, for each department, the total credits of all the courses offered by the department?
- Which of the following queries would retrieve the dept id and name of all the departments that are such that the total of the credits of al…
- Given query: select s.rollno, s.name from student s where EXISTS (select c.courseid from course c Where c.deptno =5 and EXISTS (select e.*…
- Identify the incorrect statement(s).