Case 3-1 PrattLast Associates Has Decided to Add Some Additional Validation Rules

question 12

Essay

Case 3-1
PrattLast Associates has decided to add some additional validation rules to the Account table. They have asked you to create these validation rules.
-Because many of the accounts that PrattLast Associates services are located in Pennsylvania, management would like to minimize any data entry in this field. What property do you need to change and what would you enter in the property box?

---

Definitions:

Compounded Monthly

Indicates that interest is calculated and added to the principal balance of an investment or loan on a monthly basis, leading to exponential growth over time.

Future Value

The value of an asset or amount of money at a specific date in the future that is equivalent in value to a specified sum today.

Rate of Interest

Another term for interest rate, it specifies the amount charged, expressed as a percentage of the principal, by a lender to a borrower for the use of assets.

Rate of Return

A rise or fall in an investment's value during a specified time, shown as a percentage of the cost of the investment.