Given the following scenario create an ERD for the Bookstore.
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.
Here’s a link on how to do it. Please do not copy and make your own.