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

Demonstrate about analysis and design of a software system, Aim The aim...

Aim The aim of this Assignment is to demonstrate knowledge about the analysis and design of a  software  system  and  understanding  of  the  application  of  an  object-orient

Software design improve when we use object-oriented concept, Why does the ...

Why does the software design improve when  we use object-oriented concepts?    The software design improves when we use object-oriented concepts because 1. Object-orientatio

Goals of quality control, Describe how the goals of quality control (QC) fl...

Describe how the goals of quality control (QC) flexible manufacturing systems (FMS), design for assembly (DFA)and low overall costs can be best combined by computer integrated manu

Define kpas level associated with maturity model, Define KPAs level associa...

Define KPAs level associated with maturity model KPAs are defined by SEI and associated with different maturity levels.  These are described below: Level 1 KPAs : There is

Illustrate functions that dynamic testing tools supports, Q. Illustrate Fun...

Q. Illustrate Functions that dynamic testing tools supports? Functions that dynamic testing tools supports: 1: input setting it is selecting of the test data that the test

Define the term - inspection, Define the term - Inspection - An inspec...

Define the term - Inspection - An inspection is more formal than walk through. - It includes 3-8 people - a moderator, reader as well as a recorder to take notes. - Subj

Question, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

Explain network switching subsystem in gsm, Question: (a) (i) What are...

Question: (a) (i) What are the main components of the Network Switching Subsystem in GSM? (ii) What are the main functions of the Network Switching Subsystem? (b) What

What is transform mapping, What is Transform mapping? The transform map...

What is Transform mapping? The transform mapping is a set of design steps applied on the DFD in order to map the transformed flow characteristics into exact architectural style

What do you mean by polymorphism, Q. What do you mean by Polymorphism? ...

Q. What do you mean by Polymorphism? Polymorphism:- Polymorphism includes the ability to use the same message to objects of different classes and have them behave differently.

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