I need to know how do I create a star schema for the data warehouse to accommodate the information below:
A data warehouse is required to accumulate information on the rental market in London. It will hold information on landlords and tenants (names), houses (no of rooms, type of housing (e.g. flat, house, etc), location (e.g. Chelsea, Camden, etc), the date of tenancy agreement, and the rental price.
The schema should indicate the dimensions and fact table with some reasonable attributes, the primary and foreign keys and relationships.