Answer Happy

An AGC company has a large portfolio of luxury apartments which are rented out to business travellers. All apartments are classified into categories. Each category has a number of associated apartments. The category has category ID, category name (e.g. 1BR delux, 2BR classic, etc.) and associated price per night. An apartment belongs to only one category. Each apartment has apartment ID, address, and entrance keycode. When a business traveller books an apartment, the booking has check-in date and checkout date. An apartment can be booked multiple times by multiple business travellers. Each business traveller has an id, name, address, mobile phone number and email address. Each business traveller belongs to an organisation Every organisation has an ID and organisation name. Each organisation could have multiple business travellers. AGC would like to create reports such as: Which apartment has been booked the most? ● Which category is the least popular? Which organisation has booked the greatest number of days? Which traveller has had the greatest number of bookings?