Incorrect translation for "SELECT mgr_ssn, pname FROM project, department WHERE dnum = dnumber AND mgr_start_date > '1990-01-01'"

[wholton]

Query: SELECT mgr_ssn, pname FROM project, department WHERE dnum = dnumber AND mgr_start_date > '1990-01-01'

Translation: " Select the name of each project and the ssn of each employee where the project's employee's department managed's start date is greater than "1990-01-01." "

I stated the question as "Retrieve the ssn of each employee and the name of each project where the project is controlled by some department, the employee manages the project's controlling department, and the manager's start date is after 01-01-1990."

[jakecobb]

We can handle this already, see query 4-10 from the paper (although it will
say "later than"). The data type of mgr_start_date needs to be set in the
ER diagram.

-Jake

On Thu, Oct 23, 2014 at 3:13 PM, wholton [email protected] wrote:

Query: SELECT mgr_ssn, pname FROM project, department WHERE dnum = dnumber
AND mgr_start_date > '1990-01-01'

Translation: " Select the name of each project and the ssn of each
employee where the project's employee's department managed's start date is
greater than "1990-01-01." "

I stated the question as "Retrieve the ssn of each employee and the name
of each project where the project is controlled by some department, the
employee manages the project's controlling department, and the manager's
start date is after 01-01-1990."

—
Reply to this email directly or view it on GitHub
#21.

[wholton]

The date is the lesser issue. See: "the project's employee's department managed's start date"

We should probably have some way to relate "start date" to the manager (this is already done in the ER through the manages relation). That way we can say "manager's start date is later than 1990-01-01", and break the rest up as mentioned in my alternative translation.