Question

APPONTMENT PK APPT NUM APPT DATE APPT TIME PATIENT DOCTOR PK PAT NUM FK1 INS PLAN CD PK DOC ID PAT_LNAME PAT FNAME PAT AREACODE PAT PHONE PAT EMAIL DOC LNAME DOC FNAME DOC OFFICE DOC EXTENSION FK1 PAT NUM FK2 DOC ID attends C VISIT_DETAIL VISIT PK1,FK1VISIT NUM PK VISIT NUM VISIT_DATE VISIT TIME PK2 VISIT_LINE NUM FK2 PAT NUM FK3 DOC ID tten FK1 PAT NUM FK2 DOC ID VISIT_DATE VISIT TIME pays F INSURANCE INS PAY DETAIL PK INS PLAN CD PK1,FK1 VISIT NUM INSURE COMPANY INSURE_CONTACT INSURE AREACODE INSURE PHONE INSURE EMAIL PK2,FK2 VISIT LINE NUM FK3 INS PLAN CD ADJUST AMT

The relationship strengths shown here are not correct. List the relationship strength as either weak or strong based on your knowledge of primary keys.   

A: weak     

B:     

C:                                    

D:                                    
E:                                   

F:                                   

G:

H:  

Answer 1

Solution:

A: weak     

B: strong   

C: weak

D: weak   
E: strong

F: strong   

G: strong  

H:  strong

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)