Answer Happy

Question 1: Draw an ER diagram that best represents the following scenario? Notes: You do not need to show all attributes in your ER design, but you must show primary keys, and any relationships, which have attributes, must have those attributes shown. You must also show all participation constraints and relationship cardinalities. If you need to make additional assumptions about the application in order to develop your ER diagram, then also include these. The following requirements were considered in the design of the model: • for books, we must maintain their ISBN, title, author(s) and year of publication • we also need to know how many copies of each book is currently in stock (i.e. in the warehouse and available for delivery) and what the current price is • for customers, we need to know their name and address (for shipping) . customers can deal with the bookstore either online, or offline via simply phone their orders through • some customers deal with the bookstore exclusively by phone; for such customers the above information is all that is required • online customers need to have a username and password, and must supply a contact email address, in addition the above customer information • for orders there is an ID, we need to remember who was the customer who place the order, when they placed it, when the order was shipped, whether they have paid orders are only shipped when all ordered items are available ● customers may order multiple copies of a given book