Which of the following statements is true about the ERD derived from a form?
A) If there is one relationship between two entity types derived from the parent node, this relationship should be M-N
B) If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M or 1-1
C) If there is one relationship between two entity types derived from the parent node, this relationship should be 1-M
D) If there is one relationship between two entity types derived from the parent node, this relationship should be 1-1

Question

Quizplus · Accepted Answer

If there is one relationship between two entity types derived from the parent node, it can either be a 1-M relationship or a 1-1 relationship. An M-N relationship would imply that there are multiple instances of each entity type associated with each other, which may not be the case in a form. Hence, the best option is B, where the relationship can either be a 1-M or a 1-1 relationship.

Which of the Following Statements Is True About the ERD