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
PatientID	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?

  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
  PatientID	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?

    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
    PatientID	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?