BHIS 461 Final Exam Questions With
100% Verified Answers
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
,BHIS 461 Final Exam Questions With
100% Verified Answers
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
,BHIS 461 Final Exam Questions With
100% Verified Answers
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
, BHIS 461 Final Exam Questions With
100% Verified Answers
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
100% Verified Answers
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
,BHIS 461 Final Exam Questions With
100% Verified Answers
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
,BHIS 461 Final Exam Questions With
100% Verified Answers
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
, BHIS 461 Final Exam Questions With
100% Verified Answers
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
