This assessment is related to the SQL Statements concept map by Jacob Levernier

1. The SELECT statement is meant to:

• a: Modify data in a database
• b: Search for data from a database
• c: Define tables in a database

1. Given the following statement, explain what relationship might be implied between members of tables student and pi:

SELECT * FROM student, pi WHERE student.pi_id = pi.id