BOOK: "Database systems: a practical to design, implementation, and management", 6th EDITION.

Case Study 2

for Exercises 6.32 - 6.40, use the Projects schema defined in the Exercises at the end of Chapter 5.

QUESTIONS:

6.32 List all employees from BRICS countries in alphabetical order of surname.

6.33 List all details of employees born between1980-90

6.34 List all managers who are females in alphabetical order of surname, and then first name.

6.35 Remove all projects that are managed by the planning department.

6.36 Assume the planning department is going to be merged with the IT department. Update employee records that reflect the proposed change.

6.37 Using the UNION command, list all projects that are managed by the IT and the HR department.

6.38 Produce a report of the total hours worked by each female employee, arranged by department number and alphabetically by employee surname within each department.

6.39 Remove all projects from the database which had no employees worked.

6.40 List the total number of employees in each department for those departments with more than 10 employees. Create an appropriate heading for the columns of the results table.