a text file containing the sql transaction code 1

/in /by

Meadow has been having a discussion with Liam about how they can get new recipe data into the database once the system goes into production. Manually inserting them using the database tools will be difficult for someone unfamiliar with databases, so she is worried they may have difficulties with this in the future. She has been considering if transactions may possibly be used as a part of the recipe insertion process since they are an “All or Nothing” type of operation. Either the transaction succeeds or it doesn’t. She asks that you try to build a transaction that can assign a tag to a recipe.

  • Review the resources on transaction management.
  • Create a transaction that will map a tag to a recipe based on the recipe name and the tag name.
  • Submit a text file containing the SQL transaction code