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 |