## Newspapers

Id | Name | Location | YearEstablished
--- | --- | --- | ---
1 | The Guardian | London, UK | 1959
2 | The Washington Post | Washington, DC, US | 1877
3 | Le Monde | Paris, France | 1944
4 | El País | Madrid, Spain | 1976
5 | Asahi Shimbun | Tokyo, Japan | 1879

## Articles

Id | NewspaperId | Headline | Content
--- | --- | --- | ---
| (→ Newspapers.Id) |  |
1 | 1 | Climate Change Crisis | A detailed analysis of climate change and its effects on our planet...
2 | 2 | US Election Updates | An overview of the latest developments in the US Presidential election...
3 | 3 | Brexit Impact | How Brexit has affected the economy and daily life in Britain...
4 | 4 | Covid-19 Vaccine Rollout | Discussing the progress of Covid-19 vaccines worldwide...
5 | 5 | Tech Innovation Trends | Exploring the current trends in technology innovation...

## Authors

Id | FirstName | LastName | Email | PhoneNumber | ArticleId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Articles.Id)
1 | John | Doe | john.doe@example.com | +1234567890 | 1
2 | Jane | Smith | jane.smith@example.com | +0987654321 | 2
3 | Alice | Johnson | alice.johnson@example.com | +0123456789 | 3
4 | Bob | Williams | bob.williams@example.com | +0987654321 | 4
5 | Emma | Brown | emma.brown@example.com | +1234567890 | 5

## Jobs

Id | JobTitle | Company | PostedDate | ContactInfo | ApplicationDeadline
--- | --- | --- | --- | --- | ---
1 | Public Relations | BBC | 2022-01-01 10:00:00 | contact@bbc.co.uk | 2022-01-15 10:00:00
2 | Public Relations | ABC News | 2022-01-01 10:00:00 | contact@abcnews.com | 2022-01-15 10:00:00
3 | Government Communications | BBC | 2022-01-01 10:00:00 | contact@bbc.co.uk | 2022-01-15 10:00:00
4 | Government Communications | White House Press Office | 2022-01-01 10:00:00 | pressoffice@whitehouse.gov | 2022-01-15 10:00:00
5 | Graphic Designer | XYZ Advertising Agency | 2022-01-01 10:00:00 | design@xyzadvertising.com | 2022-01-15 10:00:00
6 | Marketing Manager | LMN Tech Solutions | 2022-01-01 10:00:00 | manager@lmntechsolutions.com | 2022-01-15 10:00:00