Database normalization (NF)

How to create a view in sql server

How to using triggers in SQL Server to keep a history