Reference no: EM132914929
Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address, city and URL. Every country is identified by country code, country name and country currency. Guests staying in the hotel is identified by guest number, guest name, guest address and guest city. Every room in the hotel is identified by room number, and room floor. Every room booking is identified by booking id, starting date, and ending date. There are different types of rooms in the hotel. Each room type is identified by room type code, room standard rate, and description. In each country, there may be no hotels or more than one hotel. A hotel may have one or more rooms. A guest can book one or more rooms and a room may be booked by one or more guests. A hotel may have one or more bookings and each booking is associated with exactly one hotel. Each room type may have one or more rooms and a room belongs to one room type.
1. Write the schema of the appropriate relations for the above scenario. Identify the primary key and the foreign key in each of the relations. How did you identify the primary key and foreign key? Explain.
2. Use the designed relations to write SQL statements for the following questions: - Explain the working of each query in detail.
a. Display all the rooms having the same rate in the ascending order of room rate.
b. List the number of hotels in each country. Only include countries with more than 4 hotels.
c. Display the details of hotels that is not yet included in any booking.
d. Display all the details of guests who booked hotels on ‘2021-05-01'.
e. Display the room number, room standard rate and the hotel id.
f. Display the details of countries with country name starting with letters other than any letter within 'A' and 'P'.
Affect the standards for network security
: What do you think were the critical factors that fueled the need for IT governance? In what ways did ISO affect the standards for network security?
|
Effect of information technology in business process
: This is a essay writing and I want your response to touch on the benefits of Information Technology in a Business proces
|
Interpersonal factors of product influence buying decisions
: Discuss how core factors, cues to quality, and interpersonal factors of a product influence your buying decisions.
|
What are the first year net profit
: A company's annual operating expenses are $9 million. In their first year of operation, revenues are $2 million, what are the first year net profit
|
Hotels in different countries
: Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address,
|
What amount of ForCo interest income is US source
: ForCo, a foreign corporation, receives interest income of $50,000 from USCo, What amount of ForCo's interest income is US source
|
What is the cash value of this annuity due at end of year
: At the beginning of each period for 10 years, Merl Agnes invests $500 semiannually at 6%. What is the cash value of this annuity due at the end of year 10
|
How might offices physically change in coming years
: Given the growth in telecommuting and other mobile work arrangements, how might offices physically change in the coming years?
|
What total amount should be debited or credited
: What total amount should be debited or credited to retained earnings as a result of the sale of equity securities in 2021? Indicate if debit or credit
|