Demographic_Groups

idgroup_namepopulation
1Age Group A100000
2Gender Group B200000
3Income Level C300000
4Education Level D400000
5Occupation E500000

Professional_Fields

field_idfield_name
1Politics
2Technology
3Entertainment
4Business
5Health

Magazines

magazine_idtitlepublication_datedemographic_group_idprofessional_field_id
(→ Demographic_Groups.id)(→ Professional_Fields.field_id)
1News Weekly2023-01-0111
2Tech Monthly2023-01-1522
3ShowBiz Daily2023-01-0733
4Money Matters2023-01-1044
5Wellness Magazine2023-01-1255

Articles

article_idtitlecontentauthor_idmagazine_id
(→ Authors.author_id)(→ Magazines.magazine_id)
1Breaking NewsLatest news...11
2New Tech InnovationsDiscover new tech products...22
3Celebrity InterviewsExclusive interviews with stars...33
4Stock Market UpdateMarket analysis and tips...44
5Yoga for HealthBenefits and practices of yoga...55

Authors

author_idnameoccupationdemographic_group_id
(→ Demographic_Groups.id)
1John DoeJournalist1
2Jane SmithEditor2
3Tom BrownPhotographer3
4Alice JohnsonReporter4
5Bob WilliamsColumnist5

Readers

reader_idnameemailpreferred_magazine_iddemographic_group_id
(→ Magazines.magazine_id)(→ Demographic_Groups.id)
1Alice Jonesalice@example.com11
2David Millerdavid@example.com22
3Emma Tayloremma@example.com33
4George Wilsongeorge@example.com44
5Hannah Kinghannah@example.com55