After you determine a background of your project and collect information about the project. Each project would typically go through the following phases:
(1)Create a Database.
(2)Design the Data model using Database Diagrams.
(3)Create tables, including constraints such as primary keys, foreign keys, check constraints, and not null constraints. For the relationships, please add
foreign key constraints.
(4) Create Views.
(5)Create/Add stored procedures/functions/triggers.
(6)Documents the project.
Create/Add CLR store procedures, or functions.