Advanced Database

Practice

Name:

ID #:

Signature :

Question $1$: Use the "employees" database to write a query to produce the results in Figure $1.$

Hint: We need to display all employees who are managers and which

departments they are managing and in which period.

Question $2$: Create a view for a query in the first question.

Question $3$: Write a query to produce the results in Figure $2.$

Question $4$: Create a view for a query in the third question.

Figure $1$