| 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 |
| 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... |
| Id | FirstName | LastName | 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 |
| 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 |