• /MaihHow many floors does the hotel have? 3How many rooms are on floor 1? 6Please enter 10 or more: 10How many of those rooms are occupied? 10How many rooms are on floor 2? 10How many of those rooms are occupied? 3How many rooms are on floor 3? 10How many of those rooms are occupied? 6The hotel has a total of 30 rooms.19 are occupied.11 are empty.The occupancy rate is 63.3% How many rooms are on floor 10? 22How many of those rooms are occupied? 1How many rooms are on floor 11? 12How many of those rooms are occupied? 3How many rooms are on floor 12? 12How many of those rooms are occupied? 9How many rooms are on floor 14? 12How many of those rooms are occupied? 12The hotel has a total of 163 rooms.81 are occupied.82 are empty.The occupancy rate is 49.7%

n=int(input("How many floors does the hotel have"))sum=0sum1=0for i in range(1,n+1): print("How…

How many flo0Is does the hotel have? 3 How many rooms are on floor 1? 6 Please enter 10 or more: 10 How many of those rooms are occupied? 10 How many rooms are on floor 2? 10 How many of those rooms are occupied? 3 How many rooms are on floor 3? 10 How many of those rooms are occupied? 6 The hotel has a total of 30 rooms. 19 are occupied. 11 are empty. The occupancy rate is 63,3%

How many flo0Is does the hotel have? 3 How many rooms are on floor 1? 6 Please enter 10 or more: 10 How many of those rooms are occupied? 10 How many rooms are on floor 2? 10 How many of those rooms are occupied? 3 How many rooms are on floor 3? 10 How many of those rooms are occupied? 6 The hotel has a total of 30 rooms. 19 are occupied. 11 are empty. The occupancy rate is 63,3%

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
List the names of all customers that have a credit limit of $7,500 or less
Use an IF function to determine if the month in the employee's birth date in Cell C2 matches the value in Cell X1.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1 Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ; Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64
Every supper key is also a primary key True or false?
so which answer choices are correct ?
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
For questions 10, 11, 12, in the options, there are no options in which c1=2 for ech of the questions, can you tell me correct options for 10 11 and 12?
1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
How many homes/apartments/etc. are in your masm etymology?
can you slove more 3 queries