Database Structure

Creating the database structure

1. Create relevant FIELDS with appropriate data types, sizes and vaidation rules

Data types are important to help maintain the integrity of the data, however if we were collecting a telephone number we would store this as a string as we have no need to perform a calculation. If we need to understand a persons age it is best to store their date of birth then calcluate their age. Imagine if we only recorded their age and then never revisited the database for a coouple of years! Our data would be inacccurate as the age of the person would have remained the same in our database.

2. Nominate the Key Field.

3. Save the FIELDS as a TABLE

4. Enter DATA into the database using a form

This example database FILE contains just one table and is known as a flatfile. There are a number of limitations to such databases, where as Relational Databases contain multiple linked tables and offer many advantages over flat file databases.