DRAG DROP
You are a Microsoft SQL Server client tools to develop a Microsoft Azure SQL Database database that supports an e-learning application. The database consists of a Course table, a Subject table, and a CourseSubject table as shown in the exhibit. (Click the Exhibit button.)
You need to write a trigger that meets the following requirements:
Subjects are not physically deleted, but are marked as deleted.
When a subject is deleted, the courses that offer that subject are marked as discontinued.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Select and Place: