Given the following scenario create an ERD for the Bookstore.

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.

http://www.screencast.com/t/GgZ1sfAS