Answered: 6. Create queries for each of the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Use SQL Server with the help of the directory or the copy of databases except Access to solve the following question. A company undertakes a number of projects, on which employees work and during its operation The company consisting of a number of departments (the department number, which is a single number, the name of the department, the department's website) Employees (the employee's number, which is a single number, his name, address, salary, and job) It belongs to one department only, and each department has more than one employee. Projects (the project number, which is a single number, the project name, the project) Each project has a department that it manages, and the department may manage it more than one project. More than one employee works in the project, and the employee may work in more than one project. Each employee has a number of work hours per week in each project.

Required:

6. Create queries for each of the following cases:

• Display the names of employees who work in the same department.

• Display the names of employees who work on the same project

• Display the names of employees who work more than 15 hours.

• Show employees whose salary is more than 1200 dinars.

• I remove the employee who works on Project No. 20.

Expert Solution