## Periodicals

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

## Authors

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

## Articles

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

## Publishers

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