What kind of relationship exists between the Fall Table and Patient Table?What is the primary key for the 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, an example of data tables that can be created is as follows: Patient Table
Patient lD Last Name First Name Fall Code
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?