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

What is software architecture, What is software architecture The softwa...

What is software architecture The software architecture of a program or computing system is the structure or structures of the system, which comprises software components, the

Modules, write a main module and three other nodules. The owners of the Sup...

write a main module and three other nodules. The owners of the Super Supermarket would like to have a program that computes the monthly gross pay of their employees as well as the

Explain the software design, Define Software design. a. Software desig...

Define Software design. a. Software design is a step by step process through which requirements are translated into a "blue print" to construct the software. b. The blue pr

Systems Design Lifecycle, What is the development lifecycle? Why is it usef...

What is the development lifecycle? Why is it useful? Describe the activities carried out at each stage Determination of scope Requirements specification Design Coding Testing Maint

What is error-based testing, Testing where information about programming st...

Testing where information about programming style, error-prone language constructs, and other programming knowledge is functional to select test data capable of detecting faults, e

Draw dfd for the given requirement, A store is in the business of selling p...

A store is in the business of selling paints as well as hardware items. A numeral of reputed companies supplies items to the store. New suppliers are able to also register with the

Define software process, Define software process. Software process is e...

Define software process. Software process is explained as the structured set of activities that are need to develop the software system.

Define archives as records and explain their importance, QUESTION 1 (a)...

QUESTION 1 (a) Define "archives" as records and explain their importance. (b) Elaborate on the steps archivists have to undertake for the storage of archival records. QU

What are the virtues of incremental model, What are the virtues of incremen...

What are the virtues of incremental model? i. The incremental model can be adopted when there are less number of persons associated with the project. ii. Technical risks can

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