Question 1 of 30
In a relational database, you are tasked with designing a schema for a library system that tracks books, authors, and borrowers. Each book can have multiple authors, and each author can write multiple books. Additionally, each borrower can borrow multiple books, but each book can only be borrowed by one borrower at a time. Given this scenario, which of the following relationships correctly describes the associations between these entities?
Many-to-Many between Books and Authors, and One-to-Many between Borrowers and Books
One-to-Many between Books and Authors, and Many-to-Many between Borrowers and Books
One-to-One between Books and Authors, and One-to-Many between Borrowers and Books
Many-to-Many between Books and Borrowers, and One-to-Many between Authors and Books

Preparing for Microsoft 98-364 Database Fundamentals? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free