A relational database has tables for PATIENT_DEMOGRAPHY and VITAL_SIGNS data collected during a visit. The primary key for the VITAL_SIGNS table is a composite key that includes the unique patient identifier, visit number, and vital signs parameter name. The two tables are joined on the patient identifier. What will be the number of records in the result set?
In a relational database structure, each record in a table is uniquely identified by a primary key. In this case, the VITAL_SIGNS table uses a composite primary key consisting of:
Patient Identifier,
Visit Number, and
Vital Signs Parameter Name.
This means each record represents a unique measurement of a specific parameter (e.g., blood pressure, pulse) for a patient at a specific visit.
When joining PATIENT_DEMOGRAPHY and VITAL_SIGNS tables on the patient identifier, the result set will include one record for every combination of patient, visit, and parameter --- i.e., one record per patient per visit per vital sign parameter.
Therefore, option C correctly describes the expected number of records.
Reference (CCDM-Verified Sources):
SCDM GCDMP, Chapter: Database Design and Build, Section 5.2 -- Primary and Foreign Key Relationships in Relational Models
CDISC SDTM Implementation Guide, Section 5.3 -- Observation-Level Data Structures
ICH E6(R2) GCP, Section 5.5.3 -- Data Organization and Integration Principles
Currently there are no comments in this discussion, be the first to comment!