CityU_Data Engineering Tutorial 2

最新推荐文章于 2021-09-02 10:07:28 发布

Slayer_Zhao

最新推荐文章于 2021-09-02 10:07:28 发布

阅读量305

点赞数 1

分类专栏： Data Engineering

本文链接：https://blog.csdn.net/qq_38905818/article/details/100671810

版权

Data Engineering 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

Using relational operators, specify the following queries on the COMPANY relational database schema shown below.

1. Retrieve the name (Fname, Lname) and address (Address) of all employees who work for the ‘Research’ department.

2. List all employee names (Fname, Lname) and the name of the departments (Dname) they manage, if any.

3. For every project located in ‘Stafford’, list the project number (Pnumber), the controlling department number (Dnum), and the department manager’s last name (Lname), address (Address) and birth date (Bdate).

4. Retrieve the names (Lname and Fname) of employees in department 5 who work more than 10 hours per week on the 'ProductX' project.

5. Make a list of all project numbers (Pnumber) for projects that involve an employee whose last name is ‘Smith’, either as a worker or as a manager of the department that controls the project.