Using the Colonial Adventure Tours Database from A Guide To SQL (9th Edition), C

Question

Using the Colonial Adventure Tours Database from A Guide To SQL (9th Edition), Create a trip cost view that groups the trips by their cost. Produce a count of trips for each particular price, sorting them in ascending order by price. Could you update the underlying table(s) in the view? Why or why not?

Schema:

?eject Browser ? 127.0.0.1:8080/apex/f?p-4500:1001 :3654456629742387-NO::: ORACLE Application Express Welkome COLONIAL ADVENTURE Logout Application Builder? SQL Workshop Hame S0L Workshop Object Browser Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS HTMLDE PLAN TABLE RESLRVATION TRIP_GUIDES Appication Lxpress 4.0 2.00.09 Wolapac COLONIAL ADVENTURE Uaer COLONIAL ADVENTURF Language en Copynght &1330, 2010, Crade All rihts eserved

Explanation / Answer

The above is the view which is named as tripcost which will display the tripprice and the count of trips having for each particular price in the ascending order of the trip price.

No we can't update the data in the tables through the view. A view is used to just display the relevant data which is merged from multiple tables without having to show the complete data in the table. It is just for retrieving the required information from the tables.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.