| AuthorID | FirstName | LastName | |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| PubID | Name | Digital_communication | Magazine | Printed_version |
|---|---|---|---|---|
| 1 | The New Yorker | Social Media | The New Yorker | 1 |
| 2 | Another Magazine | Social Media | Some Other Magazine | 0 |
| 3 | Email Updates | Email Newsletters | The New Yorker | 1 |
| 4 | More Info | Email Newsletters | Another Company | 0 |
| ArticleID | Title | Content | PublishDate | AuthorID | PubID | CategoryID |
|---|---|---|---|---|---|---|
| (→ Authors.AuthorID) | (→ Publications.PubID) | (→ Categories.CategoryID) | ||||
| 1 | Article 1 | Content of article 1 | 2023-01-01 10:00:00 | 1 | 1 | 1 |
| 2 | Article 2 | Content of article 2 | 2023-01-02 10:00:00 | 2 | 2 | 2 |
| 3 | Third Article | Content of third article | 2023-01-03 10:00:00 | 1 | 3 | 3 |
| 4 | Fourth Article | Content of fourth article | 2023-01-04 10:00:00 | 2 | 4 | 4 |
| 5 | Fifth Article | Content of fifth article | 2023-01-05 10:00:00 | 1 | 5 | 5 |
| CategoryID | Name |
|---|---|
| 1 | Politics |
| 2 | Technology |
| 3 | Culture |
| 4 | Business |
| 5 | Health |