Answered step by step
Verified Expert Solution
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,
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
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