If a primary key includes both CSN and a line count, what kind of data is likely extracted?

If a primary key includes both CSN and a line count, what kind of data is likely extracted?

• A. The table extracts overtime data with multiple-response items.
• B. The table extracts only additive data.
• C. The table extracts only single-response data.
• D. The table extracts archived data.

Answer: (A)

Including both CSN and a line count in the primary key lets you store multiple rows for the same CSN, with each row representing a different line item. That design accommodates data collected in chunks over time or data that contains multiple responses for a single case. So you’re mapping out overtime data with multiple-response items, where each response or observation gets its own line number within the same CSN. If only the CSN were used, you’d typically have just one row per case, suitable for single-response data. The other options don’t align with how the key structure creates multiple rows per CSN.

Including both CSN and a line count in the primary key lets you store multiple rows for the same CSN, with each row representing a different line item. That design accommodates data collected in chunks over time or data that contains multiple responses for a single case. So you’re mapping out overtime data with multiple-response items, where each response or observation gets its own line number within the same CSN. If only the CSN were used, you’d typically have just one row per case, suitable for single-response data. The other options don’t align with how the key structure creates multiple rows per CSN.