Your task is to create a database for Greenwich City Letting Agency. The agency manages the renting of properties in the town of Greenwich and its environs. The database will record information about owners and their properties, the tenants who rent the properties and the rental information such as date tenancy commences and ends. The types of properties are flats, houses, studio apartments and single rooms in multiple occupancy houses. All rented properties have one or more rooms. The rental charges are inclusive of utility bills which are electricity, heating, gas and water. All these are charged per calendar month and is payable upfront.

1. Using the above scenario identify and describe the entities required for modelling.
2. For each entity identified in (a), produce the physical model of the Entity Relationship Diagram (ERD). Ensure that the atomic metadata are included in the model.