Use triggers to maintain referential integrity, PL-S, Basic Computer Science

At times, Brewbean''s has changed the id number for existing products. In the past, they have had to add a new product row with the new id to the BB_PRODUCT table, modify all the corresponding BB_BASKETITEM and BB_PRODUCTOPTION table rows, and then delete the original product row. Can a trigger be developed to avoid all these steps and handle the update of the BB_BASKETITEM and BB_PRODUCT OPTION table rows automatically for a given change in product id? If so, create the trigger and test by issuing an update statement, which changes the IDPRODUCT of 7 to 22. Do a rollback to return the data back to its original state. Also, disable the new trigger after you have completed the assignment.
Posted Date: 11/11/2017 8:31:46 AM | Location : United States







Related Discussions:- Use triggers to maintain referential integrity, PL-S, Assignment Help, Ask Question on Use triggers to maintain referential integrity, PL-S, Get Answer, Expert's Help, Use triggers to maintain referential integrity, PL-S Discussions

Write discussion on Use triggers to maintain referential integrity, PL-S
Your posts are moderated
Related Questions
i need help with flowcharting a procedure

Classify computer systems according to capacity. How they are different from computers according to the classification of technology. Provide comparative study also.

mention the aims of education in present scenario

Example of autonomous rational agents-Artificial intelligence The procedure of waste water treatment After the level of pollutants in waste water is find out,  following 5

Artificial Intelligence Agents: We discussed what we will be talking about in Artificial Intelligence and why those things are important. This chapter is all about how we wi

SWITCHING MECHANISMS: Switching mechanisms are techniques devised to send messages in many dinections at once and to ensure that these messages are received with a minimum of

WHAT DO MEAN BY ALGORITHM,HOW CAN ALGORITHM HELP TO WRITE BETTER COMPUTER PROGRAM ,WRITE AN ALGORITHM IN COMPUTER INTEREST


Research and Development  All intellectual activities consciously pursued and systematically completed generate useful information. Research (also Research and Development) is

Question 1 Elaborate the various steps in performing a Mail Merge. Execute one mail merge operation for sending invitation for a conference which is being conducted in your organi