©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
HISM (D033): Chapter 3 Exam Questions
and Answers 100% Solved
Boolean search - ✔✔capabilities such as "and," "or," and "not" may be
used in the QBE database to narrow down the data to specifically what the
user needs.
For example, the query could retrieve patients who had a principal
diagnosis of cholecystitis "and" a principal procedure of laparoscopic
cholecystectomy.
Clinical data repository (CDR) - ✔✔A centralized data repository
Computer-aided software engineering (CASE) - ✔✔A tool designed to
create many of the diagrams and other tools used in the data model
Conceptual data model - ✔✔Model that is not tied to a particular database
model, but rather defines the requirements for the database to be
developed. It is the basis for the logical and physical data models
Data control language (DCL) - ✔✔controls access to data within a
database
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Data definition language (DDL) - ✔✔A special type of software used to
create the tables within a relational database. It translates how data are
stored in the computer from the physical view (physical structure of the
database) to the logical view (one that is understandable by the user)
Data dictionary - ✔✔a descriptive list of the names, definitions, and
attributes of data elements to be collected in an IS or database whose
purpose is to standardize definitions and ensure consistent use
Data field - ✔✔A predefined area within a database in which the same type
of information is usually recorded such as the data of birth
Data flow diagram (DFD) - ✔✔A diagram that shows how data moves
(input, storage, output) within the database. It is a way to show
management and other nontechnical users the system design
Data manipulation - ✔✔Allowing the user to add and delete rows in a table
and to sort, find, and compare. Another function of the data manipulation
component is to update data
Data manipulation language (DML) - ✔✔A special type of software used to
retrieve, update, and edit data in a relational database. The DML accesses,
makes changes to, and retrieves data from the database
HISM (D033): Chapter 3 Exam Questions
and Answers 100% Solved
Boolean search - ✔✔capabilities such as "and," "or," and "not" may be
used in the QBE database to narrow down the data to specifically what the
user needs.
For example, the query could retrieve patients who had a principal
diagnosis of cholecystitis "and" a principal procedure of laparoscopic
cholecystectomy.
Clinical data repository (CDR) - ✔✔A centralized data repository
Computer-aided software engineering (CASE) - ✔✔A tool designed to
create many of the diagrams and other tools used in the data model
Conceptual data model - ✔✔Model that is not tied to a particular database
model, but rather defines the requirements for the database to be
developed. It is the basis for the logical and physical data models
Data control language (DCL) - ✔✔controls access to data within a
database
, ©JOSHCLAY 2024/2025. YEAR PUBLISHED 2024.
Data definition language (DDL) - ✔✔A special type of software used to
create the tables within a relational database. It translates how data are
stored in the computer from the physical view (physical structure of the
database) to the logical view (one that is understandable by the user)
Data dictionary - ✔✔a descriptive list of the names, definitions, and
attributes of data elements to be collected in an IS or database whose
purpose is to standardize definitions and ensure consistent use
Data field - ✔✔A predefined area within a database in which the same type
of information is usually recorded such as the data of birth
Data flow diagram (DFD) - ✔✔A diagram that shows how data moves
(input, storage, output) within the database. It is a way to show
management and other nontechnical users the system design
Data manipulation - ✔✔Allowing the user to add and delete rows in a table
and to sort, find, and compare. Another function of the data manipulation
component is to update data
Data manipulation language (DML) - ✔✔A special type of software used to
retrieve, update, and edit data in a relational database. The DML accesses,
makes changes to, and retrieves data from the database
