Need a ERD updated. We need to add Genre, customer and order info. please add to the file I uploaded.

Need a ERD updated. We need to add Genre, customer and order info.

please add to the file I uploaded.

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.

We need to add Genre, customer and order info. 

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