Unit 18 P2 Functional Specification and Data Dictionary

Validation in the application form, payment form and review form will include presence checks, using drop down choices/input masks and data type checks. These validation rules will make sure that all forms are filled out correctly and all data being put into the form are the correct type of data. It will also make sure that the data that is needed is put into the form and any data that isn’t put into the form, an error message shows which means the person must add in the information. Once the members form is completed successfully, they can then move onto the payment form, and then they have to go through the same process to go to the review form. 

Data Type Dictionary

Text: This lets you write in text which can include text, numbers and symbols

Number: This is for numbers and/or decimal numbers

Memo: This is used when there are long pieces of text going into the data as it allows more characters than when just using text.

Date/Time: This only allows you to have numbers between 1-31 for days and 1-12 for months.

Currency: This makes data automatically turn into a currency and puts the £, $ or euro sign up. It also automatically makes sure that the decimal points are in the right places.

Auto Number: This automatically increases the number added to the data base for example, when another person is registered, their username will be a different number from the last person.

Yes/No: This means that the data can only be restricted to either one of these answers.