PART 2

Question 1

Refers to the type of relationship one has with another

Answer 1

Cardinality

Question 2

Number of related rows for each of the two objects in the relationship

Answer 2

Relationship Cardinality

Question 3

Each record in the first table is associated with one and only one record in the second table EX: Social Security Number

Another Ex: Patient and MRN

Answer 3

One-to-one

Question 4

Each record in the first table is associated with many records in the second table and each record in the second table is associated with only one record in the first table.
EX: Telephone Number

Another EX: Patient and Telephone Number

Answer 4

One-to-many

Question 5

Most complicated to implement, therefore usually requires an intersect table to manage the relationship

Each record in the first table is associated with many in the second table. Each record in the second table is associated with many in the first table. EX: City or State, Medications, or Diagnosis

Answer 5

Many-to-many

Question 6

Column which uniquely identifies a record in the table

Answer 6

Primary key

Question 7

A column or group of columns in a relational database table that provides a link between data in two tables.

EX: Phone ID is PK for table 2/ MRN is FK in table 2 which establishes the relationship between the 2 tables

Answer 7

Foreign key

Question 8

_____ is a widely adopted statistical programming language where users carry out tasks by specifying instructions using a common set of rules with words and phrases/____ is considered an interpreted language not a compiled language/each command can be interpreted without having to develop a computer program

Answer 8

R

Question 9

Very simple design-base program for R

Answer 9

R interface

Question 10

Code is typed-where you enter commands

Answer 10

R console