Exercise One:

A small publisher wants to keep data about its books and authors. A book has an ISBN, title, author$($s$),$ page fount, genre$($s$),$ edition, retail price, and publishing year. An author has an author ID$,$ first name, last name, ind bio. ISBN is unique for books and author ID is unique for authors. Also, royalties are kept for each book and author$($e$.$g$.$ $$100$ for Book $1$ and Author $1,$ $$80$ for Book $1$ and Author $2).$ Write all business rules and draw a logical ERD for the publisher.