Dimension Tables and Facts for Data-Topia Kingdom
Dimension Tables
1. Population Table
This table contains information about the population of various regions in Data-Topia.
| Column Name | Data Type | Description |
| region_id | integer | Unique identifier for the region |
| population | integer | Total population of the region |
| ruler_name | varchar(50) | Name of the region's ruler |
| language | varchar(50) | The predominant language spoken in the region |
| year | int | The year when the population was counted |
2. Food Table
This table contains information about the food preferences and availability in Data-Topia.
| Column Name | Data Type | Description |
| food_id | integer | Unique identifier for the food |
| food_name | varchar(50) | Name of the food |
| region_id | integer | The region where the food is predominantly consumed |
3. Culture Table
This table contains information about the culture and traditions of different regions of Data-Topia.
| Column Name | Data Type | Description |
| region_id | integer | Unique identifier for the region |
| month | int(2) | Month of the year when the event happens |
| cultural_events | varchar(200) | Major cultural events celebrated in the region |
| traditional_attire | varchar(50) | Traditional clothing worn in the region |
4. Trade Table
This table contains information about the trade routes and commodities traded in Data-Topia.
| Column Name | Data Type | Description |
| trade_id | integer | Unique identifier for the trade route |
| trade_route | varchar(100) | Name of the trade route |
| region_id | integer | The region where the trade route begins |
| commodity | varchar(50) | The commodity traded along the route |
| trade_partner | varchar(50) | The region where the commodity is traded |
Facts
1. Trade Fact Table
This fact table contains information about the trade volume and revenue generated by different trade routes in Data-Topia.
| Column Name | Data Type | Description |
| trade_id | integer | Unique identifier for the trade route |
| region_id | integer | The region where the trade route begins |
| trade_volume | integer | The volume of the commodity traded |
| revenue | decimal | The revenue generated by the trade |
| date | date | Date when the trade happened |
2. Climate Fact Table
This fact table contains information about the effect of climate on the food availability in different regions of Data-Topia.
| Column Name | Data Type | Description |
| region_id | integer | Unique identifier for the region |
| temperature | integer | Average temperature in Celsius |
| precipitation | decimal | Average precipitation in mm |
| date | date | Registered date |
| food_id | integer | Unique identifier for the food |
| availability | varchar(1) | Whether the food is easily available or not |
| is_delicious | boolean | Whether the food is considered delicious or not |
Fun Fact
Data-Topia is known for its unique cuisine, with each region having its own specialties. The most popular dish in the kingdom is the 'Data-Biryani', a spicy rice dish made with locally grown herbs and spices.
