Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve using Oracle SQL database ASAP YU if you are glven the data of emp, emp dept and dept tables: Match the foloning queries

Please solve using Oracle SQL database
ASAP
image text in transcribed
image text in transcribed
YU if you are glven the data of emp, emp dept and dept tables: Match the foloning queries with the outputs (not all resalts need to be matched and se results may be repeated) LEFT OUTER JOIN emp dept ed ON e emp id ed.emp FROM emp ON d.Dept id - ed Dept id, LEFT OUTER JOIN Dept d ed emp id ON d.Dept_id- od Dept id FROM empe RIGHT OUTER JOIN emp dept ed ON e.emp id RIGHT OUTER JOIN Dept d e SELECT e emp id d.Dept kd NATURAL JOIN emp dept ed NATURAL JOIN Dept d; FROM emp e d SELECT eemp_ id, d.Dept id FROM emp e, emp dept ed, Dept d WHERE e emp-id ed.emp.id AND d.Dept id -ed.Dept_id e. SELECT e.emp-id, d. Dept-id FROM emp dept ed LEFT OUTER JOIN emp c ON e.emp id ed.emp_id LEFT OUTER JOIN Dept d ON d.Dept id-ed Dept_id E SELECT e.emp id, d.Dept id FROM emp e LEFT OUTER JOIN emp-dept cd LEFT OUTER JOIN Dept d ON e.emp-id =ed.emp-id ON d.Dept id-ed.Dept id UNION SELECT e.emp_ id, d.Dept id FROM emp e RIGHT OUTER JOIN emp _dept ed ON c.emp_id -ed.emp_ id RIGHT OUTER JOIN Dept d ON d.Dept id -ed.Dept id & SELECT ed.emp id, ed. Dept id FROM emp dept ed WHERE EXISTS (SELECT 1 FROM emp dept e WHERE c.emp id -ed emp id) AND Percentage time > 50

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design And Implementation

Authors: KROENKE DAVID M.

1st Edition

8120322258, 978-8120322257

More Books

Students also viewed these Databases questions

Question

=+ Who is the negotiation partner at company level?

Answered: 1 week ago

Question

=+Which associations exist?

Answered: 1 week ago