SNHU DAD 220 FINAL TEST 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
• Database Development Phases.
Answer: 1. Conceptual Design 2. Logical Design 3. Physical Design
• Data Dictionary.
Answer: Additional information about the data that is provided
• Composite Key.
Answer: Primary key made of two attributes
• temporary vascular access catheter in the left femoral vein.
Answer: bed rest (prevent trauma to vein)
• One-One Relationship.
Answer: Record in A has one match in Record B. Done with a primary key
in A that is a foreign key in B
• Initial phase of MI.
Answer: sympathetic NS release (norepinephrine and epinephrine) =
diaphoresis, increased HR and BP (later drops from decreased CO) and
vasoconstriction of peripheral blood vessels, Fever (up to 100.4, 38 in first
24-48 hrs) patient's skin may be ashen, clammy, and cool to touch.
• One-Many.
Answer: One A can have many B's. Done with a primary keu in A that is a
foreign key in B
• patient with a STEMI must.
Answer: undergo cardiac catheterization within 90 minutes of presentation
or receive thrombolytic therapy within 30 minutes in agencies without PCI
capability
• azotemia.
, Answer: accumulation of nitrogenous waste products (urea nitrogen,
creatinine) in the blood
• Attribute Maximum.
Answer: One (Singular) or Many (Plural)
• Primary Keys.
Answer: Unique identifiers for a table. Stable, simple, and meaningless
values
• arteriovenous graft (AVG) placement and pt complains of coldness in
fingers.
Answer: report to HCP (SS of inadequate perfusion to extremity)
• Discovery.
Answer: Database Design step where we discover the entities, relationships,
and attributes
• Right after dialysis pt received really high dose of medication (because
dialysis takes all the drug levels away).
Answer: SO the next day you maybe wouldn't give the drug because the
previous dose is still circulating in blood stream (dialysis hasn't occurred yet
so nothing filtered out the med)
• Bridge Table.
Answer: This is required to map a many-to-many relationship. It is a table of
two primary keys (one from A and one from B)
• Unique.
Answer: Attribute that describes one specific entity
• Ventricular Tachycardia.
Answer: ectopic focus or foci fire repeatedly and the ventricle takes control
as the pacemaker = three or more consecutive PVCs Ventricular rate:
150-250 bpm SS: hypotension, pulmonary edema, decreased cerebral blood
flow, and cardiopulmonary arrest
• ONAM.
, Answer: O- Position patient upright unless contraindicated. • Give O2 by
nasal cannula or nonrebreather mask. N- Sublingual first until IV nitro is
ready. Monitor BP A- aspirin (chewable). Aspirin should never be stopped.
M- Morphine: decreases cardiac workload by lowering myocardial O2
consumption, reduce fear and stress
• Relationship.
Answer: Statement about two entities
• calculating the fluid restriction.
Answer: add all losses for the previous 24 hours + plus 600 mL for
insensible losses
• Unstable angina (UA).
Answer: chest pain that is new in onset, occurs at rest. The pain usually lasts
10 minutes or more
• Atrial Fibrillation.
Answer: total disorganization of atrial electrical activity because of multiple
ectopic foci = loss of atrial contraction. Irregular QRS complex atrial rate-
350-600 bpm ventricular rate- 60-100 bpm (controlled) 100+ (rapid
ventricular response) decrease in CO because of ineffective atrial
contractions, thrombi in atria from stasis = anticoagulants
• Polymorphic Tachycardia OR Torsades de Points.
Answer: QRS complexes gradually change back and forth from one shape,
size, and direction to another over a series of beats
• When caring for a patient with mitral valve stenosis, it is most important
that the nurse assess for.
Answer: shortness of breath upon exertion
• Artificial Key.
Answer: Primary Key made by DBAs. Typically a row ID
• when a patient should stop exercise after MI.
Answer: - chest pain - change in heart rate of more than 20 beats over the
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
• Database Development Phases.
Answer: 1. Conceptual Design 2. Logical Design 3. Physical Design
• Data Dictionary.
Answer: Additional information about the data that is provided
• Composite Key.
Answer: Primary key made of two attributes
• temporary vascular access catheter in the left femoral vein.
Answer: bed rest (prevent trauma to vein)
• One-One Relationship.
Answer: Record in A has one match in Record B. Done with a primary key
in A that is a foreign key in B
• Initial phase of MI.
Answer: sympathetic NS release (norepinephrine and epinephrine) =
diaphoresis, increased HR and BP (later drops from decreased CO) and
vasoconstriction of peripheral blood vessels, Fever (up to 100.4, 38 in first
24-48 hrs) patient's skin may be ashen, clammy, and cool to touch.
• One-Many.
Answer: One A can have many B's. Done with a primary keu in A that is a
foreign key in B
• patient with a STEMI must.
Answer: undergo cardiac catheterization within 90 minutes of presentation
or receive thrombolytic therapy within 30 minutes in agencies without PCI
capability
• azotemia.
, Answer: accumulation of nitrogenous waste products (urea nitrogen,
creatinine) in the blood
• Attribute Maximum.
Answer: One (Singular) or Many (Plural)
• Primary Keys.
Answer: Unique identifiers for a table. Stable, simple, and meaningless
values
• arteriovenous graft (AVG) placement and pt complains of coldness in
fingers.
Answer: report to HCP (SS of inadequate perfusion to extremity)
• Discovery.
Answer: Database Design step where we discover the entities, relationships,
and attributes
• Right after dialysis pt received really high dose of medication (because
dialysis takes all the drug levels away).
Answer: SO the next day you maybe wouldn't give the drug because the
previous dose is still circulating in blood stream (dialysis hasn't occurred yet
so nothing filtered out the med)
• Bridge Table.
Answer: This is required to map a many-to-many relationship. It is a table of
two primary keys (one from A and one from B)
• Unique.
Answer: Attribute that describes one specific entity
• Ventricular Tachycardia.
Answer: ectopic focus or foci fire repeatedly and the ventricle takes control
as the pacemaker = three or more consecutive PVCs Ventricular rate:
150-250 bpm SS: hypotension, pulmonary edema, decreased cerebral blood
flow, and cardiopulmonary arrest
• ONAM.
, Answer: O- Position patient upright unless contraindicated. • Give O2 by
nasal cannula or nonrebreather mask. N- Sublingual first until IV nitro is
ready. Monitor BP A- aspirin (chewable). Aspirin should never be stopped.
M- Morphine: decreases cardiac workload by lowering myocardial O2
consumption, reduce fear and stress
• Relationship.
Answer: Statement about two entities
• calculating the fluid restriction.
Answer: add all losses for the previous 24 hours + plus 600 mL for
insensible losses
• Unstable angina (UA).
Answer: chest pain that is new in onset, occurs at rest. The pain usually lasts
10 minutes or more
• Atrial Fibrillation.
Answer: total disorganization of atrial electrical activity because of multiple
ectopic foci = loss of atrial contraction. Irregular QRS complex atrial rate-
350-600 bpm ventricular rate- 60-100 bpm (controlled) 100+ (rapid
ventricular response) decrease in CO because of ineffective atrial
contractions, thrombi in atria from stasis = anticoagulants
• Polymorphic Tachycardia OR Torsades de Points.
Answer: QRS complexes gradually change back and forth from one shape,
size, and direction to another over a series of beats
• When caring for a patient with mitral valve stenosis, it is most important
that the nurse assess for.
Answer: shortness of breath upon exertion
• Artificial Key.
Answer: Primary Key made by DBAs. Typically a row ID
• when a patient should stop exercise after MI.
Answer: - chest pain - change in heart rate of more than 20 beats over the
