Consider a LIBRARY database in which data is recorded about the books. The data requirements are summarized as follows:

[answerhappygod]

Consider A Library Database In Which Data Is Recorded About The Books The Data Requirements Are Summarized As Follows 1 (39.79 KiB) Viewed 38 times

Consider a LIBRARY database in which data is recorded about the books. The data requirements are summarized as follows: Authors write or edit books that have a unique ISBN number. Authors have name, and birth date.. Each book may have many authors and authors may write many books. Publishers publish books, each book has a single publisher. Publishers have name and address. Each copy is of a book, (copies correspond to individual copies of books). Each copy has a unique id. Each author is affiliated with a publisher at a given year. At any year, each author is affiliated with a single publisher. A book may be a new edition of an existing book. Each book can be the new edition of a single book. 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.