se 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 name of the project, 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, a
Use SQL Server with the help of the directory or the copy of
4. Create a Trigger that indicates the end of the entry operation on any of the previous tables.
5. Enter data for at least five fields.
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.
Step by step
Solved in 3 steps with 2 images