Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

b) (6 Points] Consid er the following tables in HOTEL schema in an RDBMS environment Hotel (HOTEL NO, HOTEL NAME, CITY) Room (ROOM-NO, HOTEL-NO, TYPE,

image text in transcribed

b) (6 Points] Consid er the following tables in HOTEL schema in an RDBMS environment Hotel (HOTEL NO, HOTEL NAME, CITY) Room (ROOM-NO, HOTEL-NO, TYPE, PRICE) Booking (HOTEL NO, GUEST NO, DATE FROM, ROOM NO) Guest (GUEST _NO, GUEST NAME, GUEST ADDRESS) Pretend you are database optimizer and determine if the following SQL syntax is any) and write what the error is on the right hand side Underline the error (if correct. 1. SELECT R.TYPE, R.PRICE FROM Room R, Hotel H WHERE RHOTEL NUM H HOTEL NUM AND H.HOTEL NAME - ' 2. SELECT G.GUEST_NO,G.GUEST_NAME Marriott' AND RTYPE 250 FROM Guest G, Booking B, Hotel H WHERE R.HOTEL NO B.HOTEL NO AND H.HOTEL NAME "Hilton; 3. SELECT R.ROOM NO, HOTEL No FROM Room R, Hotel H, Booking B WHERE H.HOTEL NO B.HOTEL NO AND H.HOTEL NO '12345' AND R.ROOM NO B.ROOM NO AND R.TYPE> S' AND B. HOTEL NO 54321

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_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions

Question

List some areas of application of KNN.

Answered: 1 week ago