Create trigger betrag
after insert on Ticket
begin
	insert into Ticket_kostet_Betrag(NEW.ID, 'Grundbetrag')
end;


create trigger betragKinderticket
after insert on Ticket
when exists (
	select *
	from Ticket
	where ID = NEW.ID
	and Kinderticket = TRUE
)
begin
	insert into Ticket_kostet_Betrag values (NEW.ID, 'Kinderticket')
end;
end;


create trigger betragDreiD
before insert on Ticket
when exists(
	select *
	from Vorstellung
	where ID = New.ID
	and DreiD = TRUE
)
begin
	insert into Ticket_kostet_Betrag values (NEW.ID, '3D')
end;
end;


create trigger betragUeberlaenge
before insert on Ticket
when exists (
	select *
	from Film f, Vorstellung v
	where v.FilmID = f.ID
	and v.ID = NEW.ID
	and f.Spiellaenge > 120
)
begin
	insert into Ticket_kostet_Betrag values (NEW.ID, 'Ueberlaenge')
end;
end;