Q7.5. During a JAD session the customer mentions that orders are often entered in the system before they have figured out who the customer is. Eventually the customer will be added but it could be quite a while before that happens.

How would you change the model in Figure 7.22 to reflect this?

(a) It does not need to be shown in the model. The customer can just add a pending customer number that will be changed later.

(b) Change the minimum cardinality from the customer to the order to be mandatory.

(c) This is a processing issue that will be reflected in the process model.

The ERD only shows static data needed.

(d) Change the cardinality from the order to the customer to be zero or one.

Transcribed Image Text:

Order is placed by # belongs to has Order Item places Figure 7.22 Entity relationship diagram. Customer