| ID | Name |
|---|---|
| 1 | Sainsbury's |
| 2 | Tesco |
| 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. |
| 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 |
| 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 |
| 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 |
| 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. |
| ArticleId | AuthorId |
|---|---|
| (→ Articles.ArticleId) | (→ Authors.AuthorId) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |