## Authors

id | name | email | phone | address
--- | --- | --- | --- | ---
1 | John Doe | john@example.com | 123-456-7890 | 123 Main St
2 | Jane Smith | jane@example.com | 987-654-3210 | 456 Elm St
3 | Alice Brown | alice@example.com | 555-555-5555 | 789 Oak St
4 | Bob Johnson | bob@example.com | 111-222-3333 | 100 Pine St
5 | Charlie Davis | charlie@example.com | 444-444-4444 | 200 Maple Ave

## Publications

id | name | circulation_numbers | location
--- | --- | --- | ---
1 | The Daily News | 20000 | USA
2 | The Weekly Times | 15000 | Canada
3 | Time Magazine | 20000 | USA
4 | Newsweek | 12000 | UK
5 | Business Today | 10000 | India

## Articles

id | title | content | pub_date | author_id | publication_type
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Authors.id) |
1 | Article Title 1 | Content of Article 1 | 2022-01-01 | 1 | Print
2 | Article Title 2 | Content of Article 2 | 2022-01-02 | 2 | Online
3 | Article Title 3 | Content of Article 3 | 2022-01-03 | 3 | Print
4 | Article Title 4 | Content of Article 4 | 2022-01-04 | 4 | Online
5 | Article Title 5 | Content of Article 5 | 2022-01-05 | 5 | Print

## Category

id | descr
--- | ---
1 | Politics
2 | Economy
3 | Technology
4 | Entertainment
5 | Sports

## ArticleCategory

article_id | cat_id
--- | ---
(→ Articles.id) | (→ Category.id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## PublicationsPeriodicals

publication_id | periodical_type
--- | ---
(→ Publications.id) |
1 | Newspaper
2 | Newspaper
3 | Magazine
4 | Magazine
5 | Journal