Database schema, Software Engineering

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.

Posted Date: 10/22/2013 5:16:02 AM | Location : United States







Related Discussions:- Database schema, Assignment Help, Ask Question on Database schema, Get Answer, Expert's Help, Database schema Discussions

Write discussion on Database schema
Your posts are moderated
Related Questions
Question: Audio and Video Integration in Flash MX 2004 Professional. What sound formats does Flash MX 2004 support? (incl. if you have Quicktime or later installed on your comp

What is requirement engineering? Requirement engineering is the process of establishing the services that the customer needs from the system and the constraints under which it

what are the main characteristics of software lease

Sequential circuit:- A sequential circuit is an interconnection of gates and flip-flops.  The gates by themselves constitute a combinational circuit, but when contained with th

I am working on DD development project and I am using 475 field communicator for testing DD. While development of DD, I tested DD with SDC 625 PC application using HART modem. I h

Name some Software Standards Numerous terms related to software engineering are regularly standardised by organisations like IEEE (Institute of Electrical and Electronics Engi

which are the invisible registers?

Mutation testing is type of software testing where our goal is to make mutant software fail, and therefore demonstrate the adequacy of our test case.

What are the profits of vertical partitioning? i. These are very easy to maintain changes. ii. They decreased the change impact and error propagation.

Explain the CAPABILITY MATURITY MODELS Process models are based on various software development phases while capability models have an entirely different foundation of developm