Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with the correct answers lowing queries will find the Name of the Employee and the name of the 2. Which of the

Please help me with the correct answers

image text in transcribed

lowing queries will find the Name of the Employee and the name of the 2. Which of the following queries will find the Name Departments they work? 3. SELECT Dname, Ename FROM Dept d, EMP e, IN DEPT i: b. SELECT Dname, Ename FROM Dept d, EMP e, IN_DEPT i WHERE i.EID = e.EID AND d.DID = i.DID: c. SELECT Dname, Ename 5 CD FROM Dept d INNER JOIN IN DEPTI ON d.DID=i.DID INNER JOIN EMP e ON 1.EID = e.EID; d. SELECT Dname, Enane FROM Dept d NATURAL JOIN IN_DEPTI ON d.DID = i. DID NATURAL JOIN EMP e ON LEID = e.EID; e SELECT Dname, Ename FROM Dept NATURAL JOIN IN_DEPT NATURAL JOIN EMP; F. None of the above 3. Which of the following queries finds the number of employees: . SELECT count(*) FROM EMP; b. SELECT count(EID) FROM IN DEPT; L. SELECT count(DISTINCT EID) FROM IN DEPT; a SELECT DISTINCT count(ED) FROM IN DEPT; 2. SELECT count(*) FROM ( SELECT EID FROM IN_DEPT GROUP BY EID); ( None of the above ACE lowing queries will find the Name of the Employee and the name of the 2. Which of the following queries will find the Name Departments they work? 3. SELECT Dname, Ename FROM Dept d, EMP e, IN DEPT i: b. SELECT Dname, Ename FROM Dept d, EMP e, IN_DEPT i WHERE i.EID = e.EID AND d.DID = i.DID: c. SELECT Dname, Ename 5 CD FROM Dept d INNER JOIN IN DEPTI ON d.DID=i.DID INNER JOIN EMP e ON 1.EID = e.EID; d. SELECT Dname, Enane FROM Dept d NATURAL JOIN IN_DEPTI ON d.DID = i. DID NATURAL JOIN EMP e ON LEID = e.EID; e SELECT Dname, Ename FROM Dept NATURAL JOIN IN_DEPT NATURAL JOIN EMP; F. None of the above 3. Which of the following queries finds the number of employees: . SELECT count(*) FROM EMP; b. SELECT count(EID) FROM IN DEPT; L. SELECT count(DISTINCT EID) FROM IN DEPT; a SELECT DISTINCT count(ED) FROM IN DEPT; 2. SELECT count(*) FROM ( SELECT EID FROM IN_DEPT GROUP BY EID); ( None of the above ACE

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

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

1st Edition

1597496251, 978-1597496254

More Books

Students also viewed these Databases questions

Question

Define and measure service productivity.

Answered: 1 week ago