Muchirigathiru1
On this page, you find all documents, package deals, and flashcards offered by seller muchirigathiru1.
- 2678
- 0
- 0
Community
- Followers
- Following
2678 items
Data Management - Applications - C170 Performance Labs - uCertify
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 ...
- Exam (elaborations)
- • 5 pages •
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 ...
C170 - Data Management Applications
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...
- 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 Norma...
Information Management WGU C468 #1
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...
- Exam (elaborations)
- • 46 pages •
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...
Lesson 5: Indexes (FLASH CARDS) - C170 - Database Management Applications (WGU)
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...
- Exam (elaborations)
- • 3 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. 
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...
ANCC PMHNP Cert Exam Review Questions
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...
- Exam (elaborations)
- • 10 pages •
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...
ANCC Review Questions (PMHNP IQ)
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...
- Exam (elaborations)
- • 9 pages •
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...
PMHNP Board Review (2020)
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 ...
- Exam (elaborations)
- • 20 pages •
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 ...
PMHNP board set QUESTIONS AND ANSWER
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...
- Exam (elaborations)
- • 33 pages •
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...
PMHNP Exam Reported Questions images, pmhnp
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...
- Exam (elaborations)
- • 29 pages •
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...
PMHNP Boards ALREADY PASSED
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...
- Exam (elaborations)
- • 10 pages •
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...