Question

For each of the following business rule , at first identify the type of business rule constraint and then compose a single sentence that generally describes the constraint you would impose . ( A sentence might read something like this : Place a ( relationship or field ) constraint on . . . . )

i ) A patient can has many ( medical ) orders written for him or her .

ii ) A ship date cannot be prior to an order date for any given order .

Answer 1

i.

Type of rule: Structural rule

An order must be written for the concerned patient. A patient may have several orders but all of those must be in writing. This indicates a structure of the system.

Single sentence: place a constraint on non-written orders.

Non-written orders are restricted to entertain.

ii.

Type of rule: Structural rule

The date of shipment must not be a prior date of an order. This is the structure of international trade. Therefore, the order date must come first then the shipment date.

Single sentence: place a constraint on pre-dated shipment from the date of order.   

Pre-dated shipment should be restricted.