Awesome q2a theme
0 votes

Consider that the relation has only one attribute $A$.

ago in Databases by (613 points) | 43 views
I could also translate the RA query into an equivalent SQL query. I assume the working should still hold.

@shashin, Yes I agree that we can translate RA to sql.

But as far as I know RA query only takes relation as input and gives relation as output and this relation is set of tuples.

So I thought that relation should not include any duplicate.


@Vimal Patel - does this help ?

  • Formal query languages are based on mathematical relations. Thus no duplicates appear in relations.
  • As duplicate removal is expensive, SQL allows duplicates.

Here we are just told 'relations' - so we assumed a practical implementation that mostly allows duplicates. From a purely mathematical perspective - no duplicates. What say ?

first line itself says "Formal query languages are based on mathematical relations. Thus no duplicates appear in relations."
Btw this is such a little detail that we should not debate over it. :)

I just thought that you guys have mistakenly missed it. But you have not.

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Jan 2020
  1. shashin

    1163 Points

  2. Vimal Patel

    306 Points

  3. Deepakk Poonia (Dee)

    305 Points

  4. Debapaul

    237 Points

  5. Satbir

    192 Points

  6. SuvasishDutta

    137 Points

  7. Pratyush Priyam Kuan

    118 Points

  8. tp21

    108 Points

  9. pranay562

    95 Points

  10. DukeThunders

    94 Points

Monthly Top User and those within 60% of his/her points will get a share of monthly revenue of GO subject to a minimum payout of Rs. 500. Current monthly budget for Top Users is Rs. 75.
2,983 questions
1,509 answers
89,814 users