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

Explain the benefit of oom, Explain the benefit of OOM. Main benefits o...

Explain the benefit of OOM. Main benefits of object oriented modeling are development of system become fast, quality of the system get improve. It gives freedom of use of alrea

Why does a dbms query language is designed, Why does a DBMS query language ...

Why does a DBMS query language is designed? A DBMS query language is designed to support end users who use English-like commands. support in the development of complex applicat

Briefly explain the state diagram by taking one example, Briefly explain th...

Briefly explain the state diagram by taking one example. State Diagram - An object can be given a sequence of input instructions. The state of the object can vary depending u

Dbms, Retrieve the S&S In-Chapter Database (in Microsoft Access format) fro...

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

What are the comparison operator in sql, What are the comparison operator i...

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Convert the er - diagram into a relational database, Convert the following ...

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined):       Ans:  The relational database schema f

Entity relationship, how to write tables and drow E-R diagrams for hosiptal...

how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?

Difference among a database schema and a database state, What is the differ...

What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a

Dealing with constraints violation, If the deletion violates referential in...

If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ

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