Question

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)
 Implement the necessary SQL statements for creating the above tables with necessary primary key and foreign key.
 Enter at least two rows into each table and display the content of the tables.
Implement SQL statement for the following queries.
1. Use nested query to display name, mobile number and occupation of travellers who booked hotel in Bengaluru on December 25, 2019.
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 phone number of hotels that have been booked by at least 10 travellers after March 23, 2020.
5. Display name and mobile number of travellers who booked every hotel in Bengaluru.
6. Display name, address and landmark of hotels booked by maximum number of travellers in December 2019.

Answer 1

Answer:

Some of the new features included in Windows 7 are advancements in touch, speech[1] and handwriting recognition, support for virtual hard disks, support for additional file formats, improved performance on multi-core processors,[2] improved boot performance, and kernel improvements.

Explanation:

hope it will help....

plz follow me and thanks plzzzzz