ER Diagrams   «Prev  Next»

Entity Relationships - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. What type of relationship is described by the following rule? For one instance of entity A, there exists zero, one, or many instances of entity B; and for one instance of entity B, there exists zero, one, or many instances of entity A.
Please select the best answer.
  A. 1:1 relationship
  B. 1:N relationsip
  C. M:N relationship

2. What type of relationship is described by this rule? For one instance of entity A, there exists zero, one, or many instances of entity B; but for one instance of entity B, there exists zero or one instance of entity A.
Please select the best answer.
  A. 1:1 relationship
  B. 1:N relationship
  C. M:N relationship

3. What type of relationship is described by this rule? Zero or one instance of entity A can be associated with zero or one instance of entity B, and zero or one instance of entity B can be associated with zero or one instance of entity A.
Please select the best answer.
  A. 1:1 relationship
  B. 1:N relationship
  C. M:N relationship

4. What type of participation does the following sentence describe for Table A? There is no requirement for any records to exist in Table A before any records can be added to Table B.
Please select the best answer.
  A. Mandatory participation
  B. Optional participation
  C. None of the above

5. What type of participation is described for Table B? One record must exist in Table B before any records can be added to Table A.
Please select the best answer.
  A. Mandatory participation
  B. Optional participation
  C. None of the above

Correct answers:

Your Score: 0


Database Design and Theory