Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My 2 Cents Difference Between Relational Algebra And Relational Calculus?

Discussion in 'Database Management' started by krishatg, Mar 12, 2016.

  1. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    The main differences between Relatinal algebra and calculus are:
    • Relational algebra is a procedural language whereas Relational Calculus is a non-procedural language.
    • In Relational algebra we need to specify what is required and how to get it whereas in Relational Caculus we only need to specify what is required.
    • Relational algebra is used to build a new relations whereas Relational calculus is used to formulate the relation definition.
    • In Relation algebra queries are domain independent whereas in Relational Calculus queries are domain dependent.
    • Relational algebra is nore close to programming language whereas Relational calculus is more close to natural language.
     
  2. bharath

    Staff Member Yellow Belt

    Joined:
    Dec 7, 2015
    Messages:
    772
    Ratings:
    +54 / -0
    Hi Nice Explanation, I didn't get the last statement between natural language and Programming language. What do you mean by natural language?
     
  3. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Programming language follows the particular syntax like in relational algebra the queries are written in particular format like using projection operator or selection operator, etc.
    Whereas,
    Relational calculus is more close to natural language which makes query formation comparitively more easier.
    For eg. Form the query to get name and salary of the employees.
    {
    (e.ename, e.sal | EMP(e))
    }
     

Share This Page