Section B: Expanding database functionality You will submit your SQL answers for questions 1,2, and 4 for this section as a .SQL file. Your response for Question 3 will need to be included with the .PDF submission for Section C. 1) Create and test a user-defined function named Last Name First#, where the # is your group number, that combines two parameters named FName and LName from the Employee entity into a single concatenated name field formatted as: LName, FName Be sure to include the comma and space. Provide the SQL script as your answer. 2) Create and test a view called EmployeesMedicalConcerns that contains the employee name of any employee who has a known allergy, along with their allergy. List a concatenated field aliased as EmpName, containing both Fname and Lname attributes as LName, FName, followed by a second field containing the AllergyName field. Provide the SQL script as your answer. 3) Part of your responsibilities as a DBA has you routinely cleansing data to ensure proper data formats are being enforced across all tables. This activity, while important, consumes a significant part of your time that could be better spent working on more value-add projects. You want to partially automate the process through the development of stored procedures but would need approval from your boss. Write a brief memo to Matt Kozi, Solutions Architect, explaining the purpose of stored procedures and how you would implement stored procedures to simplify administration of the database. For your ovamnlo to Mr Kazi you will be focusing on the Calan fiold in the Emnlovao tahlo WILL 1105 a Macy, alving wilay List a concatenated field aliased as EmpName, containing both Fname and Lname attributes as LName, FName, followed by a second field containing the AllergyName field. Provide the SQL script as your answer. 3) Part of your responsibilities as a DBA has you routinely cleansing data to ensure proper data formats are being enforced across all tables. This activity, while important, consumes a significant part of your time that could be better spent working on more value-add projects. You want to partially automate the process through the development of stored procedures but would need approval from your boss. Write a brief memo to Matt Kozi, Solutions Architect, explaining the purpose of stored procedures and how you would implement stored procedures to simplify administration of the database. For your example to Mr. Kozi, you will be focusing on the Salary field in the Employee table. This component assumes that your salary field was already set to INT and has no formatting. Task: Convert the INT to a CHAR (SQL command) Stored Procedure: Insert commas, decimal places and dollar signs where appropriate in the data for the salary attribute for the Employee entity. To answer this question, you are to provide a written explanation, not the SQL script. 4) Provide your employer with the SQL script needed to build the stored procedure listed above. Section C: Updating documentation The following questions require a written explanation that must be included as a separate file from your SQL scripts. You may include Section B. Question 3's written response in this part of the submission.