BHIS 461 FINAL EXAM WITH STUDY GUIDE AND
CORRECT ANSWERS (UPDATED TO PASS)
In data modeling, an "entity" is ultimately represented in the physical database as a Correct
answer-Table
A database structure with pointers from "parent" to "child" that is an appropriate for large databases
with frequent activity is Correct answer-Hierarchical
A graph where the bars touch each other because they represent continuous data is called a
Correct 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 Correct answer-Categorical
Removing transitive dependencies (when a non-key attribute is dependent on another non-key
attribute) results in a database that is in: Correct answer-3rd Normal Form
A central repository of information about all systems data is a Correct answer-Data dictionary
The activity of describing relationships among data in database design is referred to as: Correct
answer-Data modeling
What is not included in an Entity-Relationship diagram? Correct answer-Processes
What is the purpose of database normalization Correct answer-Reduce / eliminate data
redundancies
In an entity relationship diagram, a unique identifier is referred to as a: Correct 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? Correct answer-FALSE
A relational database overcomes problems of data redundancy seen in "flat file" systems. True or
False? Correct 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? Correct answer-TRUE
A tool to display correlation between two factors Correct 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: Correct answer-System
Evolution of systems:
, Financial, few clinical systems, in-house, shared, or turnkey Correct answer-1970's
Evolution of systems:
Communication technology permitted distributed systems on different levels, some stand-alone
departmental systems; more clinical use Correct answer-1980's
Evolution of systems:
Focus on clinical; integrated; beginning to develop enterprise-wide systems; Decision support
Correct answer-1990's
Evolution of systems:
Seamless integration; standards; e-health; data warehouses; data mining Correct answer-2000's
Conceptual model that characterizes and standardizes the internal functions of a communication
system by partitioning it into 7 abstracting layers Correct answer-OSI (Open Systems
Interconnection)
4 layer model of TCP/IP protocols-Application, Transport, Network, and Network Interface Correct
answer-Internet
This type of network is used in a small geographic area Correct answer-LAN (Local Area Network)
This type of network covers city or national boundaries Correct answer-WAN (Wide Area Network)
LAN components: Correct answer-Hubs
NIC
NOS
Ethernet
Connects network cables and a junction box to permit new computers to be joined into the network
Correct answer-Hub
Connects the computer to the network cable Correct answer-NIC (Network Interface Card)
Server software-enables servers to operate
&
Client software-directory services & network profiles Correct answer-NOS (Network Operating
System)
Shows pattern of observations within classes
-Numbers and percentages Correct answer-Frequency distribution
Mean, Median, and Mode are all______ Correct answer-Measures of Central Tendency
Interval/ratio, sum average of value of all cases Correct answer-Mean
Ordinal, midway number in a frequency distribution Correct answer-Median
Nominal or ordinal, most frequently occurring category Correct answer-Mode
CORRECT ANSWERS (UPDATED TO PASS)
In data modeling, an "entity" is ultimately represented in the physical database as a Correct
answer-Table
A database structure with pointers from "parent" to "child" that is an appropriate for large databases
with frequent activity is Correct answer-Hierarchical
A graph where the bars touch each other because they represent continuous data is called a
Correct 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 Correct answer-Categorical
Removing transitive dependencies (when a non-key attribute is dependent on another non-key
attribute) results in a database that is in: Correct answer-3rd Normal Form
A central repository of information about all systems data is a Correct answer-Data dictionary
The activity of describing relationships among data in database design is referred to as: Correct
answer-Data modeling
What is not included in an Entity-Relationship diagram? Correct answer-Processes
What is the purpose of database normalization Correct answer-Reduce / eliminate data
redundancies
In an entity relationship diagram, a unique identifier is referred to as a: Correct 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? Correct answer-FALSE
A relational database overcomes problems of data redundancy seen in "flat file" systems. True or
False? Correct 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? Correct answer-TRUE
A tool to display correlation between two factors Correct 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: Correct answer-System
Evolution of systems:
, Financial, few clinical systems, in-house, shared, or turnkey Correct answer-1970's
Evolution of systems:
Communication technology permitted distributed systems on different levels, some stand-alone
departmental systems; more clinical use Correct answer-1980's
Evolution of systems:
Focus on clinical; integrated; beginning to develop enterprise-wide systems; Decision support
Correct answer-1990's
Evolution of systems:
Seamless integration; standards; e-health; data warehouses; data mining Correct answer-2000's
Conceptual model that characterizes and standardizes the internal functions of a communication
system by partitioning it into 7 abstracting layers Correct answer-OSI (Open Systems
Interconnection)
4 layer model of TCP/IP protocols-Application, Transport, Network, and Network Interface Correct
answer-Internet
This type of network is used in a small geographic area Correct answer-LAN (Local Area Network)
This type of network covers city or national boundaries Correct answer-WAN (Wide Area Network)
LAN components: Correct answer-Hubs
NIC
NOS
Ethernet
Connects network cables and a junction box to permit new computers to be joined into the network
Correct answer-Hub
Connects the computer to the network cable Correct answer-NIC (Network Interface Card)
Server software-enables servers to operate
&
Client software-directory services & network profiles Correct answer-NOS (Network Operating
System)
Shows pattern of observations within classes
-Numbers and percentages Correct answer-Frequency distribution
Mean, Median, and Mode are all______ Correct answer-Measures of Central Tendency
Interval/ratio, sum average of value of all cases Correct answer-Mean
Ordinal, midway number in a frequency distribution Correct answer-Median
Nominal or ordinal, most frequently occurring category Correct answer-Mode
