AuthorID | FirstName | LastName | BirthDate | Country |
---|---|---|---|---|
1 | John | Doe | 1980-06-30 | USA |
2 | Jane | Smith | 1975-10-01 | UK |
PublisherID | Name | Address | PhoneNumber |
---|---|---|---|
1 | ABC Publishing | 123 Main St. | 555-1234 |
2 | XYZ Books | 456 Elm St. | 555-5678 |
LitID | Title | Synopsis | Language | PublicationYear | LiteratureType | AuthorID | PublisherID |
---|---|---|---|---|---|---|---|
(→ Authors.AuthorID) | (→ Publishers.PublisherID) | ||||||
1 | The Italian Novel | A story about an Italian adventure | Italian | 2010 | Novel | 1 | 1 |
2 | The Spanish Novel | A tale of love and mystery | Spanish | 2012 | Novel | 2 | 2 |
3 | La Poesia Italiana | An anthology of Italian poetry | Italian | 2008 | Poem | 1 | 1 |
4 | El Pueblo EspaƱol | A collection of poems about Spain | Spanish | 2011 | Poem | 2 | 2 |