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 the empirical estimation models, Write short notes on empirical est...

Write short notes on empirical estimation models. Estimation model for computer software uses empirically derived formulas to expect effort as a function of line of codes (LOC)

What is black box testing, Write short note on black box testing. The b...

Write short note on black box testing. The black box testing is also known as behavioural testing. This process fully focuses on the functional requirements of the software. Te

What are the phases of problem solving loop, What are the phases of Problem...

What are the phases of Problem solving Loop? Problem definition shows the problem to be solved. Technical developmentSolve the Problem by some Technology. Solution Integr

Draw a memory map for a system, Draw a memory map for a system with a memor...

Draw a memory map for a system with a memory capacity of 256MB. Each memory location in the system is 8 bits. Assume the system has one 4 MB memory block used as ROM residing at th

What does modality in data modeling indicates, What does modality in data m...

What does modality in data modeling indicates? Modality shows whether or not a particular data object must participate in the relationship.

Explain lines of code (loc), Lines of code (LOC) is a software metric used...

Lines of code (LOC) is a software metric used to calculate the size of a software program by counting the number of lines in the text of the program's source code. LOC is typicall

State both verification and validation, Define Verification &Validation. ...

Define Verification &Validation. Verification : The set of actions that make sure software correctly implements a particular function. Validation : The set of actions that

Applied physics, an isolated metal sphere has a radius r. when charged to a...

an isolated metal sphere has a radius r. when charged to a potential v, the charge on sphere is q. 1- state an expression, in terms of r and q, for potential v of sphere.

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