Write each of the cardinalities for the relationships, identified by the letters

Question

Write each of the cardinalities for the relationships, identified by the letters shown. Write them in the proper order in which we read relationships.

A: (1,1) makes (1:N)    

B: ( , ) keeps ( , )       

C:                                    

D:                                    
E:                                   

F:                                   

G:                                  

H:

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

Explanation / Answer

Solution:

A: (1,1) makes (1:N)    

B: ( 1:N ) keeps (1, 1)       

C: ( 1:N ) attends (1, 1)                                     

D:  ( 1:N ) attends (1, 1)                                    
E: ( 1:N ) has (1, 1)                                    

F: ( 1, 1 ) pays (0, N)                                    

G: ( 0:N ) insures (1, 1)                                  

H: ( 1:1 ) covers (0, N)

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

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.