Muchirigathiru1

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