Requirement 1 – Scalar Function Weight: 15 % Create a fun

Requirement 1 – Scalar Function Weight: 15 % Create a function to get a PersonID by SIN. The function shoulduse one parameter – to be used to reference the SIN field. The return type should be appropriate for returningPersonID. The function should return the PersonID of the person that is found. If it is not found, th… Show more… Show moreneed answer in SQL code Engineering & Technology Computer ScienceShare QuestionEmailCopy link This question was created from Case Study 2 Requirements F2021.docx