Muchirigathiru1

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 ...

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...

c. Data Mining -Which of the following uses database applications to sift through large amounts of data and looks for previously hidden trends? a. Evidence-Based Practice b. Quantitative Analysis c. Data Mining d. Digital Library c. To promote desired clinical outcomes -A nurse is reviewing a patient's pneumonia vaccination status in the electronic medical record. The nurse determines the patient needs this vaccine before discharge to meet the requirements of a current clinical pathway....

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...

1.1.1 - Conceptual Schema - ER Model Tables: Customer, DonutOrder, Donut - Customer: PK - CustomerID Rest are customer related fields DonutOrder: FK - CustomerID, FK - DonutID Qty, SpecialNotes Donut: PK - DonutID Rest are donut fields Relationships: Customer - 1:n Identifying - DonutOrder DonutOrder - n:1 Identifying - Donut Why are the relationships in 1.1.1 Identifying? - The PK's of Customer and Donut are included in the composite primary key of DonutOrder. 2.1.1 - Physical ...

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 Norma...

3 types of clinical information systems -Laboratory system, Order entry system, and Monitoring system 3 types of clinical information systems -Laboratory system, Order entry system, and Monitoring system A benefit of EHR is that it can provide patient support. Example of a patient support -Patient education material such as reducing sodium intake A benefit of EHR is that it can provide patient support. Example of a patient support -Patient education material such as reducing sodium intake...

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. algorithms - A process or set of operations in a calculation. automatic query optimization - A method by which a DBMS finds the most efficient access path for the execution of a query. B-tree index - An ordered data structure organized as an upside-down tree. bitmap index - An in...

How do you assess cranial nerve V trigeminal? - Tell patient to close eyes, take piece of cotton or other soft item and lightly touch either one of both sides of each of the three divisions of the trigeminal. How do you assess for cranial nerve VII facial? - Observe the patient for nystagmus or twitching of the eye. This nerve controls facial movements and expression, check for symmetry. Have the patient wrinkle forehead, close eyes, smile, pucker lips, show teeth, and puff out cheeks. pri...