Assistance with establishing the relationship when looking for problems and errors

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, the relationships in the diagram when looking for problems and errors. These project components are further described as follows:

Relationships in the diagram	The report describes the relationships in the diagram when looking for problems and errors

ARIAN 015 EMP NO (PK) NAME ADDRESS AGE MEMBER CHECKOUT requests RECORD NO (PK) CARD NO (PK) OUTDATE NAME DUE DATE ADDRESS RETURN DATE CONTACT generates WARNING DATE WARNING NO MESSAGE PUBLISHER PUB NO (PK) NAME ADDRESS ISBN NO published by AUTHOR CATEGORY PUBLICATION DATE AUDIO BO HARDCO BOOKS COPY NO COPY NO READER NUMBER PAGES LENGTH SUPP NO (PK) NAME ADDRESS CONTACT MEDIA MEDIA NO (PK) NAME DATE OF REQUISITION DATE OF DISPOSAL REFERENCE ONLY VIDEOS MAGAZINES NAME VIDEO NO COPY NO VOLUME LEAD ACTOR ISSUE DIRECTOR DATE CATEGORY TYPE LENGTH NEWSPAPER DATE LEAD ARTICLE