Answer:
The trigger code is given below
create trigger F1_Del
after delete on Friend
for each row
when exists (select * from Friend
where ID1 = Old.ID2 and ID2 = Old.ID1)
begin
delete from Friend
where (ID1 = Old.ID2 and ID2 = Old.ID1);
end
create trigger F1_Insert
after insert on Friend
for each row
when not exists (select * from Friend
where ID1 = New.ID2 and ID2 = New.ID1)
begin
insert into Friend values (New.ID2, New.ID1);
end
Answer:
A. Technicians A and B
Explanation:
When we're talking about generic scanners and about all OBD-II codes, in this case, both technician A and B is the correct answer. Because we can scan all OBD-II codes with a generic scan.
But the technician A just says generic tools must be able to read all generic OBD-II codes and technicians B just says generic scan tools must be able to read manufacture OBD-II code, both are correct.
Answer:
<em>The specific type of software useful in this situation would be a ship manager software. </em>
Explanation:
<em>It is a stand alone, user installable, windows-based software package designed to allow the quickly ship, track, and report the daily activities.</em>
<em>In addition to managing shipment information, the software keeps the details of the operation, so that the user can easily retrieve necessary information about his shipments.</em>