Muchirigathiru1
On this page, you find all documents, package deals, and flashcards offered by seller muchirigathiru1.
- 2675
- 0
- 0
Community
- Followers
- Following
2675 items
C 468 OA, informatics PRACTICE assesment, C468
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...
- Exam (elaborations)
- • 17 pages •
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...
C170 Data Management Application RATED A+
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...
- Exam (elaborations)
- • 31 pages •
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...
C170 PA ALREADY PASSED
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?...
- Exam (elaborations)
- • 7 pages •
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?...
C170 Performance Assessment QUESTION AND ANSWER
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...
- Exam (elaborations)
- • 2 pages •
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...
C170 QUESTION AND ANSWER ALREADY PASSED
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...
- Exam (elaborations)
- • 13 pages •
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...
C170 - PRE-ASSESSMENT
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...
- Exam (elaborations)
- • 19 pages •
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...
C170 WGU ALREADY PASSED
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
- Exam (elaborations)
- • 5 pages •
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
C170 WGU ALREADY PASSED
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...
- Exam (elaborations)
- • 6 pages •
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...
C170 - Data Management Applications ALREADY PASSED
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...
- Exam (elaborations)
- • 13 pages •
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...
C468 ALREADY PASSED
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...
- Exam (elaborations)
- • 3 pages •
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...