What are the project names of all of them?
SELECT T1.Name ,  T3.Name FROM Scientists AS T1 JOIN AssignedTo AS T2 ON T1.SSN  =  T2.Scientist JOIN Projects AS T3 ON T2.Project  =  T3.Code
project names of all of them refers to joining Scientists table with Projects table via AssignedTo table to match scientists with their projects;