BHIS 461 FINAL EXAM CORRECT 100%
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
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
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
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
