Given two tables E1={(Name), (first name), time} and E2={(Name), (First name), Distance, Category}, we want to obtain the surname, first name, the time and distance. What sequence of operations should we do?

Question

Consider the table E1={(Name), (first name), time} and E2={(Name), (First name), Distance, Category}

![](https://cdn.filestackcontent.com/compress/eOO6DHDeQ2idrDEdNy3D?fbclid=IwAR2Eg4U4OtnbX5BnaVaNWYzJ06wp186szH2GdhOaQ1gCPp8FiiWv8l6RYe8)
![](https://cdn.filestackcontent.com/compress/BjDqqgYzR1SJzbBr5aJO?fbclid=IwAR2ZOeqG6XQlhY4hlOv0CpARfwbqR6QksnYvTHtXn2qs2GnMeS-jUSrHfdY)

We want to obtain the surname, first name, the time and distance: what sequence of operations should we do?

Accepted Answer

a join then a projection

Accepted Answer

a projection then a join

Answer

a join then a selection

Answer

a selection then a join

Question from the Database - Fundamentals test

Given two tables E1={(Name), (first name), time} and E2={(Name), (First name), Distance, Category}, we want to obtain the surname, first name, the time and distance. What sequence of operations should we do?