The Appearance of the Relation Result
See the attachment.
In terms of the relations shown below, what is the appearance of the relation RESULT after executing each of these instructions?
Name Email_address Location
John John.john @ abxz.com 5
Mary m.smith @ abxz.com 3
Philip philipx @ abxz.com 5
a. RESULT <- PROJECT Location from Employees
b. RESULT <- SELECT from Employees where Location = 5
c. RESULT <- PROJECT Floor_# from Department
d. RESULT <- JOIN Employees and Department where
Employees.Location = Departement.Floor_#
Check attachment for correct tables.