Can someone please help me with this problem. Here is the scenario.

The Agency currently rents out various types of domestic accommodation (flats and houses) to clients. The clients (e.g. students or groups of students) may require 1 year leases or (e.g. families) longer term lets. Details are kept on each property and in particular: Address (this must be searchable by postcode or partial post code or by district) Owner details Lead tenant details Tenancy start Tenancy end Rent Type of property (flat, detached house, terrace house etc.) Furnished/Unfurnished (for Furnished, further details of the furnishings may be kept)

Number of bedrooms Number of bathrooms Number of reception rooms Optionally also: A textual description Photographs. A history of occupancy needs to be kept including periods were the property is unoccupied. In order to make searching for appropriate properties easier it has been decided that details of individual rooms within a property will also be stored. This will include: room type (bedroom/bathroom/kitchen etc.) room dimensions (in feet and meters) heating (e.g. radiator/fire) for kitchens: appliances for bathrooms: fittings any special features e.g. patio windows. The tourist business has started to boom in the area and the Agency wishes to move into the business of holiday lettings. This will involve much shorter lets and a much greater requirement for up to date availability information. 1. Using normalisation, create an entity relationship diagram for the scenario. Was it possible to go beyond third normal form? 2. Repeat the exercise but this time use entity modelling. Were the results the same? 3. Write the create statements necessary for the scenario. What constraints are necessary? 4. Create a query that retrieves a list of vacant properties (tenancy end date is before todays date) and their owner. Try grouping the properties by owner.

==> Really I need helping making the ER diagram (in UML format) and number 3 and 4 please.