Figuer:
-Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:
A) 3
B) 4
C) 5
D) 6

Question

Figuer: 
-Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of attributes in the key of the table MEMBER is:
A) 3 
B) 4 
C) 5 
D) 6

Quizplus · Accepted Answer

Based on the ERD diagram, the attributes in the key of the MEMBER table are:
- m_id (from MEMBER entity)
- c_id (from CONTACT entity)
- b_id (from BILLING entity)
- s_id (from SHIPPING entity)

Therefore, there are four attributes in the key of the MEMBER table.

Figuer: -Assuming That We Do Not Use the Rule(s)that Avoid Null