Consider the following relational database schema. The primary keys are underlined. The foreign keys are self-explanatory.
TRAVELLER (Id_no, Name, Address, Mobile, Occupation)
RESIDES_IN (Id_no, H_name, Date_booked)
HOTEL (H_name, Address, Landmark, Has_restaurant, Email, Phone)
2. Use join query to display hotel name, hotel address and name and mobile number of travellers who stayed in hotel that has restaurant.
3. Use set operator to display name of the hotel and address of hotels that have not been booked since March 23, 2020.
4. Display name, address and
Answers
Answered by
0
Answer:
yes this is your homework you can do it
Similar questions