PERSON table:

person_id      first_name         last_name
1              PETER              PARKER

STUDENT table:

person_id      student_number
1              STUD-001

ADDRESS table:

person_id      address
1              Daily Bugle, New York City

PHONE table:

person_id      landline
1              123-45-67

ALTER PROCEDURE [dbo].[SP_UPDATE_STUDENT_RECORD]
	-- Add the parameters for the stored procedure here
	@idstudent AS NVARCHAR(20),
	@studfname AS NVARCHAR(50),
	@studmname AS NVARCHAR(50),
	@studlname AS NVARCHAR(50),
	@studaddress1 AS NVARCHAR(50),	
	@studphone1 AS NVARCHAR(50)
	
AS
BEGIN
	SET NOCOUNT ON;
	WITH STUDENT_RECORD AS (
	   SELECT s.STUDENT_NUMBER AS ID, p.FIRST_NAME, p.MIDDLE_NAME,
              p.LAST_NAME, a.ADDRESS, c.LANDLINE

	   FROM PERSON AS p, STUDENT AS s, ADDRESS AS a, PHONE AS c

	   WHERE (p.PERSON_ID = s.PERSON_ID)  AND (p.PERSON_ID = a.PERSON_ID) AND (p.PERSON_ID = c.PERSON_ID)
				
				
	) UPDATE [STUDENT_RECORD] SET [FIRST_NAME] =@studfname, [MIDDLE_NAME] = @studmname, [LAST_NAME]  = @studlname, [ADDRESS] = @studaddress1, [LANDLINE] =@studphone1 
	  WHERE [ID] =  @idstudent
    
END