Create a set of relational schemas with underlined (primary) keys and arrows connecting foreign keys and primary keys for a database containing the following information. If you have any difficulty drawing arrows, you can write foreign key information in a sentence instead.

Authors have Last Name, Firstname, ID, and Birthdate (identified by ID)

Publishers have Name, ID, address (identified by ID)

Books have ISBN, Title, Publisher (each book has a unique publisher and can be identified by ISBN).

Authors Write Books; since many authors can co-author a book, we need to know the rank of an author contributing to a book, stored in this table (i.e. a number 1, 2, 3; for single author books, this number is 1).