Test: Quiz: Documenting Business Rules

Section 1

1. Why is it important to identify and document business rules? Mark for Review

(1) Points

It allows you to create your data model, then check for accuracy. (*)

It allows you to improve the client's business.

It ensures that the data model will automate all manual processes.

None of the above


2. A business rule such as "All accounts must be paid in full within 10 days of billing" is best enforced by: Mark for Review

(1) Points

Making the payment attribute mandatory.

Making the relationship between CUSTOMER and PAYMENT fully mandatory and 1:1 on both sides.

Creating a message to be printed on every bill that reminds the customer to pay within ten days.

Hiring a programmer to create additional programming code to identify and report accounts past due. (*)


3. How should you handle constraints that cannot be modeled on an ER diagram? Mark for Review

(1) Points

Always let the network architect handle them

List them on a separate document to be handled programmatically (*)

Explain them to the users so they can enforce them

All constraints must be modeled and shown on the ER diagram


4. Which of the following is an example of a structural business rule? Mark for Review

(1) Points

All employees must belong to at least one department. (*)

Buildings to be purchased by the business must be current with earthquake building code.

All overdue payments will have an added 10 % late fee.

All products will have a selling price no less than 30 % greater than wholesale.


5. Only managers can approve travel requests is an example of which of the following? Mark for Review

(1) Points

A structural business rule.

A mandatory business rule.

A procedural business rule. (*)

An optional business rule.


6. How would you model a business rule that states that on a studentï¾’s birthday, they do not have to attend their classes? Mark for Review

(1) Points

Use a supertype

Use a subtype

Make the attribute Birthdate mandatory

You cannot model this. You need to document it (*)


7. Business rules are important to data modelers because: Mark for Review

(1) Points

A. They capture all of the needs, processes and required functionality of the business. (*)

B. They are easily implemented in the ERD diagram.

C. The data modeler must focus on structural rules, because they are easily represented diagrammatically and eliminate other rules that involve extra procedures or programming.

D. Both A and C are true.

Solution for Test: Quiz: Introduction to The Oracle Academy
Solution for Test: Quiz: Data vs Information