Current Library UML Diagram. Based on diagram need the following answered: Defin

Question

Current Library UML Diagram. Based on diagram need the following answered: Definitions of fields The submission includes definitions of (key and non-key) fields

PPLIE SUPP NO (PK) NAME IBRARI orders ADDRESS CONTACT EMP NO (PK) NAME ADDRESS AGE registers supplies MEMBER CHECKO MED is MEDIA NO (PK) RECORD NO (PK) OUTDATE CARD NO (PK) NAME NAME DUE DATE DATE OF REQUISITION ADDRESS RETURN DATE DATE OF DISPOSAL CONTACT REFERENCE ONLY ARNIN DATE WARNINGNO MESSAGE UBLISHER PUB NO (PK) NAME DEOS MAGAZIN ADDRESS VIDEO NO NAME SBN NO published by COPY NO VOLUME AUTHOR LEAD ACTOR ISSUE CATEGORY DIRECTOR DATE PUBLICATION DATE CATEGORY LENGTH AUDIO BOOKS HARDCOPY BOOKS COPY NO COPY NO READER NUMBER PAGES LENGTH NEWSPAPER DATE LEAD ARTICLE

Explanation / Answer

Librarian
More than one employee can work in a library like supervisor, assistant, etc. So each employee can be registered with their information (name, address, age) by employee ID. Employee ID is a unique number, for each employee has its own ID. So librarian includes,
Emp ID - Primary key and it's a unique value
Name - name of the employee
Address - employee address
Age - employee age.

Member
Customers/Users are called members of the library. They can register in order to get their membership of the library. So it holds some information like,
Card No - Primary key and it is also holds unique value.
Name - name of the user
Address - user address
Age - user age.

Supplier
The supplier can supply their products to libraries. They can supply either books or videos or magazines or newspapers or all of them. In order to maintain their information, it required following things,
Supp No - Primary key and it holds unique value
Name - name of the supplier
Address - supplier address
Contact - Supplier contact number.

Media
Librarian can order products to supplier, it needs,
Media no - primary key and it holds unique value.
Name - Name of the media. It may be either books or videos or magazines or newspapers.
Date of requisition - Librarian ordered date.
Date of disposal - Suppliers disposal date
Refference only - flag for refference.

Checkout.
Customer/User can take a book for their reference to the study. And He/She should return books after a particular period of time. Checkout includes media no that is what type of media they had taken. It may be a book or videos or magazines or newspapers.
Record No - primary key.
Media no - Foreign key - it denotes the type of the product. (book or videos or magazines or newspapers)
Outdate - checkout date or user taken date
Due date - Last date to return the book.
Return Date - It denotes the exact returning date of the product.

Warning
If the user doesn't return the product to a particular period of time, then they will send a message or warning to the customer to return the book. It includes,
Record No - Foreign key - What type of product is it.
Card No - Foreign key - User card number who take the book.
Date - Date of message sent.
Warning No - type of warning
Message - Information or warning details

The media includes following informations,

Books:
ISBN No - ISBN number
Author - Book author name
Category - type of the book
Publication date - book published date

book can be divided into 2 types, that is: Audio book and Hard copy book
Audio book includes Copy number, Reader and Length (size of the audio).
Hard copy book includes Copu number and Number of pages

Videos:
It includes video number, copy number, lead actor- actor name, director name - video director name, category- category of video, type - type of video and length - size of the video.

Magazines:
Name - name of magazines, Volume, issue and date.

Newspaper:
Date - Newspaper published date and lead artical.

These all types of media should be published with some information,
Publish number - primary key.
Name - name of the publisher
Address - address of the publisher.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.