| id | section_name |
|---|---|
| 1 | Local News |
| 2 | National News |
| 3 | World News |
| 4 | Technology |
| 5 | Entertainment |
| id | newspaper_name |
|---|---|
| 1 | The Times |
| 2 | Daily Mail |
| 3 | Financial Times |
| 4 | Guardian |
| 5 | Independent |
| id | article_title | article_content | publication_date |
|---|---|---|---|
| 1 | Brexit Updates | Latest news on Brexit. | 2024-01-30 19:19:35 |
| 2 | Coronavirus Update | Latest updates on coronavirus situation around the world. | 2024-01-30 19:19:35 |
| id | author_name |
|---|---|
| 1 | John Smith |
| 2 | Jane Doe |
| 3 | Alice Johnson |
| 4 | Bob Brown |
| 5 | Charlie White |
| newspaper_id | author_id |
|---|---|
| (→ Newspapers.id) | (→ Authors.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| article_id | author_id |
|---|---|
| (→ Articles.id) | (→ Authors.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| newspaper_id | section_id |
|---|---|
| (→ Newspapers.id) | (→ Sections.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| 5 | 5 |
| 2 | 3 |
| 1 | 3 |
| 4 | 3 |
| 5 | 3 |