Reset the Chapter$7.$Students table and Chapter$7.$StudentAudit table back to no data.

$--$ GO

CREATE OR ALTER TRIGGER Chapter$7.$trgStudentsInsertCheckGPA

ON Chapter$7.$Students

INSTEAD OF INSERT

AS

SET NOCOUNT ON;

DECLARE @studentId AS INT;

DECLARE @newGpa AS DECIMAL$(3,2)$;

SELECT @newGpa $=$ StudentGpa FROM INSERTED;

BEGIN

IF$($@newGpa $>4\mathrm{.}0$ OR @newGpa $<0\mathrm{.}0)$

BEGIN

RAISERROR$(\text{'}$GPA must be between $0$ and $4\mathrm{.}0\text{'},16,1)$;

ROLLBACK;

END

ELSE

BEGIN

INSERT INTO Chapter$7.$Students

$($StudentName$,$ StudentGpa$)$

SELECT StudentName, StudentGpa

FROM INSERTED;

SET @studentId $=$ SCOPE$\_$IDENTITY$()$;

INSERT INTO Chapter$7.$StudentsAudit

$($StudentId$,$ StudentName, StudentGpa, AuditAction$)$

SELECT @studentId, studentName, studentGpa,

'Insert a new student'

FROM inserted;

PRINT$(\text{'}$Record inserted'$)$;

END;