Consider the following records in MemberListA, MemberListB and MissionCriticalProject tables: MemberListA ProjectID ТX-02Y MemberID MemberName MA100 Anita MA108 Joey Francis TR-21Y MA109 TZ-19Y...


Consider the following records in MemberListA, MemberListB and MissionCriticalProject<br>tables:<br>MemberListA<br>ProjectID<br>ТX-02Y<br>MemberID<br>MemberName<br>MA100<br>Anita<br>MA108<br>Joey<br>Francis<br>TR-21Y<br>MA109<br>TZ-19Y<br>MemberListB<br>MemberD<br>MemberName<br>ProjectID<br>TX-02Y<br>MA100<br>Anita<br>Rashid<br>MA103<br>ТX-37Y<br>TX-37Y<br>MA104<br>Hassan<br>MA108<br>Joey<br>Mohan<br>TR-21Y<br>MA101<br>TX-38Y<br>MissionCriticalProject<br>ProjectID<br>ТX-02Y<br>ProjectDesc<br>R&D of Product Model ABC<br>Product development proposal<br>3D Modelling<br>Scale-up Protocol<br>ТX-37Y<br>TZ-19Y<br>TR-21Y<br>Produce a resulting table with data after each of the following relational join operations has been<br>performed:<br>(i)<br>(SELECT * FROM MemberListA)<br>UNION ALL<br>(SELECT * FROM MemberListB);<br>(ii)<br>(SELECT * FROM MemberListB)<br>MINUS<br>(SELECT * FROM MemberListA);<br>(iii)<br>(SELECT * FROM MemberListA)<br>INTERSECT<br>(SELECT * FROM MemberListB);<br>

Extracted text: Consider the following records in MemberListA, MemberListB and MissionCriticalProject tables: MemberListA ProjectID ТX-02Y MemberID MemberName MA100 Anita MA108 Joey Francis TR-21Y MA109 TZ-19Y MemberListB MemberD MemberName ProjectID TX-02Y MA100 Anita Rashid MA103 ТX-37Y TX-37Y MA104 Hassan MA108 Joey Mohan TR-21Y MA101 TX-38Y MissionCriticalProject ProjectID ТX-02Y ProjectDesc R&D of Product Model ABC Product development proposal 3D Modelling Scale-up Protocol ТX-37Y TZ-19Y TR-21Y Produce a resulting table with data after each of the following relational join operations has been performed: (i) (SELECT * FROM MemberListA) UNION ALL (SELECT * FROM MemberListB); (ii) (SELECT * FROM MemberListB) MINUS (SELECT * FROM MemberListA); (iii) (SELECT * FROM MemberListA) INTERSECT (SELECT * FROM MemberListB);

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here