Question 17 Not yet answered Marked out of 5.00 Flag question Time left 1:58:13 Consider the database of an online books

[answerhappygod]

Question 17 Not Yet Answered Marked Out Of 5 00 Flag Question Time Left 1 58 13 Consider The Database Of An Online Books 1 (44.73 KiB) Viewed 33 times

Question 17 Not yet answered Marked out of 5.00 Flag question Time left 1:58:13 Consider the database of an online bookstore. Every book has a title, isbn. year and price. The store also keeps the author and publisher for any book. For authors, the database keeps the name, address and the URL of their homepage. For publishers, the database keeps the name, address, phone number and the URL of their website. The store has several warehouses, each of which has a code, address and phone number. The warehouse stocks several books. A book may be stocked at multiple warehouses. (In previous sentence, we are not referring to a particular copy of the book. Consider for example "the complete book" for our course. This book may be stocked at multiple warehouses). The database records the number of copies of a book stocked at various warehouses. The bookstore keeps the name, address. email-id, and phone number of its customers. A customer owns several shopping basket. A shopping basket is identified by a basketID and contains several books. Some shopping baskets may contain more than one copy of same book. The database records the number of copies of each book in any shopping basket. Construct an E-R diagram (based on a Chen's model) to represent the above requirements. Make sure you include all appropriate entities, relationships, attributes, and cardinalities.