Context
Task 1
Task 2
Task 3
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
|
Resource
Sheet 7
Database Design
When you create your data capture sheet it is important that you
think carefully about the data that you need for your database.
You will have to store the
following information as a minimum:
| Field Name |
Field Type |
Example |
Options |
| Title |
text |
Mr |
Mr, Mrs, Ms, Miss |
| Forename |
text |
Fred |
|
| Surname |
text |
Flintstone |
|
| Address Name |
text |
Mr F Flintstone |
|
| Address 1 |
text |
35 Bedrock Lane |
|
| Address 2 |
Lookup file |
Bedrock |
List of local towns |
| Address
3 |
Lookup
file |
Nottinghamshire |
Nottinghamshire,
Derbyshire |
| Postcode |
text |
BD13 7YH |
|
| Sex |
Lookup file |
Male |
Male/Female |
| DOB |
Date |
13/04/0000 |
Choose type of date (e.g.
short) |
| Relationship |
Lookup file |
Phillip’s friend |
Phillip’s friend,
Gemma’s friend, relative, etc. |
| Birthday Card? |
Yes/no |
Yes |
|
| Party Invite? |
Yes/no |
No |
|
You may wish to add other fields that you feel the family would
want to your own database.
Task 5
Home
|