## Authors

AuthorID | Name | Country | BirthDate
--- | --- | --- | ---
1 | Dr. Emily Thompson | USA | 1970-06-23
2 | John Doe | UK | 1985-10-15
3 | Jane Smith | Canada | 1990-07-27

## WrittenWorks

WorkID | Title | TypeOfWork | PublishedDate | WordCount
--- | --- | --- | --- | ---
|  | (→ TypesOfWork.Type) |  |
1 | My Essay | Essay | 2021-01-01 | 1000
2 | Important Letter | Letter | 2021-05-01 | 500
3 | Another Essay | Essay | 2021-02-01 | 800
4 | A Formal Letter | Letter | 2021-04-01 | 600
5 | The Great Novel | Novel | 2021-03-01 | 50000

## TypesOfWork

TypeID | Type
--- | ---
1 | Essay
2 | Letter

## Writes

WriteID | AuthorID | WorkID
--- | --- | ---
| (→ Authors.AuthorID) | (→ WrittenWorks.WorkID)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 3 | 4
5 | 3 | 5

## Publishers

PublisherID | Name | Address
--- | --- | ---
1 | Penguin Books | New York, USA
2 | HarperCollins | London, UK
3 | Doubleday | Toronto, Canada

## WorksPublishedByPublisher

WorkID | PublisherID | PublicationYear
--- | --- | ---
(→ WrittenWorks.WriteID) | (→ Publishers.PublisherID) |
1 | 1 | 2021
2 | 2 | 2021
3 | 3 | 2021
4 | 2 | 2021
5 | 3 | 2021