Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

I need to know the answer to this question: Specify and execute the following queries in relational algebra (RA) using the RA interpreter on the...

I need to know the answer to this question:6.34. Specify and execute the following queries in relational algebra (RA) usingthe RA interpreter on the COMPANY database schema in Figure 3.5.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 projectlocated in Houston but whose department has no location inHouston.g. List the names of department managers who have no dependents.2. 6.36. Consider the following GRADEBOOK relational schema describing the datafor a grade book of a particular instructor. (Note: The attributes A, B, C, andD 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 theGRADEBOOK database schema.a. Retrieve the names of students enrolled in the Automata class during thefall 2009 term.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question