From Elmasri & Navathe

4.5 Consider the database shown in Figure 1.2 [the STUDENT database - pld], whose schema
is shown in Figure 2.1 [or can be inferred from the student.text file on the main page].
What are the referential integrity constraints that should hold on the schema?
Write appropriate SQL DDL statements to define the database.

4.10 Specify the following queries in SQL on the COMPANY [or OFFICE - pld] relational
database schema shown in Fig 3.5. Show the result of each query if it is applied to the
COMPANY database in Figure 3.6.

(a). Retrieve the names of all employees in department 5 who work more than 10 hours per week
on the ProductX project.

(b). List the names of all employees who have a dependent with the same first name as
themselves.

(c). Find the names of all employees who are directly supervised by Franklin Wong.

4.12 Specify the following queries in SQL on the database schema of Figure 1.2 (STUDENTS).

(a) Retrieve the names of all senior students majoring in 'CS'.
(b) Retrieve the names of all courses taught by Professor King in 2007 and 2008.
(c) For each section taught by Professor King, retrieve the course number, semester,
year, and number of students who took the section.
(d) Retrieve the name and transcript of each senior student (Class = 4) majoring in CS.
A transcript includes course name, course number, credit hours, semester, year, and grade
for each course completed by the student.