| AuthorID | FirstName | LastName | BirthDate | Country |
|---|---|---|---|---|
| 1 | John | Doe | 1980-06-15 | USA |
| 2 | Jane | Smith | 1978-10-30 | UK |
| SubjectID | Name |
|---|---|
| 1 | Mathematics |
| 2 | Physics |
| BookID | Title | PublicationYear | Pages | Educational_Materials | PublisherID |
|---|---|---|---|---|---|
| (→ Publishers.PublisherID) | |||||
| 1 | Introduction to Mathematics | 2021 | 300 | 186e16">Textbook | 1 |
| 2 | Advanced Physics | 2020 | 400 | Textbook | 2 |
| 3 | Digital Electronics | 2021 | 350 | 186e16">E-Book | 1 |
| 4 | Computer Networking Fundamentals | 2020 | 450 | E-Book | 2 |
| PublisherID | CompanyName | Address | ContactNumber | |
|---|---|---|---|---|
| 1 | Pearson | New York | +1 (555) 123-4567 | pearson@email.com |
| 2 | Wiley | Boston | +1 (555) 987-6543 | wiley@email.com |