BHIS 461 FINAL EXAM WITH STUDY GUIDE 2026 | ALL QUESTIONS AND CORRECT
ANSWERS | UPDATED VERSION | VERIFIED ANSWERS | JUST RELEASED
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
, 2
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
, 3
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)
ANSWERS | UPDATED VERSION | VERIFIED ANSWERS | JUST RELEASED
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
, 2
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
, 3
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)
