Question: For each of the following SQL queries, for each relation involved, list the attributes that must be examined to compute the answer. All queries refer
Emp(eid: integer, did: integer, sal: integer, hobby: char(20))
Dept(did: integer, dname: char(20), floor: integer, budget: real)
1. SELECT * FROM Emp E
2. SELECT * FROM Emp E, Dept D
3. SELECT * FROM Emp E, Dept D WHERE E.did = D.did
4. SELECT E.eid, D.dname FROM Emp E, Dept D WHERE E.did = D.did
Step by Step Solution
3.34 Rating (172 Votes )
There are 3 Steps involved in it
The answer to each question is given below ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
960-C-S-D (2470).docx
120 KBs Word File
