| 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 |