ExamGecko
Home Home / IIBA / CBDA
Question list
Search
Search

List of questions

Search

Related questions











Question 64 - CBDA discussion

Report
Export

What is the relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order?

A.
one-to-many
Answers
A.
one-to-many
B.
many-to-many
Answers
B.
many-to-many
C.
one-to-one
Answers
C.
one-to-one
D.
zero-to-one
Answers
D.
zero-to-one
Suggested answer: D

Explanation:

The relationship between a Customer entity and an Order entity, where a customer entry will be present in the Customer entity only if they have made an order, is a zero-to-one relationship. This means that for each record in the Order entity, there can be either zero or one record in the Customer entity that is related to it. This implies that the Order entity is optional for the Customer entity, and the Customer entity is mandatory for the Order entity12

Reference: 1: A Guide to the Entity Relationship Diagram (ERD) - Database Star 2: Developing an Application - Oracle

asked 18/09/2024
junjie wang
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first