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 |