Libraries have books, DVDs, and CDs which they allow patrons (library users) to
ID: 3844568 • Letter: L
Question
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.
Explanation / Answer
In the given example the main objects
1. Patron
2. Books
3. DVD
4. CD
5. Items
6. Library
Library book attributes ISBN and subjects are inherited from book. Title attributes explicitly redefines name. The language is enumerated type. Library has loadPeriod, dueDate and is Overdue.
Patron can perform three functions search() – search book, request() – request a particular book to librarian and payFine() – pay fine feu to delay in book return (book,dvd,cd).
A patron have account and it has three states active, frozen, closed. These three states can be defined in enumeration.
Librarian can manage the all records of book, dvd, cd and patrons all entries also he can search the book.
A book can be of many languages so type of language can be defined in enumeration
Relationship
-One section has many books/dvd/cd but one book/cd/dvd should keep in one section. It is 1: N Relationship.
-One member can borrow many books/cd/dvd. It is 1 : N Relationship.
-Many books/dvd/cd may publish/produce by one publisher/producer otherwise one publisher/producer may be published/produced many books/dvd/cd. It is N : 1 Relationship.
-Many member may have one Librarian otherwise one Granter grants for many members. It is N: 1 Relationship.
And their entities are as follows.
Library
-name
-address
Librarian
-name
-address
-position
+search()
+manage()
Patron
-patronId
-Type
-dateOfMembership
-noItemIssued
-maxItemLimit
-name
-age
-address
-phonenNo
-finesOwned
+search()
+request()
+payFine()
A Patron have a account
Account
-id
-opened
-state (Account State)
Item
-barcode/ISBN
-title
-subject
-language
-numberOfPages
-format
-borrowed
/loadPeriod
/dueDate
/isOverdue
Book
-title
-iSBN
-language
-barcode
-author
-subject
-language
-publisher
-publicationDate
-numberOfPages
-conditionOfBook
DVD
-name
-barCode
-language
-producer
-Genre
-Language
-Producer
-dateProduced
-numberOfSongs
CD
-artist
-name
-barCode
-language
-numberOfSong
-numberOfSongs
-dateProduced
Enumeration
Language
-English
-French
-German
-Italian
-Spanish
AccountState
-Active
-Frozen
-Clsoed
Formate
-PaperBack
-Hardcover
-AudioBook
-VideoBook
Genre
-Book
-Movies
-Songs
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.