| ID | Year | Total_Subscribers | Digital_Subscribers | Print_Subscribers |
|---|---|---|---|---|
| 1 | 2022 | 10000 | 5000 | 5000 |
| 2 | 2023 | 15000 | 6000 | 9000 |
| ID | Year | Unique_Visitors | Pageviews | Bounce_Rate |
|---|---|---|---|---|
| 1 | 2022 | 20000 | 40000 | 0.75 |
| 2 | 2023 | 25000 | 50000 | 0.8 |
| ArticleID | Title | Author | Category | PublishDate | WordCount |
|---|---|---|---|---|---|
| 1 | The Impact of Climate Change on Agriculture | John Doe | Environment | 2024-03-13 18:06:58 | 1200 |
| 2 | Understanding the Quantum Computing Revolution | Jane Smith | Technology | 2024-03-13 18:06:58 | 1500 |
| 3 | The Rise of Renewable Energy Sources | Emma Johnson | Environment | 2024-03-13 18:06:58 | 1800 |
| AuthorID | FirstName | LastName | Bio |
|---|---|---|---|
| 1 | John | Doe | An environmental journalist with a passion for climate change. |
| 2 | Jane | Smith | A technology reporter who covers the latest advancements in the field. |
| 3 | Emma | Johnson | An experienced energy reporter focused on renewable sources. |
| CategoryID | Name |
|---|---|
| 1 | Politics |
| 2 | Economy |
| ArticleID | AuthorID |
|---|---|
| (→ Articles.ArticleID) | (→ Authors.AuthorID) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |