3.2 Queries Algebra relacional

3.2 Queries Algebra relacional - Expresa en lgebra...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Expresa en álgebra relacional los siguientes queries 1. Nombre completo de todos los empleados que trabajan en el departamento “Research” (Retrieve the name and address of all employees who work for the 'Research' department) fname, minit, lname, ( σ dname =‘ Research’ (employee department ))) dno = dnumber 2. Para cada proyecto localizado en ‘Stafford’ liste el número de proyecto, número de departamento que lo controla, apellido, dirección y fecha de nacimiento del administrador del departamento. (For every project located in 'Stafford', list the project number, the controlling department number, and the department manager's last name, address, and birthdate). pnumber, (employee (departemnet ( σ plocation =‘Stafford’ (project)))) dnumber, Mgrssn = ssn dnum = dnumber lname, address, bdate 3. Obtenga los números de proyecto que involucran al empleado de apellido ‘Smith’, ya sea como trabajador o como administrador del departamento que controla ese proyecto.( Make a list
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

3.2 Queries Algebra relacional - Expresa en lgebra...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online