Database Creation Project in SQL Server

In this project, I have created a Database called Printers_JS for a fictitious company that sells printers to its customers across the country.

Click the link below to see the T-SQL code used in MS SQL Server for the database creation, tables, relationships, and data insertion to the database: See the code

Click the link below to see the T-SQL code used in MS SQL Server for the creation of the stored procedures, where I use Variables and functions like Begin Tran, Try-Catch, and Scope_Identity to create a process of inserting sale records and update employees and products tables: See the code

Click the link below to see the T-SQL code used in MS SQL Server for the creation of the Views, where I create them using string functions and Joins to store data for later visualization: See the code