| id | group_name | population |
|---|---|---|
| 1 | Age Group A | 100000 |
| 2 | Gender Group B | 200000 |
| 3 | Income Level C | 300000 |
| 4 | Education Level D | 400000 |
| 5 | Occupation E | 500000 |
| field_id | field_name |
|---|---|
| 1 | Politics |
| 2 | Technology |
| 3 | Entertainment |
| 4 | Business |
| 5 | Health |
| magazine_id | title | publication_date | demographic_group_id | professional_field_id |
|---|---|---|---|---|
| (→ Demographic_Groups.id) | (→ Professional_Fields.field_id) | |||
| 1 | News Weekly | 2023-01-01 | 1 | 1 |
| 2 | Tech Monthly | 2023-01-15 | 2 | 2 |
| 3 | ShowBiz Daily | 2023-01-07 | 3 | 3 |
| 4 | Money Matters | 2023-01-10 | 4 | 4 |
| 5 | Wellness Magazine | 2023-01-12 | 5 | 5 |
| article_id | title | content | author_id | magazine_id |
|---|---|---|---|---|
| (→ Authors.author_id) | (→ Magazines.magazine_id) | |||
| 1 | Breaking News | Latest news... | 1 | 1 |
| 2 | New Tech Innovations | Discover new tech products... | 2 | 2 |
| 3 | Celebrity Interviews | Exclusive interviews with stars... | 3 | 3 |
| 4 | Stock Market Update | Market analysis and tips... | 4 | 4 |
| 5 | Yoga for Health | Benefits and practices of yoga... | 5 | 5 |
| author_id | name | occupation | demographic_group_id |
|---|---|---|---|
| (→ Demographic_Groups.id) | |||
| 1 | John Doe | Journalist | 1 |
| 2 | Jane Smith | Editor | 2 |
| 3 | Tom Brown | Photographer | 3 |
| 4 | Alice Johnson | Reporter | 4 |
| 5 | Bob Williams | Columnist | 5 |
| reader_id | name | preferred_magazine_id | demographic_group_id | |
|---|---|---|---|---|
| (→ Magazines.magazine_id) | (→ Demographic_Groups.id) | |||
| 1 | Alice Jones | alice@example.com | 1 | 1 |
| 2 | David Miller | david@example.com | 2 | 2 |
| 3 | Emma Taylor | emma@example.com | 3 | 3 |
| 4 | George Wilson | george@example.com | 4 | 4 |
| 5 | Hannah King | hannah@example.com | 5 | 5 |