Jessypeace

Associative Entity - All relationships for the (...) entity should be many. Attribute - An (...) is a property or characteristic of an entity. Binary relationship - A (...) is a relationship between two entity types. Cardinality - (...) represents the maximum number of entities that can be involved in a particular relationship. Cascade Delete - Will delete all records that reference the primary key Database - A (...) is a collection of information that is organized so that it can easily be...

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? - Many-to-many Which two examples are attributes? - An employee number; A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? - Set-to-null Refer to the given SQL statement. CREATE TABLE member ( member_id INT UNSIGNED NOT NULL AUTO_INCREME...

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? - Many-to-many Which two examples are attributes? - An employee number; A meeting code Which delete rule sets column values in a child table to a missing value when the matching data is deleted from the parent table? - Set-to-null Refer to the given SQL statement. CREATE TABLE member ( member_id INT UNSIGNED NOT NULL AUTO_INCREME...

Unary relationships are common in manufacturing industries. - TRUE _________________ not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design. - Documentation Ideally, an entity identifier is composed of _____ attribute(s). - one The first step in building an entity-relationship diagram (ERD) is ___________________________________________________________. - creating a detailed n...

domain - In data modeling, the construct used to organize and describe an attribute's set of possible values superkey - An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key - A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey entity integrity - The property of a relational table that guarantees each entity has a unique value in a primary key and that the key...

AREA - in DB2, a named section of permanent storage space that is reserved to store the database. associative entity - another name for composite entity, bridge entity or linking table bridge entity - another name for composite entity, associative entity or linking table candidate key - a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. closure - A property of relational operators that permits the use of relational algebra operators ...

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

binary relationship -An ER term for an association (relationship) between two entities. For example, PROFESSOR teaches CLASS. cardinality -An attribute that can be further subdivided to yield additional attributes. For example, a phone number such as may be divided into an area code (615), an exchange number (898), and a four-digit code (2368). Compare to simple attribute. composite identifier -In ER modeling, a key composed of more than one attribute. derived attribute -An attribute that...

AREA - In DB2, a named section of permanent storage space that is reserved to store the database. associative entity - See composite entity. bridge entity - See composite entity. candidate key - A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure - A property of relational operators that permits the use of relational algebra operators on existing tables (relations) to produce new relations. composite entity - An enti...

An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. - recursive The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. - join A database language enables the user to create database and table structures to perform basic data management chores. - TRUE ______________________ is the process the DBMS uses to verify that only registered users access the database....

An inequality condition is also known as a natural join and an equality condition is also called a theta join. - False When using a(n) _____ join, only rows that meet the given criteria are returned. - inner The statement SELECT * FROM T1, T2 produces a(n) _____ join. - cross A(n) _____ join will select only the rows with matching values in the common attribute(s). - natural If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use...

What is the best measure of the adequacy of cellular perfusion and helps predict the outcome of resuscitation? - Base deficit used in conjunction with serum lactate Will hypocapnia cause vasoconstriction or vasodilation, especially in the cerebral vasculature? - Vasoconstriction What results from tissue hypo perfusion and oxygen deficit? - Metabolic acidosis What type of shock results in generalized vasodilation? - Neurogenic shock Spinal cord injuries at C3-C5 causes loss of what nerves f...

Expedite transfer to the closest trauma center A 56 y/o M pt involved in a motor vehicle crash is brought to the ED of a rural critical access facility. He complains of neck pain, SOB, and diffuse abd pain. His GCS is 15. His VS: BP 98/71, HR 125, RR 26, SpO2 94% on high-flow O2 via NRB mask. Which of the following is the priority intervention for this patient? a pertinent medical hx is crucial Which of the following considerations is the most important when caring for a geriatric trauma pt...

Primary concern when a person cannot stop coughing/clearing their throat following house fire/smoke? - Airway/Intubate Lab evidence of cellular perfusion - Base Excess (Less than -6 is BAD) Multiple people are in the ER of different ages who all go to the same church. They all have the same symptoms. What is the most likely cause? - Biologic Suspected shock type with a spinal cord injury - Distributive Shock (Includes neurogenic) Patient has GCS of 3, unequal pupils (one sluggish, one blow...

Biomechanics - Is the general study of forces & their effects Kinematics - Is the study of energy transfer as it applies to ID'ing actual or potential injuries Mechanism of Injury (MOI) - Is how external forces are transferred to the body, resulting in injury Newton's 1st Law of Motion - A body @ rest, stays @ rest unless acted on by an outside force Newton's Second Law - The acceleration of a body is parallel & directly proportional to the net force acting on the body, is in the directi...

All of these are considered a critical communication point in trauma care EXCEPT which of the following? - Defusings A defusing is part of critical incident stress management but is not considered a critical communication point in trauma care. .During the primary survey of an unconscious patient with multi-system trauma, the nurse notes snoring respirations. What priority nursing intervention should be performed next? - Insert an oropharyngeal airway if there is no gag reflex Snoring respir...

All of these are considered a critical communication point in trauma care EXCEPT which of the following? - Defusings A defusing is part of critical incident stress management but is not considered a critical communication point in trauma care. .During the primary survey of an unconscious patient with multi-system trauma, the nurse notes snoring respirations. What priority nursing intervention should be performed next? - Insert an oropharyngeal airway if there is no gag reflex Snoring respir...

A patient fell two weeks ago, striking their head. Today, the patient presented with a persistent headache and nausea and was diagnosed with a small subdural hematoma. The patient has been in the ED for 24 hours awaiting an inpatient bed. The night shift nurse reports the patient has been anxious, restless, shaky, and vomited twice during the night. The patient states they couldn't sleep because a young child kept coming into the room. What is the most likely cause for these signs and symp...

A patient with borderline personality disorder experiences intense anxiety when an adult psychiatric and mental health nurse practitioner goes on vacation. The best explanation for this reaction is that the patient: A. has failed to develop clear ego boundaries. B. has failed to master object constancy. C. is employing primitive idealization. D. is employing projective identification. - B. has failed to master object constancy 2. A patient has been taking escitalopram (Lexapro) 10 mg dail...

A patient with borderline personality disorder experiences intense anxiety when an adult psychiatric and mental health nurse practitioner goes on vacation. The best explanation for this reaction is that the patient: A. has failed to develop clear ego boundaries. B. has failed to master object constancy. C. is employing primitive idealization. D. is employing projective identification. - B. has failed to master object constancy 2. A patient has been taking escitalopram (Lexapro) 10 mg dail...