Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need to ensure this library uml diagram is correct based off of the information below: The small town library growing and now has three library

need to ensure this library uml diagram is correct based off of the information below:

The small town library growing and now has three library branches from which residents can borrow items. Each branch has a full-time supervisor and both full- and part-time employees. All non-reference media can be checked out, but if the media is not returned by the due date a warning is sent and the member is charged 10 cents for each day the item is late.

Then, describe the normalized tables showing primary keys, foreign keys, and data types.

Not sure if the top part is right for supervises 1..* and how I have LIBRARIES (3) INT 10

Based on the diagram below: wouldl like to know if it is correct or what needs to be fixed on it from the information above. The part I am not sure of is where it states 3 library branches opening with supervisors and full-time and part-time employees. To include describe the normalized tables showing primary keys, foreign keys, and data types. image text in transcribedimage text in transcribed

OLD UML DIAGRAM USED TO MAKE NEW UML DIAGRAM SUPPLIER SUPP NO (PK) NAME ARIAN ADDRESS 15 EMP NO (PK) CONTACT NAME ADDRESS AGE MEMBER MELIA is. MEDIA NO (PK) RECORD NO (PK) CARD NO (PK) OUTDATE NAME NAME DUE DATE DATE OF REQUISITION ADDRESS RETURN DATE DATE OF DISPOSAL CONTACT REFERENCE ONLY DATE WARNING NO MESSAGE PUBLISHE PUB NO (PK) NAME VIDEOS MAGAZINES BOOKS ADDRESS VIDEO NO NAME ISBN NO COPY NO published by AUTHOR VOLUME LEAD ACTOR SSUE CATEGORY DIRECTOR DATE PUBLICATION DATE CATEGORY TYPE LENGTH AUDIO BOOKS HARDCOPY BOOKS COPY NO COPY NO READER NUMBER PAGES LENGTH NEWSPAPER DATE LEAD ARTICLE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Records And Database Management

Authors: Jeffrey R Stewart Ed D, Judith S Greene, Judith A Hickey

4th Edition

0070614741, 9780070614741

More Books

Students also viewed these Databases questions

Question

Have ground rules been established for the team?

Answered: 1 week ago

Question

a. How are members selected to join the team?

Answered: 1 week ago

Question

b. Will new members be welcomed?

Answered: 1 week ago