✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider the relational database schema BOOK_COPY(Book_id, Branch_id, Title, Publisher, primary key(Book_id, Branch_id)), BOOK_LOAN(Book_id, Branch_id, Card_no, Issue_date, Return_date, primary key(Book_id, Branch_id, Card_no)), LIBRARY_BRANCH(Branch_id primary key, Name, Address). One of the foreign keys in the schema is