You and your friend, Luke Skywalker, checked out two copies of the same book, The Chronicles of
Question:
You and your friend, Luke Skywalker, checked out two copies of the same book, The Chronicles of Narnia: The Lion, the Witch and the Wardrobe for a book report you two needed to do for a class. While you were at the library, you checked out several other books written or co-authored by the same author, C. S. Lewis, and another novel on the same subjects. Luke also checked out 2 versions of the movies in DVD format based on the book, one made in 1979, and the other in 2005. Develop an entity-relationship diagram that would fully represent the data included in this scenario, in particular, the data underlined. What are the business rules? Relational schema?
Note: you do not need to include all possible attributes for the entities you come up; but you need to include PKs for all the entities, and attributes whose data have been underlined in the description above.
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman