Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me in this question? Q5. Write the result set for the following queries related to the below database tables. [4] 1. SELECT

image text in transcribed

Can you help me in this question?

Q5. Write the result set for the following queries related to the below database tables. [4] 1. SELECT Employee. Employee_Name, Department. Dept_Name FROM Department LEFT JOIN Employee ON Department. Dept_ID = Employee. Dept_No Click or tap here to enter text. DEPARTMENT EMPLOYEE Employee_ID Employee_Name Dept_No 1 1 Robert 2 2 2 Clark 3 3 3 James 4 4 4 Alex 5 5 5 Jordan 2 6 6 Smith 4 7 7 Peter 4 8 8 Claire NULL 9 9 Kriss NULL 10 10 Karen Dept_ID Dept_Name 1 H.R 2 Finance 3 Production 4 Vendor Management 5 Warehouse 6 I.T 2. SELECT EMP_Experience. Empno, Department.Dept_Name FROM Department RIGHT JOIN Employee ON Department.Dept_ID = Employee. Dept_No RIGHT JOIN EMP_Experience ON Employee. Employee_ID = EMP_Experience. Empno NULL Click or tap here to enter text EMP_DEGREE EMP_Experience 3. SELECT EMP_DEGREE.EMP_NO, EMP_Experience.EMP_Experience FROM Employee RIGHT JOIN EMP_DEGREE ON Employee. Employee_ID = EMP_DEGREE. EMP_NO INNER JOIN EMP_Experience ON Employee. Employee_ID = EMP_Experience. Empno EMP_D_ID EMP_Degree EMP_NO 1 Undergrad 1 2 Graduate 2 3 School 3 4 School 4 5 Short Course 5 6 Undergrad 6 Click or tap here to enter text. . EMP_EXP_ID EMP_Experience Empno 1 Amold Clark 1 2 Argos 1 3 Azda 1 4 Sains burry 2 5 Next 2 6 Primark 2. 7 Sky 3 8 Virgin media 4 9 Burton 4 10 Eon 5 11 Lidle 8 12 Boots 8 13 Perfume shop NULL 14 Phone 4u NULL 15 Voda NULL 16 02 NULL 4. SELECT Employee. Dept_No FROM Employee RIGHT JOIN EMP_DEGREE ON Employee. Employee_ID - EMP_DEGREE. EMP_NO where Employee. Dept_NO IS NULL Click or tap here to enter text

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

Data Management Databases And Organizations

Authors: Richard T. Watson

2nd Edition

0471180742, 978-0471180746

More Books

Students also viewed these Databases questions

Question

b. Where did they come from?

Answered: 1 week ago