Database

please answer as soon as possible

Section A Application-Based Question(s) 50 Marks Question 1 Joining of tables allows you to join multiple tables using different techniques. A part of payroll system of an organisation is shown in Table 1. Assume that the first three tuples are assigned to X and the second three tuples are assigned to be Y. Age Level 34 7 43 9 Staff_id 0001 0002 0003 0004 0005 0006 Table 1 Name Themba Julian Christopher Mandla Tobogo Samson 26 Null 56 10 37 7 29 Null Perform outer joining operations on these tuples by answering the following questions: 1.1 Display the whole (full) outer join of the provided Table 1 with itself (Condition Staff_id=Staff_id). (3 Marks) 1.2 Display the left outer join of X with itself (Condition Staff_id=Staff_id). (3 Marks) 1.3 Display the right outer join of X with itself (Condition Staff_id=Staff_id). (3 Marks) 1.4 Display the left outer join of Y with itself (Condition Staff_id=Staff_id). (3 Marks) 1.5 Display the right outer join of Y with itself (Condition Staff_id=Staff_id). (3 Marks) [Sub Total 15 Marks] Question 2 Consider Table 1 and the specified tuples, and answer the following questions: 2.1 Display the left outer join of X with Y (Condition Staff_id=Staff_id). (5 Marks) 2.2 Display the right outer join of X with Y (Condition Staff_id=Staff_id). (5 Marks) 2.3 Display the full outer join of X with Y (Condition Staff_id=Staff_id). (5 Marks) [Sub Total 15 Marks]