Dimension table of individual game titles
| Column | Type | Key |
|---|---|---|
| game_id | INTEGER | PK |
| title | VARCHAR | |
| genre | VARCHAR | |
| platform | VARCHAR | |
| publisher | VARCHAR |
Fact table of individual sale transactions
| Column | Type | Key |
|---|---|---|
| sale_id | INTEGER | PK |
| game_id | INTEGER | FK → games.game_id |
| region | VARCHAR | |
| sale_date | DATE | |
| units_sold | INTEGER | |
| revenue | DECIMAL |