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

Describe the formal software process model, Question 1: (a) Describe t...

Question 1: (a) Describe the Formal Software Process Model. (b) What are the main strengths of the Formal Software Process Model ? (c) Why is the Software Process Mode

Why srs also known as the blackbox specification of system, Why is SRS also...

Why is SRS also known as the blackbox specification of system ? Ans: SRS document is a contract among the development team and the customer.  Once the SRS document is accepted

List the pre-requisites for white-box testing, List the pre-requisites for ...

List the pre-requisites for white-box testing Pre-requisites for white-box testing are similar to black-box testing with one key difference: - During white-box testing, test

Define behavioural modelling, Define Behavioural Modelling. The state t...

Define Behavioural Modelling. The state transition diagram shows the characteristics of a system by depicting its states and the events that cause the system to change state

Discuss in detail about structural modeling, Discuss in detail about Struct...

Discuss in detail about Structural Modeling. Structural model includes a detail refinement of ERD, data flow model and control flow model. Creating an ERD. For example

Star topology, where star topology used in daily life

where star topology used in daily life

Explain the reuse maintenance model, Explain the reuse maintenance model wi...

Explain the reuse maintenance model with the help of a diagram. Reuse maintenance model: This model is based on the principal  that maintenance could be viewed as an activity i

What is desk checking, What is Desk Checking? Ans) A type of manual stat...

What is Desk Checking? Ans) A type of manual static analysis usually performed by the originator. Source code documentation, etc., is visually checked against needs and standard

State entity and relationship diagram, State Entity /Relationship diagram. ...

State Entity /Relationship diagram. ERD depicts relationships among data objects. The ERD is the notation that is used to conduct the data modeling activity. The primary

What do you mean by the computer based system, What do you mean by  the co...

What do you mean by  the computer based system? The computer based system can be termed as "a set or an arrangement of elements that are managed to accomplish some predefined g

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