C 468 OA

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

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. Information - -Data that has been interpreted Information Science - -Focus on how to gather, process and transfo...

C 468 OA, informatics PRACTICE assessment 2023/131 Questions and Answers.