1. Cruise(cid, name, number_of_days, price, number_of_stops) Port(pid, city, country, number_of_stars, capacity) Stops(cid, pid, stopno, stopduration) Assume that the number_of_stops attribute of the Cruise table contains the total number of stops for each cruise. Write a trigger that will be fired whenever the Stops table is modified to increase or decrease the number_of_stops value accordingly. *
1. Cruise(cid, name, number_of_days, price, number_of_stops) Port(pid, city, country, number_of_stars, capacity) Stops(cid, pid, stopno, stopduration) Assume that the number_of_stops attribute of the Cruise table contains the total number of stops for each cruise. Write a trigger that will be fired whenever the Stops table is modified to increase or decrease the number_of_stops value accordingly. *
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 1HOA
Related questions
Question
plz answer correctly!!! oracle pl/sql!! btw plz don't steal other answers from the internet because those answers are false if u know the pl/sql do the answer code without any plagiarism so...cuz 1 stolen code means 1 dislike and no money oke?
![1. Cruise(cid, name, number_of_days, price, number_of_stops)
Port(pid, city, country, number_of_stars, capacity)
Stops(cid, pid, stopno, stopduration)
Assume that the number_of_stops attribute of the Cruise table contains the total number of stops
for each cruise. Write a trigger that will be fired whenever the Stops table is modified to increase
or decrease the number_of_stops value accordingly. *](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Faedcb8c1-a85a-4c48-97b7-cd937673253c%2F9b4efab3-ec3d-42a6-a40c-53a5b404e8b1%2Fa5rs7k9_processed.png&w=3840&q=75)
Transcribed Image Text:1. Cruise(cid, name, number_of_days, price, number_of_stops)
Port(pid, city, country, number_of_stars, capacity)
Stops(cid, pid, stopno, stopduration)
Assume that the number_of_stops attribute of the Cruise table contains the total number of stops
for each cruise. Write a trigger that will be fired whenever the Stops table is modified to increase
or decrease the number_of_stops value accordingly. *
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)