Explain the purpose of an outer join, Software Engineering

Assignment Help:

(a) What is a view?

(b) What is the implication of creating a view with the select * statement in the view definition?

(c) Make reference to the relational schema given in Appendix I to answer this question. Create a VIEW called SALARY_VU based on the employee last names, first names, department names and salaries for those employees whose monthly salary is greater than 10000. Label the column Employee Last Name, Employee First Name, Department and Salary respectively. Make sure to encrypt the view.

(d) Explain the purpose of an Outer Join.

(e) In the HR schema given in the Appendix II, there are certain employees who are not assigned to any department and there is a few departments where no employee has been assigned yet.

(i) Write SQL code to display the employee Last name, the department_id and the department name for all employees. Your answer should display even those employees who have not been assigned to any departments.

(ii) Write SQL code to display the employee Last name, the department_id and the department name for all employees. Your answer should display even those departments which have no employee assigned to the departments.


Related Discussions:- Explain the purpose of an outer join

Case study – newsagent shop system, A newsagent shop employs several newspa...

A newsagent shop employs several newspaper deliverers to hand-deliver the morning newspapers to customers' houses. The customers all live fairly close to the shop and the delivere

What is parameter, In software QA or software testing, a parameter is an it...

In software QA or software testing, a parameter is an item of information - like a name, number, or selected option - that is approved to a program, by a user or another program. B

Code restructuring, Ask quewhat is code restructuringstion #Minimum 100 wor...

Ask quewhat is code restructuringstion #Minimum 100 words accepted#

State about the software requirements specification, State about the Softwa...

State about the Software Requirements Specification This document is produced as output of requirement analysis.  Requirement analysis involves obtaining a clear and thorough

What is software metric, What is Software metric? Any type of measureme...

What is Software metric? Any type of measurement which relate to a software system, process or related documentation Lines of code in a program, the Fog index, number of

Construct an e-r diagram, Construct an E-R Diagram for the application desc...

Construct an E-R Diagram for the application described on the next page. Include any additional assumptions you made about the application requirements. The assumptions may not dir

Draw E-R diagram for the given situation, Draw E-R diagram for the followin...

Draw E-R diagram for the following situation An account is a relationship between customer and bank. A customer has a name. A bank has a branch. A customer may have numerous ac

Define the minimum cardinality of a relationship, Define the Minimum cardin...

Define the Minimum cardinality of a relationship Minimum cardinality of a relationship is the minimum number of instances of second entity (student, in this case) with every in

What can be main reasons for a bug not being to reproduce, What can be main...

What can be main reasons for a bug not being to reproduce? What must be done if such a bug is found? A bug can't be reproduced for below reasons: 1. Low memory. 2. Things

What is the objective of regression testing, The aim of regression testing ...

The aim of regression testing is to test that the fixes have not formed any other problems elsewhere. The aim is to ensure the software has remained intact. A baseline set of data

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