CS403 Current Midterm Paper Fall 2013 File 5

by Farhan Karim Shaikh on December 22, 2013 at 12:07am

Please tell which join is this??

Employee

Emp-ID Emp-Name City
1 ABC Lahore
2 DEF Islamabad
3 GHI Lahore
4 JKL Karachi

Dept-Head
Head-ID Dept-Name
1 HR Dept
3 Accounts Dept

Employee (Join) Dept-Head

The given algebra expression has following output / resultant table.

Resultant Table
Emp-ID    Emp-Name    City             Dept-Name
1               ABC               Lahore       HR Dept
3               GHI                Lahore       Accounts Dept

In your point of view, the above scenario is the result of which join type? Justify your answer with reason.