What is NDNQI and how was it used in the study by Garrard et al.? What is the primary key for the Patient Table? What is the foreign key for the Patient Table? What is the primary key for the Fall Table? Assume that each fall code can be used for multiple patients and each patient can receive only one fall code. What kind of relationship exists between the Fall Table and Patient Table?

NDNQI Injury Falls

For this assignment, refer to the article Reliability and Validity of the NDNQI Injury Falls Measure by Garrard et al. NDNQI fall measures provide a proper method for reporting injury falls, which could be useful for hospitals in comparing their data with reliable national comparison data to develop fall prevention plans.
Based on information presented in Table 1 (Garrard et al., pp. 116-117), an example of data tables that can be created is as follows:

Patient Table
PatientlD  LastName  FirstName  FallCode

001            Smith           Jane           2

002            Doe               John          2

003           Johnson        Mike         1

Fall Table
FallCode     Description

1                 None

2                Minor

3               Moderate

4                Major

5                Death

After reviewing this information, answer the following questions in a Word document:

• What is NDNQI and how was it used in the study by Garrard et al.? Refer to the Module 6 Readings. A short paragraph is expected.
• What is the primary key for the Patient Table?
• What is the foreign key for the Patient Table?
• What is the primary key for the Fall Table?
• Assume that each fall code can be used for multiple patients and each patient can receive only one fall code. What kind of relationship exists between the Fall Table and Patient Table?