Question: eeew HelpTe This assignment will have you create tables and write SQL code for the three tables shown below as part of the Orange Krate
eeew HelpTe This assignment will have you create tables and write SQL code for the three tables shown below as part 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 varchart(30) Title PK Title ID int Title varchar(30) FK1 Title Type ID int int FK2 Genre_ID 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. (33 points) .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 Ips . Remember to validate code and include ERROR handlimg as needed Make sure that all possible scenarios are taken into consideration just like we covered in clas. .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 SProcs Make sure that you provide at least 3 examples/unit tests for updating data in all three tables using the SProcs that you just created ge 1 of 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
