WGU 468

information literacy - the ability to recognize when information is needed as well as the skills to find, evaluate, and use needed information effectively information - 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 clinical practice guidelines - a...

Get a hint This system is comprised of the hardware and software that make up an organization's infrastructure. - Information Systems This science, originally a sub-discipline of computer science, supports the collection and management of information and applies technology to make information usable. - Information Science The use of information and computer technology to support all aspects of nursing practice, including direct delivery of care, administration, education, and research - ...

An inequality condition is also known as a natural join and an equality condition is also called a theta join. - False When using a(n) _____ join, only rows that meet the given criteria are returned. - inner The statement SELECT * FROM T1, T2 produces a(n) _____ join. - cross A(n) _____ join will select only the rows with matching values in the common attribute(s). - natural If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use...

An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. - recursive The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. - join A database language enables the user to create database and table structures to perform basic data management chores. - TRUE ______________________ is the process the DBMS uses to verify that only registered users access the database....

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

binary relationship -An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. cardinality -An attribute that can be further subdivided to yield additional attributes. For example, a phone number such as may be divided into an area code (615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute. composite identifier -In ER modeling, a key composed of more than one attribute. derived attribute -An attribute that...

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

AREA - in DB2, a named section of permanent storage space that is reserved to store the database. associative entity - another name for composite entity, bridge entity or linking table bridge entity - another name for composite entity, associative entity or linking table candidate key - a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. closure - A property of relational operators that permits the use of relational algebra operators ...

domain - In data modeling, the construct used to organize and describe an attribute's set of possible values superkey - An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key - A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey entity integrity - The property of a relational table that guarantees each entity has a unique value in a primary key and that the key...

Unary relationships are common in manufacturing industries. - TRUE _________________ not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design. - Documentation Ideally, an entity identifier is composed of _____ attribute(s). - one The first step in building an entity-relationship diagram (ERD) is ___________________________________________________________. - creating a detailed n...

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 two examples are attributes? - An employee number; A 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? - Set-to-null Refer to the given SQL statement. CREATE TABLE member ( member_id INT UNSIGNED NOT NULL AUTO_INCREME...

Associative Entity - All relationships for the (...) entity should be many. Attribute - An (...) is a property or characteristic of an entity. Binary relationship - A (...) is a relationship between two entity types. Cardinality - (...) represents the maximum number of entities that can be involved in a particular relationship. Cascade Delete - Will delete all records that reference the primary key Database - A (...) is a collection of information that is organized so that it can easily be...

An inequality condition is also known as a natural join and an equality condition is also called a theta join. - False When using a(n) _____ join, only rows that meet the given criteria are returned. - inner The statement SELECT * FROM T1, T2 produces a(n) _____ join. - cross A(n) _____ join will select only the rows with matching values in the common attribute(s). - natural If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use...

what is information literacy? - The ability to recognize when info is needed as well as the skills to find, evaluate, and use the needed info effectively. How does info literacy support EBP in nursing? - Nurses can use research and apply/consult resources/peers/internet what is nursing informatics? - A specialty that integrates nursing science, computer science, and information science to manage and communicate data, information, knowledge, and wisdom in nursing practice. what is informat...

Data - Collection of numbers, characters, or facts that are gathered according to some perceived need for analysis and possibly action at a later point in time information - Data that has been interpreted knowledge - synthesis of information from several sources to produce a single concept information technology - The management and processing of information with the assistance of computers wisdom - Occurs when knowledge is used appropriately to manage and solve problems data gatherer - I...

Which statement describes a successful electronic health record (EHR)? - The customer's needs were met. What is a goal of the health information exchange (HIE)? - To allow insurance companies and providers to be able to share data Which two care settings would benefit the most from employing a nurse informaticist? - 1. A correctional facility with a clinic 2. A healthcare organization planning a physical expansion Which two practice environments employ informatics nurses? - 1. A clinical ...

Get a hint A nurse documents care of a patient with a decubitus ulcer in the electronic health record. Which term describes the electronic health record in this situation? --Information system Which statement describes nurses as knowledge workers? --Nurses generate knowledge as a product. Which national trend is related to nursing informatics? --Barcode scanning for medication administration Which standardized nursing terminology is composed of nursing diagnoses, nursing actions, and nur...

Get a hint Information LITERACY -The ability to recognize when information is needed as well as the skills to find, evaluate and use needed information effectively. Nurse can use research and apply/consult resources/peers/internet. -How does info literacy support EBP in nursing? Nursing INFORMATICS -An integration of nursing science, computer science, and information science. The unique combination of sciences creates a blend that is greater than the sum of its parts. Information -Data th...

Add New Row - INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - DELETE FROM table_name WHERE condition; Inner Join - SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW - CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate - CONCAT(Col1, Col2) AS NewColumnName; Create Index - CREAT...

The Health Insurance Portability and Accountability Act (HIPAA) is best known for which of the following? - ...created legal protection for PHI. Standardized healthcare terminology is important to nursing for which of the following reasons? - Standardized terminology provides the ability to share accurate, up-to-date information among different providers and settings while ensuring uniform meaning and supporting the development of nursing knowledge. Which of the following statements about ...