SampleFinal - Sample Questions from previous examples 1. 2....

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

View Full Document Right Arrow Icon
Sample Questions – from previous examples 1. Describe the three-schema architecture of a database system and the main functionality of each level in this architecture. 2. Given the relation schema shown in Fig. 1, construct expressions (using relational algebra operations) to evaluate the following queries: i) Find the names of employees who works on all the projects controlled by the departments located in ‘Houston’. ii) List the names of managers who have a dependent with the same first name and same sex as the manager. 3. Given the relation schemas shown in Fig. 1, construct SQL clauses to evaluate the following queries: i) For every project located in ‘Stafford’, list the project number, the controlling department number, the department manager’s last name, and the number of the employees working for the department. ii) For each department that has more than five employees, retrieve the department number and the number of its employees who are making more than $45,000. 4.
Background image of page 1

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

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

This note was uploaded on 02/17/2010 for the course ACS ACS-3911 taught by Professor Chen during the Spring '10 term at Windsor.

Page1 / 4

SampleFinal - Sample Questions from previous examples 1. 2....

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