DATABASES-PEARSON-IT-SPECIALIST-CERTIFICATION Practice Test

1Multiple ChoiceSelect all that apply

A librarian needs to track books and the authors who wrote them. Each book can have multiple authors, and each author can write multiple books. Which combination of tables and key definitions correctly models this relationship in a relational database? (Choose two.)

A.Create a BOOKS table with a primary key book_id and an AUTHORS table with a primary key author_id
B.Create a junction table (e.g., BOOK_AUTHORS) containing book_id and author_id as foreign keys referencing both tables
C.Add a single author_id column directly to the BOOKS table as a foreign key, since each book has only one author
D.Combine all book and author records into a single table to avoid the need for foreign keys

Reveal the answer to continue