I sell books and would like to create a database for my books and transactions. At this time I am not keeping track of supplier information. Many times customers come in asking what books a special au

I sell books and would like to create a database for my books and transactions. At this time I am not keeping track of supplier information. Many times customers come in asking what books a special author has written. Other times the customer wants books from a certain publisher or even a particular genre. Some of my books are hard cover and some are soft cover. I do not have any digital books.

**Remember the only foreign keys I should see in the ERD are for the bridges.