the database will consist of around 1200 packaged convenience food items. The core data will be drawn from Asda and Tesco product lists. This first level hierarchy [product classification system] is based on the ASDA tiers. 
 

 

LEVEL

[code range]

 

DATABASE HIERARCHY

 

 

EXAMPLES / COMMENTS

 1.        [0-9]

data base manager

Foodcounts [Consensus Software]

 2.        [0-9]

data source

Asda, Tesco, Heinz etc

 3.        [0-9]

food type

all foods with labels

 4.      [0-99]

food category

store aisles  e.g. frozen food

 5.      [0-99]

food set

store-sections e.g. frozen meat

 6.      [0-99]

food class

store-shelves e.g. burgers

 7.    [0-999]

brand

e.g. Kellogs, Asda etc

 8.     [ 0-99]

Product and size

= product barcode

 

PRODUCT LABEL INFO 

 9.  [0-9999]

Ingredients list on pack

Maps to FDA free database

10.   [grams]

Size of pack

Maps to all sizes of same product

11.     [0-99]

Packaging

Coded list of all packaging types

12.        days

Storage-from purchase

Maps to level 4

13.      hours

Storage-from opening pack

Assumes refrigeration

14.     [0-99]

Freezing instructions

Coded list of methods

15.     [0-99]

Defrosting instructions

Coded list of methods

16.     [mins]

Defrosting period

17.     [0-99]

Serving instructions

Coded list of methods

18.   [grams]

Serving portions

19.     [0-99]

Hob cooking instructions

Coded list of methods

20.     [mins]

Hob cooking period

21.     [0-99]

Oven cooking instructions

Coded list of methods +oven types

22.     [mins]

Oven cooking period

23.   [centg.]

Oven cooking temperatures

23a. Fahrenheit?

24.     [0-99]

Microwave instructions

Coded list of methods and types

25.     [mins]

Microwave period

26      [mins]

Microwave split period

Split time / maps to 25

27.

NUTRITION INFO

Connect to separate data base?

28.

MANUFACTURERS INO

Info panels

29

CONSUMER COMMENTS

Via email?

30-99

Add-in levels?