Exercise Create table ticketing {T_id, violation_type, city, National_id, t_amount} Insert some values Write procedure without parameter to update city to be Abha when T_id = 3 Write function that return the sum of all t_amount and call it in select query Write trigger to be executed after adding new violation by giving national id 0 and amount 0 Write event to add VAT value after one month

- Create table ticketing {T_id, violation_type, city,National_id, t_amount } - Insert some values - Write procedure without parameter to update city to be Abha when T_id =3 - Write function that return the sum of all t_amount and call it in select query - Write trigger to be executed after adding new violation by giving national id 0 and amount 0