Intermediate Database Design

Test your Intermediate-level System Design Architecture Database Design skills in Computer Science Fundamentals. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

How should a 'Many-to-Many' relationship between 'Books' and 'Authors' be resolved during the logical design of a relational database?

A. By adding a comma-separated list of Author IDs into a column in the Books table.

B. By creating an associative (junction) table that links the primary keys of both entities.

C. By adding the Book ID as a foreign key directly into the Authors table.

D. By duplicating the Book information for every Author that contributed to it.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question