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 |