Write the scalar function and stored procedure for the given database:

 

For each student, you must track the student's name, home telephone number, home address. You must also track enrollment status and the date that enrollment status started. For each faculty member, you must track the faculty member's name, office telepnorie number and office number. 0 The relationship between faculty and students is: each student must have one and only one academic advisor each facult, mem.er may have one or more student advisees any information such as neys, needed to train this relationship must also be modeled Names or the students academic advisor thesis advisor, the members of the thesis examining committee, and the thesis title all had to be recorded