CHDA Chapter 3
A database is - answer A self-describing collection of integrated records
Relational databases are - answer Two dimensional arrays of rows and columns
An entity relationship diagram (ERD) - answer Is used to describe how the tables of
multiple databases work together
Attributes are - answer Characteristics or data elements to be collected about each
entity
An attribute that is a unique identifier in a table - answer Primary key
When a primary key is duplicated in another table it is called - answer A foreign key
A data dictionary is - answer The equivalent of a detailed roadmap of the database
Structured query language (SQL) - answer Is a flexible language that is commonly used
to communicate with a relational database
Statistical analysis system is also known as – answer SAS
SPSS - answerIs also known as statistical package for the social sciences
SAS programs are created in two steps - answerThe first step is the DATA step and the
second step is the PROC step
The SAS data step - answerMaybe used to create a data set or to create new variables
within an existing data set
The SAS procedure step is - answerUsed to run a statistical analysis procedure
HEDIS (Healthcare Effectiveness Data and Information Set) - answerAre hospital
quality measures for CMS
In tables, the columns are the "blank" in the observations are the "blank" -
answerVariables, observations
Bar graphs are appropriate for - answerComparing a summary statistics such as volume
or an average across groups
A database is - answer A self-describing collection of integrated records
Relational databases are - answer Two dimensional arrays of rows and columns
An entity relationship diagram (ERD) - answer Is used to describe how the tables of
multiple databases work together
Attributes are - answer Characteristics or data elements to be collected about each
entity
An attribute that is a unique identifier in a table - answer Primary key
When a primary key is duplicated in another table it is called - answer A foreign key
A data dictionary is - answer The equivalent of a detailed roadmap of the database
Structured query language (SQL) - answer Is a flexible language that is commonly used
to communicate with a relational database
Statistical analysis system is also known as – answer SAS
SPSS - answerIs also known as statistical package for the social sciences
SAS programs are created in two steps - answerThe first step is the DATA step and the
second step is the PROC step
The SAS data step - answerMaybe used to create a data set or to create new variables
within an existing data set
The SAS procedure step is - answerUsed to run a statistical analysis procedure
HEDIS (Healthcare Effectiveness Data and Information Set) - answerAre hospital
quality measures for CMS
In tables, the columns are the "blank" in the observations are the "blank" -
answerVariables, observations
Bar graphs are appropriate for - answerComparing a summary statistics such as volume
or an average across groups
