Send an error message if the operation is unsuccessful or the data is invalid.
4. (2 points) Create trigger Trigger_1: When updating the value of the EndTime
column in the Bill table, calculate and update the total_amount, and additionally
update the status_bill column from C to U, and update the table status to A (Available).The formula for total amount is:
total_amount = DATEDIFF(MINUTE, StartTime, EndTime) * hourly_rate / 60.
5. (2 points) Create a view to display a list of customers who have played billiards at the club more than twice. The list includes customer ID, customer name, and number
of visits.
End
Zoom
+ 100%
Close
