What is the primary key for the Patient Table?What is the foreign key for the Patient Table?

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:

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

a What is the primary key for the Patient Table?

a What is the foreign key for the Patient Table?

a What is the primary key for the Fall Table?

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