Database Design and Development Flashcards

What is the primary purpose of a clinical trial database validation plan?

Answer: To document the approach and criteria for validating the database before data collection begins

A database validation plan outlines the strategy, scope, test cases, and acceptance criteria to confirm that the clinical database functions correctly and meets study requirements.

In clinical database design, what is the purpose of a 'data dictionary'?

Answer: To define and document all variables, formats, and allowable values in the database

A data dictionary provides a comprehensive reference that defines each variable's name, label, type, format, allowable values, and derivation rules used in the clinical database.

What does 'user acceptance testing' (UAT) involve in EDC system development?

Answer: End users verifying that the system meets business requirements before go-live

UAT is performed by intended end users (e.g., data managers and clinical staff) to confirm that the EDC system meets functional requirements and is fit for purpose prior to production use.

Which CDISC standard defines the structure for tabulation datasets submitted to regulatory agencies?

Answer: SDTM (Study Data Tabulation Model)

SDTM defines the structure and organization of datasets for submission to regulatory agencies like the FDA, organizing data into standardized domain models.

What is a 'range check' in clinical database design?

Answer: An edit check that flags values outside a predefined acceptable range for a variable

A range check is a programmed edit check that automatically flags data values falling outside predefined minimum and maximum limits, triggering a query for resolution.

In relational database design for clinical trials, what is the purpose of a foreign key?

Answer: To establish a link between records in two related tables and enforce referential integrity

A foreign key in a relational database links records in one table to a related record in another table, enforcing referential integrity and preventing orphan records.