EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATION DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM DEPENDENT ESSN DEP-NAME...



  1. Given the following relational schema in the image attached.


For the following query, prepare the initial (canonical) query tree, then show how the query tree is optimized by the use of heuristic optimization. (Provide all the relational algebra expressions for the query trees).


‘For every project located in ‘Stanford’, list the project number, the controlling department number, and the department manager’s lastname, address and birthdate’


EMPLOYEE<br>FNAME<br>MINIT<br>LNAME<br>SSN<br>BDATE<br>ADDRESS<br>SEX<br>SALARY<br>DNO<br>DEPARTMENT<br>DNAME<br>DNUMBER<br>MGRSSN<br>MGRSTARTDATE<br>DEPT_LOCATION<br>DNUMBER<br>DLOCATION<br>PROJECT<br>PNAME<br>PNUMBER<br>PLOCATION<br>DNUM<br>DEPENDENT<br>ESSN<br>DEP-NAME<br>SEX<br>BDATE<br>RELATIONSHIP<br>

Extracted text: EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATION DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM DEPENDENT ESSN DEP-NAME SEX BDATE RELATIONSHIP

Jun 04, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here