Design and development of a relational database functional foods

Abstract

Predstavljena je zasnova in izgradnja relacijske podatkovne baze za funkcionalna živila. To so živila, ki so del vsakodnevne prehrane in pozitivno vplivajo na zdravje ter zmanjšujejo tveganje za nastanek nekaterih bolezni. Relacijska podatkovna baza, zasnovana po Fienkelsteinovi metodi, vsebuje entitete, atribute in primarne ključe. Glavne entitete so: biološko aktivne snovi, klasifikacija, lastnosti, živila, fiziološki učinki, bolezni, postopki, zakonodaja, bibliografija in funkcionalna klasifikacija. Normalizirana baza, zgrajena v programu MS Access 2000, temelji na podatkovnemslovarju entitet, atributih, relacijah in entitetnem diagramu. Vsebuje podatke za 35 biološko aktivnih snovi, pridobljene iz 140 primarnih virov (članki, knjige ipd.). Klasifikacijsko drevo temelji na podlagi deskriptorjev iz tezavra FSTA, pridobljenih s pomočjo bibliometrične analize. Predstavljena je s šestimi med seboj povezanimi obrazci: Klasifikacija, Biološko aktivne snovi, Živilo, Bolezni, Zakonodaja, Bibliografija in Iskanje ter podaja odgovore na vprašanja: (1) kaj so funkcionalna živila, (2) katere aktivne snovi vsebujejo, (3) kako delimo biološko aktivne snovi (klasifikacija), (4) katere biološko aktivne snovi znižujejo tveganje za nastanek določenih bolezni, (5) kakšne so fizikalno kemijske lastnosti aktivnih snovi in (6) kakšna je zakonodaja na tem področju. Uporabniška aplikacija je dostopna kot CD-ROM in je namenjena širšemu krogu uporabnikov.We present design and construction of a relational database for functional foods which are defined as foods used in everyday diet, and having beneficial effects on health as well as reducing risks for diseases. Database was designed according to Fienkelstein. It contains entities, attributes, and primary keys. Main entities are represented by: biologically active compounds, classification, properties, foods, physiological effects, diseases, processes, legislation, bibliography, and functional classification. Database was normalised and was constructed with MS Access 2000. It is based on dictionary of entities, attributes, relations, and entity-relationship diagram. It contains data for 35 biologically active foods. Classification tree was set up on the basis of descriptors from FSTA thesaurus following a bibliometric analysis. The data were extracted from 140 documents (articles, books etc.). The database is represented with six inter-linked forms (sheets): Classification, Biologically active compounds, Foods, Diseases, Legislation, Bibliography and Retrieval (Search). It is possible to search according to the following queries: (1) what are functional foods, (2) which active compounds are contained in foods, (3) classification of compounds, (4) which are the risk-reducing compounds, (5) phzsico-chemical properties of compounds, and (6) legislation in the field of functional foods

    Similar works