BHIS 461 FINAL EXAM QUESTIONS AND 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 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:
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:
