⚔️
Skyland Dragon Riders: Dimensional Data Modeling
⚔️
✧ Introduction: The Skyland Archives ✧
“In the realm where islands float among the clouds and dragons soar through misty skies,
knowledge is power. The ancient archives must be rebuilt to preserve the wisdom of generations.”
— Grand Archivist Elyria
Welcome, apprentice data architect! The Council of Dragon Riders has summoned you to design
a dimensional data model for the Skyland Archives. This magical repository will help track dragons,
riders, patrols, supplies, and training across the floating islands.
✦
The Archmage of Data has outlined these requirements:
✦
🔥Dragons – Information about
each dragon (breed, age, element affinity)
🔥Riders – Details of dragon
riders (name, rank, academy training)
🔥Islands – Locations in the
skyland realm (name, region, elevation)
🔥Academies – Training centers
for riders (name, specialization)
🔥Supplies – Inventory of
essential items (name, category, measurement units)
🔥Time – Calendar periods
(date, month, season, holidays)
🔥Patrols – Records of
dragon/rider patrol missions
🔥Supplies Inventory – Stock
levels at different locations
🔥Training Sessions – Progress
tracking for dragon/rider training
📜
Your quest has multiple challenges:
The Arrangement – Arrange tables into a
dimensional schema (star or snowflake)
The Binding – Connect tables with proper
relationships
The Inscription – Assign columns to each table
The Enchantment – Define keys and data types
✧
Each step builds on the previous one. Prove your mastery by completing all challenges!
✧
✧ Challenge 1: Dimensional Schema Design ✧
“As the islands hang in perfect balance among the clouds, so must your tables be arranged in harmony.”
— Master Architect Thalorin
Arrange the tables into a meaningful dimensional schema. Drag tables from the pool on the left
to the canvas on the right. Position dimension tables around the fact tables to form either a star schema
(dimensions connect directly to facts) or a snowflake schema (some dimensions connect to other dimensions).
⊰ Table Pool ⊱
dim_dragons
dim_riders
dim_islands
dim_academies
dim_supplies
dim_time
fact_patrols
fact_supplies_inventory
fact_training_sessions
⍟
✧ Challenge 2: Table Relationships ✧
“Like the bonds between rider and dragon, strong relationships between tables create a powerful alliance.”
— Elder Sage Zephyra
Now, establish relationships between your tables:
Click on a source table (typically a dimension)
Click on a target table (typically a fact table)
Specify the relationship type (one-to-many, many-to-one, one-to-one)
Connect all tables according to proper dimensional modeling principles.
⍟
⊰ Relationship Type ⊱
✧ Challenge 3: Column Assignment ✧
“Each scroll must be placed in its proper shelf, each rune in its proper tome.”
— Librarian Mysteria
Assign the appropriate columns to each table. Drag columns from the pool to their correct tables.
Remember that dimension tables typically contain descriptive attributes, while fact tables contain
measures and foreign keys to dimensions.
⊰ Column Pool ⊱
⊰ Tables with Columns ⊱
✧ Challenge 4: Keys and Data Types ✧
“The right key opens the right lock. The right spell channels the right elements.”
— Archmage Valorian
For each column, specify:
Primary Key (PK) – The main identifier for each
record
Surrogate Key (SK) – A generated identifier
replacing natural keys
Data Type – INTEGER, VARCHAR, DECIMAL, DATE,
BOOLEAN
⊰ Define Keys and Data Types ⊱
✧✧ Quest Completed: Master of the Skyland Archives! ✧✧
❧☙☙❧
🐉 Congratulations, Master Architect! 🐉
📜
By the power vested in the Council of Dragon Riders, we hereby declare:
You have successfully designed the Dimensional Data Model for the Skyland Dragon Riders Archives!
Your schema will help the Council of Dragon Riders analyze patrol patterns, track training progress,
and manage supplies across the floating islands.
The Archmage of Data is impressed by your skills and awards you the title of “Master Data Architect.”
May your dimensional models always be balanced, your keys properly surrogate, and your facts always
surrounded by clear dimensions.
