Detailed · Deep study
1File and data structures
| Field name | Data type | Field length | Notes |
|---|---|---|---|
| MemberID | text | 6 | primary key, e.g. M00123 |
| Surname | text | 30 | |
| DateOfBirth | date | – | DD/MM/YYYY |
| Gender | text | 1 | coded: M or F |
| Paid | Boolean | – | yes/no |
Coding of data (e.g. M for male, F for female) saves storage space, speeds up data entry and makes validation easier – but codes can be hard to remember.
2Validation routines
Validation is checking by the computer that data entered is reasonable and sensible. It cannot check that data is correct.
| Validation routine | What it checks | Example |
|---|---|---|
| range check | data is between set limits | age 11 to 18 |
| character check | only allowed characters are used | a name has no digits |
| length check | data has the right number of characters | phone number of 11 digits; password of at least 8 |
| type check | data is the right data type | quantity must be a number |
| format check | data follows a set pattern | date as DD/MM/YYYY; code like AB123 |
| presence check | data has been entered | email address cannot be left blank |
| check digit | an extra digit calculated from the others is correct | ISBN, barcode |
3Input and output formats
- Data capture forms (paper or on screen) should have a clear title and instructions, labelled boxes of the right size, drop-down lists or radio buttons for choices, the format shown (e.g. DD/MM/YYYY), logical order, and clear buttons such as Save.
- Screen layouts show output on screen clearly: headings, sensible use of colour, not too much information.
- Report layouts show printed output: title, column headings, page numbers, date, totals.
4Exam focus
Key words: file structure; field name; data type; field length; coding; validation; data capture form; screen layout; report layout.
Quick self-check
Answer in your head first, then reveal.
Any three checks with suitable examples (6).
Any two: clear title/instructions; labelled boxes of the right size; drop-down lists/radio buttons; format shown (2).
Saves storage space / faster to enter / easier to validate (1).
