Problem

Libraries have books, DVDs, and CDs which they allow patrons (library users) to borrow. All of these objects mentioned represent entities. Each of these entities have various attributes or characteristics. Patrons have names, addresses, phone numbers, an age, a date when they became a patron. A book has an author, a publisher, a publication date, number of pages, and condition of book. A DVD has a name, number of songs, date produced, and a producer. Books, movies and songs are in a particular genre. A CD has an artist, a name, number of songs, and date produced.

After analyzing the case study above, perform the following tasks. State any assumptions which you consider relevant.

Prepare a document which contains the following sections.

Section 1 should list the relevant associations.

Section 2 should list the entities and attributes identified.