Database Design   «Prev  Next»

Business Rules and Constraints - Exercise

Objective: Translate business rules into constraints and infer a rule from a form restriction.

Three requirements

Assume the following are policies of the fictional organizations in this exercise. Describe the rule and a suitable enforcement approach in plain language; executable SQL is not required.

  1. Each customer order must have a total from $1.00 through $500.00, inclusive. Describe how to reject missing and out-of-range totals.
  2. A high-school instructor may sponsor at most two student committees. Describe what must be checked when sponsorships are created or reassigned, including simultaneous requests.
  3. An order form offers only Mastercard, Visa and Discover. Infer the likely payment policy and explain why restricting buttons alone does not enforce it.

Self-assessment: 15 points

Each answer is worth 5 points: 2 for stating the rule accurately, 2 for a suitable enforcement approach, and 1 for the relevant edge case (missing amount, concurrent sponsorship changes, or bypassed form validation). This is a self-assessment; the page displays a model answer and does not grade free text.

Submit your response

Enter your answers, then select Submit to compare them with the model answer.