Scribd
Upload
6 views1 page

Imperial Hotel Guest Database Queries

The document outlines the creation of a database named 'Imperial hotel' with a table called 'Guests' to store guest information. It includes specific instructions for populating the table with data and creating various queries to filter and display guest information based on nationality, room status, accommodation fees, and other criteria. The queries aim to analyze guest data for insights such as total fees and discounts for VIP room bookings.

Uploaded by

mukisajeromu4
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views1 page

Imperial Hotel Guest Database Queries

The document outlines the creation of a database named 'Imperial hotel' with a table called 'Guests' to store guest information. It includes specific instructions for populating the table with data and creating various queries to filter and display guest information based on nationality, room status, accommodation fees, and other criteria. The queries aim to analyze guest data for insights such as total fees and discounts for VIP room bookings.

Uploaded by

mukisajeromu4
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Question 1

Create a database called Imperial hotel. With in this database design a table called Guests
that will be used to enter the information as seen in the table below.
GN0 L name Nationality Room N0 Date of Birth R status Acc fee N days
G001 Maina Kenyan 89 01/12/2012 Executive 80000 10
G002 Jimmy American 4 01/12/2011 Royal 60000 20
G003 Loy Tanzanian 11 02/12/2012 Executive 95000 30
G004 Dominic American 15 03/12/2012 VIP 120000 45
G005 Mathew British 19 03/12/2012 Executive 56000 15
G006 Norah Kenyan 17 04/12/2012 VIP 130000 60
G007 Hilda American 12 05/12/2012 Executive 95000 13
G008 Tim British 9 06/12/2012 VIP 140000 70
G009 Nancy Tanzanian 67 07/12/2012 VIP 140000 60
Required:
1. Create a database and its table in design view
2. Populate your table as seen in the table.
3. Create a query to display all the quests that are in Tanzanian nationals.
4. Create a query that will display all the guests who are not in VIP rooms.
5. Created a query to display all the guests who are either Kenyan or Tanzanian
nationals.
6. Create the query to display the American nationals who booked VIP rooms.
7. Create the query to display the American nationals who did not book VIP rooms.
8. Create a query to display all guests whose accommodation fee is less than 90000
9. Create a query to display all the guests whose accommodation is 100000
10. Create a query to display all the guests whose accommodation is above 80000 but
below 120000
11. Create a query to calculate the total fee paid by each customer.
12. Create a query which will display new accommodation fee for guests who booked
VIP rooms if a 20% discount was offered.
13. Create a query to display all the guests whose Lname contains letter “a” anywhere.

You might also like