How to write a stored procedure to create view?

Question

How to write a stored procedure to create view in the database? 

Stored Procedure needs to be dynamic if any record update any of the above tables it should update the views.

 

Table Name : Member

Database Name:  DataMart

 

Thanks,