Create a relational schema with underlined (primary) keys and arrows connecting foreign keys and primary keys for a database containing the following information.

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

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

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

Authors Write Books; many authors can co-author a book.

Please make sure to write all your assumptions.