1 / 13

Database Evidence

Database Evidence. Lucy Woods. The Data Type is set as ‘Text’ as it can only be described through the use of letters and punctuation . FOOD ITEM. It is a required field , so it must be populated with data.

fala
Download Presentation

Database Evidence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Evidence Lucy Woods

  2. The Data Type is set as ‘Text’ as it can only be described through the use of letters and punctuation . FOOD ITEM It is a required field , so it must be populated with data. The Field size is decreased to 40, this is enough space for any food item and will reduce the overall database field size. No Duplicates have been selected, This will ensure that no two food items imported or entered into the database are the same.

  3. The data type is text. Codes are used to represent food items using letters GROUP 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.

  4. UNIT 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

  5. QUANTITY 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’.

  6. 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.

  7. FIBRE The data type is set to Number. The amount of Fibre in the table is limited to an integer. The field size is now ‘integer’ rather than ‘long integer’ to reduce file size. Number of decimal places has been changed to 0. It is a required field

  8. FAT The data type is set to Number. This is because a amount of Fat in a portion of food would be a numeric form. This field requires up to 1 decimal place. Input ‘1’ in the decimal place row.

  9. 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.

  10. Importing Data 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.

  11. 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.

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

  13. Finished Database

More Related