Table contains patient contact information
PatientID PCP
12345 Dr.A
43156 Dr.F
Table B
65417 111-555-4321
You are looking at another sample data set. Pretend you are working with millions of rows.
110381962 2 12445 1809 439656 439663
110083544 1 2041 264 459067 459074
108974134 1 2029 2355 450220 450227
108974134 2 2045 2355 450220 450227
*ICD9 are Diagnosis codes
Figure 2b. Table is called DIAGNOSIS
2052 122715 245.2 THYROIDITIS CHRONIC LYMPH N
4009 124672 388.3 TINNITUS UNSPECIFIED N
12458 133121 V70.0 HEALTH MAINTENANCE ADULT N
4026 124689 389 HEARING LOSS CONDUCTIVE N
Please give a suggestion as to what the primary key of the ENCV table may be.
What information do you think is stored in the field “ECNV.ICD9”?