Third Assignment : [Database Systems] [ First Semester 2023-2024] Assignment Deadline : 30/12/2023 1. Given two tables, "Employees" and "Departments," create a scenario where an outer join would be necessary for retrieving meaningful data. Provide the SQL query for performing the outer join. 2. Discuss briefly (3-5 lines) the differences between LEFT OUTER JOIN, RIGHT OUTER JOIN and FULL OUTER JOIN. You should also use a Venn diagram to illustrate the different types of joins. 3. Consider a table named "Students" with columns: StudentID, StudentName, Age, and GPA. Apply appropriate constraints to ensure the following conditions: - StudentID cannot be NULL. - StudentName must be unique. - Age should be greater than or equal to 18. - GPA should be between 0 and 4.0. Provide SQL statements to create the "Students" table with the specified constraints. 4. Create a scenario where using a view would be beneficial. Provide the SQL statement to create the view. Note: Please submit your solution as a PDF file