Awesome q2a theme
0 votes

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

in Databases by (699 points) | 71 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
Top Users 2020 Aug 10 - 16
  1. Arkaprava

    404 Points

  2. jayeshasawa001

    198 Points

  3. SarathBaswa

    126 Points

  4. Ashutosh777

    67 Points

  5. toxicdesire

    20 Points

  6. Nilabja Sarkar

    12 Points

  7. premu

    10 Points

  8. iarnav

    7 Points

  9. Jhumpa_Sarma

    6 Points

  10. Patel0967

    6 Points

Weekly Top User (excluding moderators) will get free access to GATE Overflow Test Series for GATE 2021
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Aug 2020
  1. Arkaprava

    404 Points

  2. jayeshasawa001

    203 Points

  3. Mellophi

    156 Points

  4. Ashutosh777

    143 Points

  5. SarathBaswa

    126 Points

  6. anurag sharma

    49 Points

  7. toxicdesire

    20 Points

  8. shashankrustagi2021

    16 Points

  9. premu

    16 Points

  10. Kushagra गुप्ता

    15 Points

7,769 questions
1,977 answers
95,111 users