Authors

idnameemailphoneaddress
1John Doejohn@example.com123-456-7890123 Main St
2Jane Smithjane@example.com987-654-3210456 Elm St
3Alice Brownalice@example.com555-555-5555789 Oak St
4Bob Johnsonbob@example.com111-222-3333100 Pine St
5Charlie Davischarlie@example.com444-444-4444200 Maple Ave

Publications

idnamecirculation_numberslocation
1The Daily News20000USA
2The Weekly Times15000Canada
3Time Magazine20000USA
4Newsweek12000UK
5Business Today10000India

Articles

idtitlecontentpub_dateauthor_idpublication_type
(→ Authors.id)
1Article Title 1Content of Article 12022-01-011Print
2Article Title 2Content of Article 22022-01-022Online
3Article Title 3Content of Article 32022-01-033Print
4Article Title 4Content of Article 42022-01-044Online
5Article Title 5Content of Article 52022-01-055Print

Category

iddescr
1Politics
2Economy
3Technology
4Entertainment
5Sports

ArticleCategory

article_idcat_id
(→ Articles.id)(→ Category.id)
11
22
33
44
55

PublicationsPeriodicals

publication_idperiodical_type
(→ Publications.id)
1Newspaper
2Newspaper
3Magazine
4Magazine
5Journal