Incorrect translation for "SELECT dependent_name FROM employee AS E, dependent AS D WHERE E.ssn = D.essn"

[wholton]

Query: SELECT dependent_name FROM employee AS E, dependent AS D WHERE E.ssn = D.essn

Translation: Select the name of each dependent where the employee dependents of the dependent.

[jakecobb]

This looks like a problem with the ER diagram, it's using the name of the relationship (DEPENDENTS_OF) as the default verb phrase. Although, there is also the issue of the relationship and entity name Dependent being redundant.

[wholton]

So, for these types of errors, I assume the best approach is to apply extra label annotations rather than edit the ER itself?

[jakecobb]

Short term, yes. The translation will still be awkward, but we need to
think about the strategy for these types of cases. I could see it needing
a new annotation to indicate the entity name ("dependent") already reflects
the relationship.

On Tue, Oct 28, 2014 at 7:21 AM, wholton [email protected] wrote:

So, for these types of errors, I assume the best approach is to apply
extra label annotations rather than edit the ER itself?

—
Reply to this email directly or view it on GitHub
#18 (comment).