Database schema, Software Engineering

Assignment Help:

Question

This question refers to the database Schema. Express the following queries in SQL:

(a) List the First Name, Last Name and telephone number of all employees who were hired in the year 1995.

(b) List all details of employee who is not managed by any employee.

(c) List full details of all employees who draw a salary between 10,000 and 18,000 and whose manager_id is either 100 or 101.

(d) List the Last Name and First Name of all employees who is a president (job_id is SA_PRES) OR a sales representative (job_id is SA_REP) AND who earns more than 15000.

(e) List the Last Name, First Name, salary and Annual Salary of all employees who do not get any commission. Display your result in descending order of the annual salary.

(f) List the First Name, Last Name, Salary, commission_pct and a column called special which will display the special features for those employee with the following condition:

- If the commission_pct value is not null, it is shown.
- If the commission_pct value is null, then the salary is shown
- If the commission_pct and salary is null, then the value 10 is shown.

(g) List the Last Name, job_id, department_id, department name for all employees who work in Toronto.

(h) List the employee last name, and employee number along with their manager's last name and manager number. Label the column Employee, Emp#, manager Mgr#, respectively.


Related Discussions:- Database schema

Explain smoke testing, Smoke testing It decreases the integration risk....

Smoke testing It decreases the integration risk. Error diagnosis and correction are simplified

Illustrate the method of user documentation, Illustrate the method of User ...

Illustrate the method of User documentation This usually comprises: -  How to load/run the software -  How to do a search   -  How to save files   -  How to do pri

What is clear box testing, Clear box testing is the similar as white box te...

Clear box testing is the similar as white box testing. It is a testing approach that consider the application's program structure, and acquires test cases from the application's pr

What is 4test, What is 4Test? 4Test is a test scripting language which ...

What is 4Test? 4Test is a test scripting language which is used by SilkTest to compose test scripts to perform automated tests. It's an object-oriented fourth-generation langua

What do you understand by the term integrity, Question: (a) What do yo...

Question: (a) What do you understand by the term "integrity"? (b) Which type of attack denies authorized users access to network resources? (c) You have discovered tha

What is stress testing, What is Stress testing - It checks the robustn...

What is Stress testing - It checks the robustness of application. - It verifies that application consistently provides satisfactory performance under unfavourable and extre

calculus, solve inequalities and graph the solutions: [z/25-1

solve inequalities and graph the solutions: [z/25-1]

Event procedure and a general procedure, (a) Visual Basic is governed by an...

(a) Visual Basic is governed by an event processor. Explain the meaning of this phrase. (b) Differentiate between an event procedure and a general procedure. (c) "For datab

Encapsulation, Illustrate the use of the concept Encapsulation.

Illustrate the use of the concept Encapsulation.

What is a cohesive module, What is a cohesive module? A cohesive module...

What is a cohesive module? A cohesive module performs only "one task" in software process with little interaction with other modules. In other words cohesive module performs on

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd