Input Masks and Validation Rules:

*Complete the following questions.

* Ensure all team members clearly listed on top of submitted document.

1. Out of the data items above which would require the following validation rules?

1. Sequence Check
2. Existence Check
3. Data Type Check
4. Range Check
5. Reasonableness Check
6. Validity Check

Data Item Description Examples First Name Must start with a capital letter followed by at least one, Li and up to 9 more lowercase letters. Stephanie Middle Initial May have up to one capital letter, or none. J Last Name Must start with a capital letter followed by at least one, Steinbrenner and up to 11 more lowercase letters. Ho Category Must start with two capital letters followed by two AB12 digits. XY01 Postal Code Must have five digits, and may be followed by a 12345 hyphen and four more digits. 12345-9999 Customer ID Must include the first capital letter of the customer's R0118 last name, followed by the last four digits of the B1234 customer's Social Security Number Must include at least six, and no more than 12 letters 1x2y3Z or digits. 123456789999 Password