Muchirigathiru1

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

How do you assess cranial nerve V trigeminal? - Tell patient to close eyes, take piece of cotton or other soft item and lightly touch either one of both sides of each of the three divisions of the trigeminal. How do you assess for cranial nerve VII facial? - Observe the patient for nystagmus or twitching of the eye. This nerve controls facial movements and expression, check for symmetry. Have the patient wrinkle forehead, close eyes, smile, pucker lips, show teeth, and puff out cheeks. pri...

What direct-acting dopamine receptor agonist is recommended to be used in the treatments of neuroleptic malignant syndrome (NMS) fo help lower the dopamine blockade? A) benzotropine (Cogentin) B) bromocriptine (Parlodel) C) dantrolene (Dantrium) D) trihexyphenidyl (Artane) - A) Bromocriptine (Parlodel) is the recommended direct acting dopamine receptor agonist to help decrease the dopamine blockade. Danrolene (Dantrium) is a muscle relaxant. Benzotropine (Cogentin) and Trihexyphenidyl (Ar...

Positive Romberg Sign - (r/t etoh) loss of balance that occurs when closing the eyes ETOH withdrawal delirium may result in? - Seizures or death DSM Severity for ETOH - Mild = 2-3 sx Moderate = 4-5 sx Severe = >= 6 sx DSM ETOH Remission Criteria - Early = >3 mos & <12 mos Substantial Remission = >12 mos Screening & Early Intervention scale for SUD - SBIRT Screening, Brief Intervention & Refereal to Treatment CAGE - Cut down Annoyed Guilty Eye-Opener >=2 is clinically ...

increase prolactin - - Stop prolactin (stop the agent that cause increase prolactin) 3-year-old masturbates, play with self, says naughty things - Normal for Piaget 5-year-old tells you his brother sodomized him - - Tell mom don't leave him alone with patient and call CPS implement crisis 13-year-old want to smoke - - Ask him of his plan to stop smoking 14-year-old girl clenching her teeth - - Cranial nerve V-Trigeminal nerve 16-year-old falls with the wrong crowd - - Conduct disorder 16...

DBT (dialectical behavior therapy) - relaxation muscle prior to DBT Greatest patient at risk for Violence - Substance abuse EMDR (eye movement desensitization and reprocessing) - eye movement desensitization and reprocessing What is dissemination? - Getting the research information out to those who need to know it! Publication - highest level Presenting at National Conference Presenting at Local Conference Journal Club where one person reviews an article What does a 17 on MMSE mean? - M...

A 14-year-old patient has nonspecific complaints about pain in his or her legs. The physical examination is unremarkable. Laboratory results are within normal limits except for a markedly elevated alkaline phosphatase level. The psychiatric-mental health nurse practitioner - interprets the findings as normally occurring during a rapid adolescent growth spurt Laboratory findings for a patient with an alcohol use disorder indicate increased liver function values and: - increased MCV and eleva...