Have an issue that I need to figure out why it is not working:

hardcopy and audio books, if you create the tables and include isbn no as foreign key to those tables, it rejects it. Same goes for media and books. If you add the media no to books as a foreign, it rejects it. why is it not working

LIBRARY DETAILS NAME ADDRESS 0.1 LIBRARIAN orders NAME 0.1 AOE register CHECKOUT MEDIA MEMBER RECORD NO requ OUTDATE NAME DUEDATE DATE OFREOUISITION 0... O. DATE PFDISPOSAL RETURN DATE CONTACT MEDIANO FK) REFERENCE ONLY EMPNO FK) WARNING WARNINGNO TNO (FK) PUBLISHER NAME BOOKS VIDEOS AUTHOR COPY NO CATEGORY LEADACTOR. PUBLICAITONDATE DIRECTOR CATEGOR TYPE LENGTH AUDIO HARDCOPY BOOKS NUMBER PAGES SUPPLIER suPPNO (PK) NAME CONTACT LIBNO supplies MAGAZINES VOLUME ISSUE DATE NEWSPAPER LEAD ARTICLE