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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!