C 468 OA

Informatics - The science and art of turning data into information. Nursing Informatics * - -The use of information and technology to support all aspects of nursing practice -Including direct delivery of care, administration, education, and research. Information Literacy - -The ability to recognize when info is needed as well as the skills to find, evaluate and use effectively. Information - -Data that has been interpreted Information Science - -Focus on how to gather, process and transfo...

Informatics - The science and art of turning data into information. Nursing Informatics * - -The use of information and technology to support all aspects of nursing practice -Including direct delivery of care, administration, education, and research. Information Literacy - -The ability to recognize when info is needed as well as the skills to find, evaluate and use effectively. Explain the effect of socioeconomic factors on the use of telehealth. - Access to care, to remove geographical b...

AREA - In DB2, a named section of permanent storage space that is reserved to store the database. associative entity - See composite entity. bridge entity - See composite entity. candidate key - A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure - A property of relational operators that permits the use of relational algebra operators on existing tables (relations) to produce new relations. composite entity - An enti...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? - Many-to-many Which kind of relationship is displayed in this entity-relationship diagram? - Many-to-many unary Which two examples are attributes? Choose 2 answers - AN Employee number, and meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table?...

Syntax for updating a specific column in a specific row - UPDATE <table> SET <atrribute> = <value> WHERE <primary key> = <value>; Syntax for deleting a row - DELETE FROM <TableName> WHERE <PrimaryKey> = <#>; Syntax for creating a view - CREATE VIEW <name> AS SELECT <columnname> CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes> FROM <tablename> Syntax to create an Index - CREATE IN...

Access plan -A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias -An alternative name for a column or table in a SQL statement. ALTER TABLE -The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. AREA -In DB2, a named section of...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary - Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code - An employee number A meeting code Which delete rule sets column values in a child table to a missing value when the matching...

DML - IUDS, CR insert, update, delete, select commit, rollback INSERT - add new rows UPDATE - modify data of existing rows DELETE - delete some/all records from database can be rolled back COMMIT - permanently saves ROLLBACK - undo changes SELECT - data retrieval WHERE - limits rows returned used before group by ORDER BY - OC sorts columns

An entity is said to be X -dependent if it can exist in the database only when it is associated with another related entity occurrence. - existence A table that has all key attributes defined has no repeating groups and all its attributes are dependent on the primary key is said to be in X. - 1nf A determinant is any attribute whose value determines other values within a column. - F X is a process that is used for changing attributes to entities. - Normalization Any attribute whose value d...

First Normal Form - - when all non-key columns depend on the primary key - a table with a primary key is in first normal form - a table with no duplicate rows is in first normal form Second Normal Form - - when all non-key columns depend on the whole primary key - cannot depend on part of a composite primary key - a table with a simple primary key is automatically in second normal form A table with a simple primary key must be in what normal form? - - second normal form or higher Third N...

Interface - Computer program that tells two different systems how to exchange data Interoperability - The ability of two entities, human or machine, to exchange and predictably use data or information while retaining the original meaning of that data Integration - The process by which different information systems are able to exchange data in a fashion that is seamless to the end user Standardized terminology - The implementation of this within the EHR is essential for healthcare organizat...

1. An informatics nurse and an emergency nurse are conducting an analysis of a patient admission from the ER? Which tool should these nurses use for a process analysis? -SWOT template 1. What is an effective way to reduce the risk of access of electronic protected health information (ePHI) by unauthorized users? -Make sure all users adhere to security and confidential policy set forth by the facility What is the goal of MIPS and MU? -Patient quality care A provider at the hospital had his ...

1. An informatics nurse and an emergency nurse are conducting an analysis of a patient admission from the ER? Which tool should these nurses use for a process analysis? -SWOT template 1. What is an effective way to reduce the risk of access of electronic protected health information (ePHI) by unauthorized users? -Make sure all users adhere to security and confidential policy set forth by the facility What is the goal of MIPS and MU? -Patient quality care A provider at the hospital had his ...

Information literacy -Defined as the ability to recognize when information is needed as well as the skills to find, evaluate and use needed information effectively Information -Term used to describe data that has been interpreted Information science -Focus on how to gather, process and transform information into knowledge. It also incorporates features from 5 other sciences -communication science -computer science -social science -library science -cognitive science Information systems ...

Informatics - "The big oak tree" combination of the nursing science, computer science and information science. It includes information technologies that can help support nursing practice. Information technology - "The branch" electronic healthcare record, your clinical decisions support tools, bar code medication administration, and so on. information System - "Another branch" : used to collect, create and distribute useful data. This term describes the development, use and managem...

Informatics -"The big oak tree" combination of the nursing science, computer science and information science. It includes information technologies that can help support nursing practice. Information technology -"The branch" electronic healthcare record, your clinical decisions support tools, bar code medication administration, and so on. information System -"Another branch" : used to collect, create and distribute useful data. This term describes the development, use and management...

System security involves protection against - deliberate attacks, errors, omissions, disasters and viruses Which of the following is a mechanism that logs the user off a system after a specified period of inactivity on the terminal or computer? - automatic sign off The sharing of private information in a situation in which a relationship has been established for the purpose of treatment with the understanding this information will remain protected is - Confidentiality ____ is a combo of h...

Wisdom - Using knowledge and experience to manage and solve problems Knowledge - Synthesis of information from several sources to produce a single concept or idea Information - Data that has been interpreted Data - a collection of numbers, characters, or facts that are gathered according to some perceived need for analysis Knowledge worker - Individual with a high degree of expertise, education, or experience who creates, distributes, and applies knowledge Knowledge builder - One who exam...

Wisdom - Using knowledge and experience to manage and solve problems Knowledge - Synthesis of information from several sources to produce a single concept or idea Information - Data that has been interpreted Data - a collection of numbers, characters, or facts that are gathered according to some perceived need for analysis Knowledge worker - Individual with a high degree of expertise, education, or experience who creates, distributes, and applies knowledge Knowledge builder - One who exam...

Which theory of depression was developed based on observing that patients who were being treated for Hep C developed depressive symptoms? A. The monoamine theory B. The inflammation theory C. The HPA axis theory D. The stress-diathesis theory - b. The inflammation theory Which of the following health conditions have a high co-morbidity with depression? A. Hypertension B. Asthma C. Diabetes mellitus D. Cardiovascular disease E. Celiac disease F. Cognitive impairment G. Obesity H. Ca...