Assignment: Business Rules

Part 1: Consider organizations that you have knowledge of as an employee, supplier, or customer. Choose one organization, enter its name, and list fifteen business rules the organization appears to implement that relate to data the organization collects.

Enter the organization's name in the area below.

Amazon: List business rules in the area below.

1. Each customer can place many orders.

2. Each order can contain many products.

3. Each order can ship to many locations.

4. Each order can only have one order number.

5. The purchase can be paid by either credit card or gift card.

6. Each order can be shipped through many shipping methods.

7. The customer must provide the correct address in order to complete the order.

8. Each supplier can have many products to be sold on Amazon.

Part 2: From an auditing standpoint, explain the importance of business rules in the audit process (minimum 200 words).

Part 3: In your opinion, should the business rules of an organization be updated over time? Provide an example to illustrate why or why not (minimum 200 words).

Part 4: In the space below, describe what business rules require to be effective. Also explain the sources of business rules and what the database designer's role is with regard to business rules (minimum 100 words).