Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Theory And Applications 27th Australasian Database Conference Adc 20 Sydney Nsw September 28 29 20 Proceedings Lncs 9877

Authors: Muhammad Aamir Cheema ,Wenjie Zhang ,Lijun Chang

1st Edition

3319469215, 978-3319469218

More Books

Students also viewed these Databases questions