PAPER QUESTIONS AND SOLUTIONS GRADED
A+
◉ When setting up relational databases, the primary
key refers to a field or set of fields that. Answer: uniquely identifies
each record stored in the table.
◉ Technology assessment within a project is used to:. Answer:
consider the effect of technology when it is
introduced, extended, or modified.
◉ MUMPS or M. Answer: traditional database model of healthcare
(similar to NoSQL) -> hierarchical database
◉ MUMPS advantage. Answer: Elastic horizontal scaling across
multiple low-cost commodity servers.
Designed to support Big Data quantities of data beyond the
capabilities of RDBMS with extremely high performance.
Extremely simple to administer requiring essentially no DBAs.
Very low cost resulting from commodity hardware and open source
code.
,Flexible data modeling able to easily duplicate the features of
RDBMS, key value, columnar, document, and graph architectures.
Readily supports advanced analytics and BI with SQL.
Full ACID for OLTP
◉ Object-oriented databases. Answer: An object-oriented database
management system (OODBMS) provides a fast way to access
images and sound information and can understand multiple
programming languages.
◉ hypermedia databases. Answer: access to objects, video and audio
files.
◉ distributed database. Answer: allows for space to be added so the
database can grow and remain working if one of its contributing
databases stops working
◉ master patient index (MPI). Answer: identify the patient's records
with numbers that
all people who access the database use
◉ Evidence-based medicine, or EBM. Answer: a collaborative
database of conclusions based on patient cases that can be used as a
source for healthcare providers.
,◉ Systems related to healthcare are divided
into 3 groups, which are?. Answer: mechanical systems, human
systems, and man-machine systems
◉ Mechanical systems. Answer: systems necessary for a healthcare
organization to function
mechanically, including the capability of maintaining the physical
environments of the organization
◉ human system. Answer: system relating to people, including
patients and physicians and their relationships.
◉ Man-machine systems. Answer: systems that are used to aid a
person in the healthcare process.
◉ Define a healthcare system. Answer: 1. A system is something that
has oneness and can be described based on its unique
characteristics. A system will be its own entity and elicit a precise
description.
2. A system contains interwoven parts that are numerous and rely
on each other for the
system to function. A healthcare system will have many levels and
each level can be broken
, down into smaller levels.
3. A system will change when necessary and resist deterioration
when system upgrades are
necessary.
4. A system must be able to react to defined situations and to
situations that are not defined. It
must be adaptable to human needs.
5. The system must be able to receive information, process the
information and provide a
response to the information.
6. The system has to be able to adjust itself to the response or output
it provides, a process
that is referred to as feedback.
7. An open system can be affected by external sources while a closed
system is self-contained
and cannot be affected by outside sources.
◉ Health maintenance organizations (HMOs). Answer: physicians
that see patients within a specific insurance plan for a prearranged
price set between the insurance company and HMO
◉ preferred provider organization (PPO). Answer: physician who
provides medical services for a lower cost to a predefined group of
people