BHIS 461 Final Exam With Study
Guide 100% Pass
In data modeling, an "entity" is ultimately represented in the physical database
as a - ANSWER Table
A database structure with pointers from "parent" to "child" that is an
appropriate for large databases with frequent activity is - ANSWER Hierarchical
A graph where the bars touch each other because they represent continuous
data is called a - ANSWER Histogram
A numerical coding system that represents options for discharge status such as:
1 - alive, home
2 - alive, SNF
3 - deceased
is an example of which type of data - ANSWER Categorical
Removing transitive dependencies (when a non-key attribute is dependent on
another non-key attribute) results in a database that is in: - ANSWER 3rd Normal
Form
A central repository of information about all systems data is a - ANSWER Data
dictionary
The activity of describing relationships among data in database design is
referred to as: - ANSWER Data modeling
What is not included in an Entity-Relationship diagram? - ANSWER Processes
What is the purpose of database normalization - ANSWER Reduce / eliminate
data redundancies
In an entity relationship diagram, a unique identifier is referred to as a: -
ANSWER Primary Key
The internal, or physical data model represents an individual user's or
enterprise view of how the data should be organized and displayed while the
conceptual model represents how data are actually stores in the database files
so that it can be used by the computer.
True or False? - ANSWER FALSE
,A relational database overcomes problems of data redundancy seen in "flat file"
systems. True or False? - ANSWER TRUE
Removing "repeating groups" so that there is a single entry in each field per row
is converting a database to first normal form. True or False? - ANSWER TRUE
A tool to display correlation between two factors - ANSWER Scatter Diagram
A group of components that interact with each other, work toward
accomplishment of a goal, and self-adapt and respond to an environment is a: -
ANSWER System
Evolution of systems:
Financial, few clinical systems, in-house, shared, or turnkey - ANSWER 1970's
Evolution of systems:
Communication technology permitted distributed systems on different levels,
some stand-alone departmental systems; more clinical use - ANSWER 1980's
Evolution of systems:
Focus on clinical; integrated; beginning to develop enterprise-wide systems;
Decision support - ANSWER 1990's
Evolution of systems:
Seamless integration; standards; e-health; data warehouses; data mining -
ANSWER 2000's
Conceptual model that characterizes and standardizes the internal functions of
a communication system by partitioning it into 7 abstracting layers - ANSWER
OSI (Open Systems Interconnection)
4 layer model of TCP/IP protocols-Application, Transport, Network, and Network
Interface - ANSWER Internet
This type of network is used in a small geographic area - ANSWER LAN (Local
Area Network)
This type of network covers city or national boundaries - ANSWER WAN (Wide
Area Network)
LAN components: - ANSWER Hubs
NIC
NOS
Ethernet
, Connects network cables and a junction box to permit new computers to be
joined into the network - ANSWER Hub
Connects the computer to the network cable - ANSWER NIC (Network Interface
Card)
Server software-enables servers to operate
&
Client software-directory services & network profiles - ANSWER NOS (Network
Operating System)
Shows pattern of observations within classes
-Numbers and percentages - ANSWER Frequency distribution
Mean, Median, and Mode are all______ - ANSWER Measures of Central Tendency
Interval/ratio, sum average of value of all cases - ANSWER Mean
Ordinal, midway number in a frequency distribution - ANSWER Median
Nominal or ordinal, most frequently occurring category - ANSWER Mode
Range, variance, standard deviation, and percentile are all_______ - ANSWER
Measures of dispersion
Measures low to high - ANSWER Range
Measures how different from the mean - ANSWER Variance
Used to determine whether the mean of a subset for a variable is significantly
different from the whole group - ANSWER T-test
Used to determine whether the difference between to groups are statistically
significant - ANSWER T-statistic
Used to determine whether the difference between more than 2 groups is
significant - ANSWER F-statistic/ANOVA
Looks like a bar chart but items are listed in descending order - ANSWER Pareto
chart
Displays data points over a period of time - ANSWER Run chart
Similar to run chart, but with line over top and bottom (control limits) - ANSWER
Control chart
Guide 100% Pass
In data modeling, an "entity" is ultimately represented in the physical database
as a - ANSWER Table
A database structure with pointers from "parent" to "child" that is an
appropriate for large databases with frequent activity is - ANSWER Hierarchical
A graph where the bars touch each other because they represent continuous
data is called a - ANSWER Histogram
A numerical coding system that represents options for discharge status such as:
1 - alive, home
2 - alive, SNF
3 - deceased
is an example of which type of data - ANSWER Categorical
Removing transitive dependencies (when a non-key attribute is dependent on
another non-key attribute) results in a database that is in: - ANSWER 3rd Normal
Form
A central repository of information about all systems data is a - ANSWER Data
dictionary
The activity of describing relationships among data in database design is
referred to as: - ANSWER Data modeling
What is not included in an Entity-Relationship diagram? - ANSWER Processes
What is the purpose of database normalization - ANSWER Reduce / eliminate
data redundancies
In an entity relationship diagram, a unique identifier is referred to as a: -
ANSWER Primary Key
The internal, or physical data model represents an individual user's or
enterprise view of how the data should be organized and displayed while the
conceptual model represents how data are actually stores in the database files
so that it can be used by the computer.
True or False? - ANSWER FALSE
,A relational database overcomes problems of data redundancy seen in "flat file"
systems. True or False? - ANSWER TRUE
Removing "repeating groups" so that there is a single entry in each field per row
is converting a database to first normal form. True or False? - ANSWER TRUE
A tool to display correlation between two factors - ANSWER Scatter Diagram
A group of components that interact with each other, work toward
accomplishment of a goal, and self-adapt and respond to an environment is a: -
ANSWER System
Evolution of systems:
Financial, few clinical systems, in-house, shared, or turnkey - ANSWER 1970's
Evolution of systems:
Communication technology permitted distributed systems on different levels,
some stand-alone departmental systems; more clinical use - ANSWER 1980's
Evolution of systems:
Focus on clinical; integrated; beginning to develop enterprise-wide systems;
Decision support - ANSWER 1990's
Evolution of systems:
Seamless integration; standards; e-health; data warehouses; data mining -
ANSWER 2000's
Conceptual model that characterizes and standardizes the internal functions of
a communication system by partitioning it into 7 abstracting layers - ANSWER
OSI (Open Systems Interconnection)
4 layer model of TCP/IP protocols-Application, Transport, Network, and Network
Interface - ANSWER Internet
This type of network is used in a small geographic area - ANSWER LAN (Local
Area Network)
This type of network covers city or national boundaries - ANSWER WAN (Wide
Area Network)
LAN components: - ANSWER Hubs
NIC
NOS
Ethernet
, Connects network cables and a junction box to permit new computers to be
joined into the network - ANSWER Hub
Connects the computer to the network cable - ANSWER NIC (Network Interface
Card)
Server software-enables servers to operate
&
Client software-directory services & network profiles - ANSWER NOS (Network
Operating System)
Shows pattern of observations within classes
-Numbers and percentages - ANSWER Frequency distribution
Mean, Median, and Mode are all______ - ANSWER Measures of Central Tendency
Interval/ratio, sum average of value of all cases - ANSWER Mean
Ordinal, midway number in a frequency distribution - ANSWER Median
Nominal or ordinal, most frequently occurring category - ANSWER Mode
Range, variance, standard deviation, and percentile are all_______ - ANSWER
Measures of dispersion
Measures low to high - ANSWER Range
Measures how different from the mean - ANSWER Variance
Used to determine whether the mean of a subset for a variable is significantly
different from the whole group - ANSWER T-test
Used to determine whether the difference between to groups are statistically
significant - ANSWER T-statistic
Used to determine whether the difference between more than 2 groups is
significant - ANSWER F-statistic/ANOVA
Looks like a bar chart but items are listed in descending order - ANSWER Pareto
chart
Displays data points over a period of time - ANSWER Run chart
Similar to run chart, but with line over top and bottom (control limits) - ANSWER
Control chart
