Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the COMPANY database schema
a. List the names of all employees in department 5 who work more than 10hours per week on the ProductX project.
b. List the names of all employees who have a dependent with the same firstname as themselves.
c. List the names of employees who are directly supervised by FranklinWong.
d. List the names of employees who work on every project.
e. List the names of employees who do not work on any project.
f. List the names and addresses of employees who work on at least one project located in Houston but whose department has no location in
Houston.
g. List the names of department managers who have no dependents.
6.36. Consider the following GRADEBOOK relational schema describing the data for a grade book of a particular instructor. (Note: The attributes A, B, C, and D of COURSES store grade cutoffs.)
CATALOG(Cno, Ctitle)
STUDENTS(Sid, Fname, Lname, Minit)
COURSES(Term, Sec_no, Cno, A, B, C, D)
ENROLLS(Sid, Term, Sec_no)
Specify and execute the following queries using the RA interpreter on the GRADEBOOK database schema.
a. Retrieve the names of students enrolled in the Automata class during the fall 2009 term.