This assignment will have you create tables and write SQl code for the three tables shown below as pa of the Orange Krate data model using Stored Procedure(SPROC) Title Type Genre PK Title Type ID int PK Genre ID int Type Media varchar(5) varchar(10) Genre varchar(30) Title PK Title ID int Title varchar(30) FK1 Title Type_ID int int FK2 Genre ID Steps to follow: 1) Create all three tables as shown above using SQL Server by writing SQL code. Do not use GUI 2) Establish relationship/constraint as shown above between three tables by writing SQL code. Refer to material covered in class 3) Write three Stored Procedures, one for each table to insert and update data into all tables. Follow rules for creating and naming SPROC as covered in class. Insert a minimum of 10 rows of data in table Genre Insert a minimum of 15 rows of data in table Title Insert 2 rows of data in table Title.Ixpe Remember to validate code and include ERROR handling as needed. Make sure that all possible scenarios are taken into consideration just like we covered in class. . . . Check all conditions before you turn in work Pay close attention to code indentation. . Write a minimum of 5 Unit tests to validate for each SPross Make sure that you provide at least 3 examples/unit tests for updating data in all three tables using the SPress that you just created 203 words English (United States This assignment will have you create tables and write SQl code for the three tables shown below as pa of the Orange Krate data model using Stored Procedure(SPROC) Title Type Genre PK Title Type ID int PK Genre ID int Type Media varchar(5) varchar(10) Genre varchar(30) Title PK Title ID int Title varchar(30) FK1 Title Type_ID int int FK2 Genre ID Steps to follow: 1) Create all three tables as shown above using SQL Server by writing SQL code. Do not use GUI 2) Establish relationship/constraint as shown above between three tables by writing SQL code. Refer to material covered in class 3) Write three Stored Procedures, one for each table to insert and update data into all tables. Follow rules for creating and naming SPROC as covered in class. Insert a minimum of 10 rows of data in table Genre Insert a minimum of 15 rows of data in table Title Insert 2 rows of data in table Title.Ixpe Remember to validate code and include ERROR handling as needed. Make sure that all possible scenarios are taken into consideration just like we covered in class. . . . Check all conditions before you turn in work Pay close attention to code indentation. . Write a minimum of 5 Unit tests to validate for each SPross Make sure that you provide at least 3 examples/unit tests for updating data in all three tables using the SPress that you just created 203 words English (United States