Question
Only need assistance with the part that is bolded. Library UML Diagram is posted with the question. This design is a relational data model for
Only need assistance with the part that is bolded. Library UML Diagram is posted with the question.
This design is a relational data model for a library in a small town. The library contains books, videos, newspapers, and magazines that can be checked out. It also contains reference books, videos, magazines, and newspapers that cannot be checked out.
examine the data model and identify problems with or errors in the design. In a Microsoft Word document, capture the table definitions, definitions of (key and non-key) fields, and the relationships in the diagram when looking for problems and errors. These project components are further described as follows:
The table definitions
The definitions of the primary key fields
The relationships in the diagram
SupeMSes 0..1 LIBRARIAN EMP NO (PK) 0..15 NAME ADDRESS AGE MEMBER CHECKOUT RECORD NO (PK) CARD NO (PK) OUTDATE NAME DUE DATE ADDRESS RETURN DATE CONTACT WARNING DATE WARNING NO MESSAGE PUBLISHER PUB NO (PK) NAME ADDRESS BOOKS ISBN NO published by AUTHOR CATEGORY PUBLICATION DATE AUDIO BOOKS HARDCOPY BOOKS COPY NO COPY NO READER NUMBER PAGES LENGTH SUPPLIER SUPP NO (PK) NAME ADDRESS CONTACT MEDIA MEDIA NO (PK) NAME DATE OF REQUISITION DATE OF DISPOSAL REFERENCE ONLY MAGAZINES VIDEOS VIDEO NO NAME COPY NO VOLUME LEAD ACTOR SSUE DIRECTOR DATE CATEGORY TYPE LENGTH NEWSPAPER DATE LEAD ARTICLE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started