| id | name | type | circulation_numbers | pub_date | publisher_id |
|---|---|---|---|---|---|
| (→ Publishers.id) | |||||
| 1 | The New York Times | Newspaper | 20000 | 2023-01-01 | 1 |
| 2 | USA Today | Newspaper | 18000 | 2023-01-02 | 1 |
| 3 | Time Magazine | Magazine | 20000 | 2023-01-03 | 2 |
| 4 | National Geographic | Magazine | 19000 | 2023-01-04 | 3 |
| 5 | Wired | Magazine | 17000 | 2023-01-05 | 4 |
| 6 | Forbes | Newspaper | 15000 | 2023-01-06 | 5 |
| 7 | Vanity Fair | Magazine | 16000 | 2023-01-07 | 6 |
| id | name |
|---|---|
| 1 | Jane Austen |
| 2 | Charles Dickens |
| 3 | Mark Twain |
| 4 | George Orwell |
| 5 | Fyodor Dostoevsky |
| 6 | Leo Tolstoy |
| 7 | Harper Lee |
| 8 | Herman Melville |
| 9 | Emily Bronte |
| 10 | William Shakespeare |
| id | title | content | pub_date | periodical_id | author_id |
|---|---|---|---|---|---|
| (→ Periodicals.id) | (→ Authors.id) | ||||
| 1 | A Tale of Two Cities | This novel by Charles Dickens tells... | 2023-01-01 | 1 | 2 |
| 2 | Pride and Prejudice | This classic love story by Jane Austen... | 2023-01-02 | 2 | 1 |
| 3 | Great Expectations | Another masterpiece by Charles Dickens... | 2023-01-03 | 3 | 3 |
| 4 | War and Peace | Tolstoy's epic tale of love during war... | 2023-01-04 | 4 | 6 |
| 5 | To Kill a Mockingbird | Harper Lee's Pulitzer Prize winning book... | 2023-01-05 | 5 | 7 |
| 6 | Moby Dick | Classic adventure novel by Herman Melville. | 2023-01-06 | 6 | 8 |
| 7 | 1984 | Orwell's dystopian vision of a totalitarian society. | 2023-01-07 | 7 | 9 |
| 8 | Crime and Punishment | Dostoevsky's psychological thriller about guilt and redemption. | 2023-01-08 | 8 | 10 |
| 9 | The Great Gatsby | Scott Fitzgerald's timeless portrayal of the American Dream. | 2023-01-09 | 9 | 1 |
| 10 | Animal Farm | George Orwell's allegory on political corruption. | 2023-01-10 | 10 | 2 |
| id | name |
|---|---|
| 1 | McClatchy Company |
| 2 | Gannett Company |
| 3 | Meredith Corporation |
| 4 | Conde Nast |
| 5 | Hearst Communications |
| 6 | Rupert Murdoch's News Corporation |
| 7 | Time Inc. |
| 8 | Newsweek Media Group |
| 9 | The Washington Post |
| 10 | Dow Jones & Company |