A trigger sounds like the most logical solution to me. It would ensure the history table is updated immediately whenever a row is deleted from the main table.
I'm not entirely sure about this one. The options seem a bit vague, and I'm not confident I fully understand the requirements. I'll need to review the question again and maybe consult the course materials.
Brandon
4 months agoVicky
4 months agoMi
5 months agoGerald
5 months agoDominga
5 months agoBong
5 months agoBea
5 months agoRosamond
5 months agoNatalie
5 months agoSunny
5 months agoLeatha
5 months agoLouis
5 months agoRanee
6 months ago