COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Relational calculus is a ____ language
A
Non-procedural
B
Procedural
C
Both (A) and (B)
D
None of the above
Explanation: 

Detailed explanation-1: -Relational calculus is a non-procedural query language. In the non-procedural query language, the user is concerned with the details of how to obtain the end results. The relational calculus tells what to do but never explains how to do. The tuple relational calculus is specified to select the tuples in a relation.

Detailed explanation-2: -Relational Calculus is a Declarative Language. TRC uses tuple variable and checks every Row with the Predicate expression condition. DRC uses domain variables and returns the required attribute or column based on the condition.

Detailed explanation-3: -Relational calculus is a non-procedural query language. It is of two types: tuple and domain relational calculus.

Detailed explanation-4: -Tuple Relational Calculus (TRC) It is a non-procedural query language which is based on finding a number of tuple variables also known as range variable for which predicate holds true.

There is 1 question to complete.