1. Translate the SQL statement SELECT Assignment.StartDate FROM Assignment, Employee WHERE Assignment.EmplId = Employee.EmplId AND Employee.Name = 'Joe E. Baker'; into a sequence of SELECT, PROJECT,...

1.
Translate the SQL statement

SELECT Assignment.StartDate

FROM Assignment, Employee

WHERE Assignment.EmplId =

Employee.EmplId

AND Employee.Name = 'Joe E.

Baker';

into a sequence of SELECT, PROJECT, and JOIN operations.

2.
Describe the effect that the following SQL statement would have on the database in Problem 13.

INSERT INTO Course

VALUES ('Computer Concepts', 'CS342');