Question

Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. ‘Prentice hall’). Publishers have a name (key), year of inception, and address. A given book has a unique publisher. Book sellers maintain book stores to sell books, a given book seller can have many stores (and must have at least one store, to qualify as a book seller). A book store is one of two types – ‘brick, or ‘web-based’ (and cannot be both)

Brick book stores have a name (key) and address. Web-based book stores have a name (key) and a URL. Some book stores sell books made by many publishers but some book stores are dedicated to selling books made by only one publisher. Try to model as much as you can, and write notes if necessary. Failing to write notes implies that your diagram is exact.

Answer 1

ME YTEL NAME NSSE Name Year_of_inceptio address I 29o Author publisher 299 Name Address Name Wriiten_by Published_by brick web-based URL ISBN Book store NAME sold_by Type hardcover softcover Seller
Keys are underlined

N represent many and 1 represent 1