WGU C170 AND C468

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

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

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

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

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

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

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

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

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

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

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

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

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

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