## Distributor

ID | Name
--- | ---
1 | Sainsbury's
2 | Tesco

## Newspaper_Type

ID | Type | Description
--- | --- | ---
1 | Broadsheet | A type of newspaper that is larger than a tabloid.
2 | Tabloid | A type of newspaper that is smaller than a broadsheet.

## Broadsheet_Newspapers

ID | Name | DistributorId
--- | --- | ---
|  | (→ Distributor.ID)
1 | The Times | 1
2 | Financial Times | 1
3 | The Guardian | 2
4 | The Independent | 2
5 | The Daily Telegraph | 1

## Tabloid_Newspapers

ID | Name | DistributorId
--- | --- | ---
|  | (→ Distributor.ID)
1 | The Sun | 1
2 | The Mirror | 1
3 | Daily Mail | 2
4 | The Express | 2
5 | The Star | 1

## Articles

ArticleId | Title | Content | DateOfPublication | NewspaperId
--- | --- | --- | --- | ---
|  |  |  | (→ Newspaper_Type.ID)
1 | Political Crisis Ahead | Analysis on the political crisis in the country. | 2021-08-01 | 1
2 | Investment Market Booms | Discussion about recent boom in investment market. | 2021-07-29 | 2
3 | Climate Change Summit | Reporting on climate change summit held recently. | 2021-06-12 | 3
4 | Olympics Opening Ceremony | Review of opening ceremony at Tokyo Olympics. | 2021-07-23 | 4
5 | Pandemic Update | Latest update on COVID pandemic situation. | 2021-08-05 | 5

## Authors

AuthorId | FullName | Biography
--- | --- | ---
1 | John Smith | John has been writing since his college years.
2 | Jane Doe | Jane works as a freelance journalist covering politics.
3 | Tom Brown | Tom writes about business and economy issues.
4 | Emma Wilson | Emma specializes in sports journalism.
5 | Michael Johnson | Michael covers world events and international relations.

## Authored_Articles

ArticleId | AuthorId
--- | ---
(→ Articles.ArticleId) | (→ Authors.AuthorId)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5