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 rating: 100% (QA)

Keys are u... View the full answer