Question
Using the San Juan Sailboat Charters model, create the following triggers (we're having trouble with the Oracle 12c code): the company would like to enforce
Using the San Juan Sailboat Charters model, create the following triggers (we're having trouble with the Oracle 12c code):
the company would like to enforce the following business rules by the database system: (1) the database should not allow overbooking. In other words, the system should automatically make a boat unavailable for the days when it was leased out. When the boat is returned, it becomes available again. To simplfy the system, you may assume no reservation is taken; first come and first serve. (2) late return penalty is $75 each day late. the fine should be automatically calculated and added to the customer balanace. if a customer returns the boat early, a refund of $20 each day returned early will be calculated and credited to the customer automatically. (3) No boat rental is allowed if a customer's unpaid balance exceeds $400.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started