You are asked to add three new products to an existing order with OrderID $=11061.$ The additional records need to be added to the OrderDetails table with the following information:

Record $1$

OrderID $=11061$

ProductID $=62$

UnitPrice $=45$

Quantity $=10$

Discount $=0$

Record $2$

OrderID $=11061$

ProductID $=70$

UnitPrice $=14$

Quantity $=25$

Discount $=0$

Record $3$

OrderID $=11061$

ProductID $=1000$

UnitPrice $=100$

Quantity $=5$

Discount $=0$

Incorporate the SQL insert statements for the new records into the transaction block specified below and execute in a Microsoft SSMS query window:

BEGIN TRANSACTION NewOrderDetails

BEGIN TRY

COMMIT TRANSACTION NewOrderDetails;

END TRY

BEGIN CATCH

ROLLBACK TRANSACTION NewOrderDetails

END CATCH

SELECT $*$ FROM OrderDetails

WHERE OrderID $=11061$;

Briefly explain what happened with the execution of this transaction. Do the new records get inserted into the OrderDetails table? If not, why?