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 |