Database Evidence

Lucy Woods

FOOD ITEM

The Field size is decreased to 40, this is enough space for any food item and will reduce the overall database field size.

It is a required field , so it must be populated with data.

No Duplicates have been selected, This will ensure that no two food items imported or entered into the database are the same.

The Data Type is set as ‘Text’ as it can only be described through the use of letters and punctuation .

The data type is text. Codes are used to represent food items using letters

The Field size is decreased to 2. Only 2 letters can be used.

The validation rule limits the data that can be imported to specific codes.

The validation text is the warning that appears if information is entered other than the specific food codes.

GROUP

The data type is text. The way to describe units will be by texts, eg. Tablespoons, slices.

The field size is reduced to 20.

It is a required field. It must be populated

UNIT

The Data type is ‘Number’. The quantity needs to be represented as a integer.

The field size is now ‘integer’ rather than ‘long integer’ to reduce file size.

As an integer has no decimal places you will enter ‘0’.

QUANTITY

CARBS The data type Number. This is because the number of calories in a portion of food will be in numerical form.

As this field requires up to 1 decimal place . Enter ‘1’ where it says ‘Decimals places’.

It is a required field.

FIBRE

The field size is now ‘integer’ rather than ‘long integer’ to reduce file size.

It is a required field

Number of decimal places has been changed to 0.

The data type is set to Number. The amount of Fibre in the table is limited to an integer.

FAT

This field requires up to 1 decimal place. Input ‘1’ in the decimal place row.

The data type is set to Number. This is because a amount of Fat in a portion of food would be a numeric form.

CALORIES

The data type is set to Number. This is because the number of calories in a portion of food would be a integer numeric amount.

The field size is changed to integer. Using this as apposed to long integer will reduce file sizes

It is a required field.

Now all the field names and data types have been filled in you can import the data.Click on the text file and browse for the text file needed. Import the data.

Importing Data

Testing the Validation Rule

• Whilst trying to enter a value that did was not acceptable for that specific field this warning notice appeared showing that my validation rule works.

Adding New Records

I carried out research on particular foods to include in my database and imported them under the correct headings.

Finished Database