Create a stored procure and execution part also needed. Stored Procedure Name Brief Description Input Parameters Output

Create a stored procure and execution part also needed.

Transcribed Image Text:

Stored Procedure Name Brief Description Input Parameters Output Parameters Functionality Return Values usp_RegisterUser This procedure is used to insert the details of a customer into the table 'tbl_User' by performing the necessary validations based on the business requirements UserId UserName, User Password, Gender, Emailld, DateOfBirth, Address Error Number, ErrorMessage Check if all the input parameters except address are not null Check if the User Id contains minimum of 4 and maximum 40 characters Check if the length of the password contains minimum 8 and maximum 15 characters . . . Check if the age of customer is at least 18 years . If all the validations are successful, fetch the RoleID for the role 'Customer' Insert a record into the table 'tbl_User' with the appropriate values • • In case of any exception, return the error number and the error message ● 1 in case of successful insertion Check if the gender is 'F' or 'M' Check if the date of birth is less than current date ● -1 if UserId is null ● . . -2 if UserName is null -3 if UserPassword is null -4 if Gender is null -5 if DateofBirth is null -6 if the length of User Id is invalid -7 if the length of password is invalid -8 if gender is invalid -9 if date of birth is not less than current date + 140 % Stored Procedure Name Brief Description Input Parameters Output Parameters Functionality Return Values usp_RegisterUser This procedure is used to insert the details of a customer into the table 'tbl_User' by performing the necessary validations based on the business requirements UserId UserName, User Password, Gender, Emailld, DateOfBirth, Address Error Number, ErrorMessage Check if all the input parameters except address are not null Check if the User Id contains minimum of 4 and maximum 40 characters Check if the length of the password contains minimum 8 and maximum 15 characters . . . Check if the age of customer is at least 18 years . If all the validations are successful, fetch the RoleID for the role 'Customer' Insert a record into the table 'tbl_User' with the appropriate values • • In case of any exception, return the error number and the error message ● 1 in case of successful insertion Check if the gender is 'F' or 'M' Check if the date of birth is less than current date ● -1 if UserId is null ● . . -2 if UserName is null -3 if UserPassword is null -4 if Gender is null -5 if DateofBirth is null -6 if the length of User Id is invalid -7 if the length of password is invalid -8 if gender is invalid -9 if date of birth is not less than current date + 140 %

Answer rating: 100% (QA)

The image provided appears to show a set of requirements for a stored procedure named uspRegisterUser This stored procedure is intended to insert the details of a customer into a table named tblUser a... View the full answer