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

How is concurrency identified, How is concurrency identified? Concurren...

How is concurrency identified? Concurrency in objects can be identified by the way they alter their state. Current objects can change their state independently. Aggregation imp

The sap profile parameter, While sorting, if the main storage available is ...

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP

Explain what is relation, Explain What is Relation? A database relatio...

Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Define hot swapping, Define hot swapping? Hot swapping permits the remo...

Define hot swapping? Hot swapping permits the removal of faulty disks and changes it by new ones without turning power off. Hot swapping decreases the mean time to repair.

Define the five basic operators of relational algebra, Define the five basi...

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

By the relations get details of employees working in sql, Consider the rela...

Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

One-to-many relationship, For each 1: n relationship type R involving two e...

For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en

Determine the persistent object, Determine the Persistent object Persis...

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

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