How relational calculus is different from relational algebra, Database Management System

Assignment Help:

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries? 

Ans: Relational calculus contain two calculi, the tuple relational calculus and the domain relational calculus which are part of the relational model for databases and offer a declarative way to specify database queries. This in deference to the relational algebra that is also part of the relational model but offers a more procedural way for specifying queries.

 The relational algebra might propose these steps to retrieve the phone numbers and names of book stores which supply Some Sample Book:

a. Join books and titles over the BookstoreID.

b. Restrict the result of that join to tuples for the book a few Sample Book.

c. Project the result of that restriction over StoreName and StorePhone. 

 The relational calculus would formulate an expressive, declarative way:

 Get StoreName and StorePhone for supplies like there exists a title BK with the

same BookstoreID value and along with a BookTitle value of a few Sample Book. 

 The relational algebra and the relational calculus are fundamentally logically equivalent: for any algebraic expression, there is an equal expression in the calculus, and vice versa. This result is termed as Codd's theorem.

 TRC illustrates the tuple relational calculus and DRC stands for domain relational calculus. The TRC is relies on specifying a query in terms of tuple variable and DRC is relies on domain variables.


Related Discussions:- How relational calculus is different from relational algebra

Abap/4 program, It is not possible to make an ABAP/4 program, which having ...

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

Managing databases, Code an Oracle Database trigger to enforce the constrai...

Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

What are the benefits of decomposing a system, What are the benefits of dec...

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

What do you understand by a view, What do you understand by a view? What do...

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Recovery management component, Ask question #Minim 100 words accepted#what ...

Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

Define the notation for classes and atrributes, Define the notation for cla...

Define the notation for classes and atrributes The notation for class, attribute, and operations are shown below:     Figure: Class with attributes and operations A

Database model, Why older data models are being replaced by new data modell...

Why older data models are being replaced by new data modelling 100 words accepted#

E-r model uses this symbol to represent weak entity set, E-R model uses thi...

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.

How the time stamps are implemented, How the time stamps are implemented ...

How the time stamps are implemented Use the value of the system clock as the time stamp. That is a transaction's time stamp is equivalent to the value of the clock when the tra

Objectives-transactions and concurrency management, Objectives After Re...

Objectives After Reading this part, you should be able to: Explain the term CONCURRENCY; Describe the term transaction and concurrent transactions; Talk about co

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd