Question

BIT305 GWspring2021 - Word Issue 18/08/2011 Revision Date 25/06/2018 Ref No. ECT-ACAF ACAFO-FRM.031 Group Work Q2) Use relational algebra to find the table produced by implementing a Natural Join operation to get each employee's info along with his/her department name. (9 Marks) Emp E ID E NAME E AGE D ID 101 Ahmad 35 2 105 Hamad 40 3 201 Iman 22 4 304 Haya 25 2 411 Ayman 35 4 Dept D ID D NAME 2 IT 3 Accounting 4 HR

          BIT305 GWspring2021 - Word
Issue 18/08/2011 Revision Date 25/06/2018 Ref No. ECT-ACAF ACAFO-FRM.031
Group Work
Q2) Use relational algebra to find the table produced by implementing a Natural
Join operation to get each employee's info along with his/her department name.
(9 Marks)
Emp
E ID E NAME E AGE D ID
101 Ahmad 35 2
105 Hamad 40 3
201 Iman 22 4
304 Haya 25 2
411 Ayman 35 4
Dept
D ID D NAME
2 IT
3 Accounting
4 HR

BIT305 GWspring2021 - Word
Issue 18/08/2011 Revision Date 25/06/2018 Ref No. ECT-ACAF ACAFO-FRM.031
Group Work
Q2) Use relational algebra to find the table produced by implementing a Natural
Join operation to get each employee's info along with his/her department name.
(9 Marks)
Emp
E ID E NAME E AGE D ID
101 Ahmad 35 2
105 Hamad 40 3
201 Iman 22 4
304 Haya 25 2
411 Ayman 35 4
Dept
D ID D NAME
2 IT
3 Accounting
4 HR

Added by Tommy S.

Discrete Mathematics

Richard Johnsonbaugh 8th Edition

Chapter 3

Instant Answer

Solved by Expert Maanya Naveen

Step 1

This will give us the employee's information along with their department name. The result of the natural join operation will be a new table with the following columns: Emp, ED, ENAME, AGE, DID, DNAME. Show more…

Show all steps

Thanks for your feedback!

Review Team, what do you want to do? 2 aBbCcLAaBbC AaBbCcI AaBbCclAaBbCeD A Emphasis Heading Normal Strong Subtitle A Paragraph Styles Issue 18/08/2011 Revision Date 25/06/2018 Group Work RNo.ECTACAFACAFOFRM031 Q2 Use relational algebra to find the table produced by implementing a Natural Join operation to get each employee's info along with his/her department name. (9 Marks) Emp ED ENAME AGE DID 101 Ahmad 35 2 105 Hamad 40 3 201 Iman 22 4 304 Haya 25 2 411 Ayman 35 4 Dept DID 2 3 DNAME IT Accounting HR T ROCR G DELL