A tuple relational calculus equivalent for the given SQL query

1 vote

1 answer

1379 views

                          Well, here's a SQL query:
   
    select Employee.Name,Department.Name
    from Employee,Department
    where Employee.Dept_no=Department.No

I have tried a tuple relational calculus on it as:

    {t|Ǝ s ∈ Employee (s[Name]=t[Name] ^ 
    Ǝ u ∈ Department(u[Name]=s[Name]^u[No]=s[No]))}

Is my approach correct? if not, then can anyone help me understand?
                        

Asked by Anish Sharma (143 rep)

Jun 13, 2016, 02:24 AM
Last activity: May 2, 2018, 04:53 PM

A tuple relational calculus equivalent for the given SQL query

Related Questions