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:
Always same value
Explanation:
These both code segments will always generate identical values given that we provide same value of k to both segments.
You can see attached pictures.
You have to subtract the tax amount by the final amount then multiply the result by the percentage of tip that is based on the service that you received.
Answer:
The following code is in python.
import statistics as st #importing statistics which include mean function.
def average(lst): #function average.
return st.mean(lst)#returning mean.
lst=a = list(map(int,input("\nEnter the list : ").strip().split()))#taking input of the list..
print("The average is "+str(average(lst)))#printing the average.
Output:-
Enter the list :
1 2 3 4 5 6
The average is 3.5
Explanation:
I have used the statistics library which includes the mean function that calculates the mean or average of the list.In the function average having lst as an argument returns the mean of the list lst.
Then taking lst input from the user and printing it's average.