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 |