Database Design for a Small Company

Táto bakalárska práca popisuje návrh relačnej databázy pre malú spoločnosť zaoberajúcu sa predajom a autorizovaným servisom jemných elektronických zariadení. Databázové riešenie bude slúžiť k podpore a zvýšeniu efektivity procesov zameraných na servisné úkony a ich plánovanie v rámci firmy. Práca pozostáva z troch na seba nadväzujúcich častí. Prvá časť vymedzuje teoretické základy potrebné pre pochopenie problematiky dátového modelovania. Druhá časť práce sa zaoberá analýzou súčasného stavu firmy. Na základe výsledkov analýzy súčasného stavu firmy a jej interných procesov bude vytvorený dátový model, ktorého návrh je obsahom tretej časti tejto práce. Práca následne obsahuje zhodnotenie a očakávané prínosy riešenia pre firmu.This bachelor thesis describes the design of relational database for a small company engaged in sales and authorized repairs of sensitive electronic devices. Main target of the database solution will be the support and increase of process efficiency focused mainly on device maintenance and its planning within the company. Thesis is composed of three consecutive parts. First part defines theoretical foundations needed for understanding the issue of data modeling. The second part deals with the analysis of a current state of the company. Data model, design of which is the matter of third part of this thesis, will be built on the outcome of analysis of the company and its internal processes. Thesis then contains evaluation and expected benefits for the company.

Database Design for a Small Company

This bachelor thesis describes the design of relational database for a small company engaged in sales and authorized repairs of sensitive electronic devices. Main target of the database solution will be the support and increase of process efficiency focused mainly on device maintenance and its planning within the company. Thesis is composed of three consecutive parts. First part defines theoretical foundations needed for understanding the issue of data modeling. The second part deals with the analysis of a current state of the company. Data model, design of which is the matter of third part of this thesis, will be built on the outcome of analysis of the company and its internal processes. Thesis then contains evaluation and expected benefits for the company

Design of software for calculation of measurement deviations and uncertainties

This master thesis describes the design of software for a calibration laboratory of mass that will comply with current standards, guidelines, and laws for the field. The thesis describes the design of the database, the data management system and software architecture as well as the application of selected mathematical and statistical methods for the calculation of measurement deviations and uncertainties in instrument calibrations

Polyphenol Content, Mineral Compounds Composition, Antimicrobial and Antioxidant Activities of Selected Medicinal Herbs from Slovak Republic

The aim of this study was to determine antioxidant activity (DPPH and phosphomolybdenum method), polyphenols content (total polyphenols, flavonoids, and phenolic acids), mineral compounds composition (Cu, Zn, Mn, Fe, Cr, Ni, Co, Pb and Cd) and antimicrobial activity (with disc diffusion method) of medicinal herbs traditionally used in the Slovak republic. The tested plants belonged to the Primulaceae, Urticaceae, Grossulariaceae, Rosaceae, Lamiaceae, Asteraceae, Equisetaceae, Tropaeolaceae, and Plantaginaceae families. The highest antioxidant activities were found in samples of Rosa canina L. (DPPH—29.43 ± 0.11 mg TE/g; TE—Trolox equivalent) and Fragaria vesca L. (phosphomolybdenum method—679.56 ± 3.06 mg TE/g), both from the Rosaceae family. Total polyphenols (determined using the Folin–Ciocâlteu-reagent) were most abundant in a sample of Fragaria vesca L.—124.51 ± 5.05 mg GAE/g (GAE—gallic acid equivalent), total flavonoids (determined using the aluminum chloride method)—in a sample of Primula veris L.—48.35 ± 3.77 mg QE/g (QE—quercetin equivalent), and total phenolic acids (determined using Arnova reagent)—in a sample of Thymus serpyllum L.—102.31 ± 2.89 mg CAE/g (CAE—caffeic acid equivalent). Regarding mineral compounds composition, samples of Fragaria vesca L. and Thymus serpyllum L. showed the highest levels of iron. In samples of Calendula officinalis L. and Trapaeolum majus L., the highest amounts of zinc were determined, while copper was the most abundant in samples of Urtica dioica L. and Melissa officinalis L. The amounts of heavy metals were within legally acceptable limits. The extract of Equisetum arvense L. showed the strongest inhibitory activity towards Clostridium perfringens CCM 4991 (6 mm), while the one from Mentha piperita L.—towards Candida glabrata CCM 8270 (4.83 mm) and Candida tropicalis CCM 8223 (4.33 mm)

Polyphenol Content, Mineral Compounds Composition, Antimicrobial and Antioxidant Activities of Selected Medicinal Herbs from Slovak Republic

The aim of this study was to determine antioxidant activity (DPPH and phosphomolybdenum method), polyphenols content (total polyphenols, flavonoids, and phenolic acids), mineral compounds composition (Cu, Zn, Mn, Fe, Cr, Ni, Co, Pb and Cd) and antimicrobial activity (with disc diffusion method) of medicinal herbs traditionally used in the Slovak republic. The tested plants belonged to the Primulaceae, Urticaceae, Grossulariaceae, Rosaceae, Lamiaceae, Asteraceae, Equisetaceae, Tropaeolaceae, and Plantaginaceae families. The highest antioxidant activities were found in samples of Rosa canina L. (DPPH—29.43 ± 0.11 mg TE/g; TE—Trolox equivalent) and Fragaria vesca L. (phosphomolybdenum method—679.56 ± 3.06 mg TE/g), both from the Rosaceae family. Total polyphenols (determined using the Folin–Ciocâlteu-reagent) were most abundant in a sample of Fragaria vesca L.—124.51 ± 5.05 mg GAE/g (GAE—gallic acid equivalent), total flavonoids (determined using the aluminum chloride method)—in a sample of Primula veris L.—48.35 ± 3.77 mg QE/g (QE—quercetin equivalent), and total phenolic acids (determined using Arnova reagent)—in a sample of Thymus serpyllum L.—102.31 ± 2.89 mg CAE/g (CAE—caffeic acid equivalent). Regarding mineral compounds composition, samples of Fragaria vesca L. and Thymus serpyllum L. showed the highest levels of iron. In samples of Calendula officinalis L. and Trapaeolum majus L., the highest amounts of zinc were determined, while copper was the most abundant in samples of Urtica dioica L. and Melissa officinalis L. The amounts of heavy metals were within legally acceptable limits. The extract of Equisetum arvense L. showed the strongest inhibitory activity towards Clostridium perfringens CCM 4991 (6 mm), while the one from Mentha piperita L.—towards Candida glabrata CCM 8270 (4.83 mm) and Candida tropicalis CCM 8223 (4.33 mm)

Associations of optical coherence tomography with disability and brain MRI volumetry in patients with multiple sclerosis

Aim of the study. To investigate in a cross-sectional study the correlations of optical coherence tomography (OCT) with clinical and magnetic resonance imaging (MRI) parameters in multiple sclerosis (MS) patients.Material and methods. OCT parameters include the peripapillary retinal nerve fibre layer (pRNFL) and ganglion cell complex (GCC). Brain magnetic resonance volumetry (T2- and T1- lesions volume, whole brain volume and grey matter volume) was evaluated using the Icobrain program. Clinical data was compared according to the history of optic neuritis (HON). Correlations were determined between OCT parameters and demographic (age, gender), clinical (disease duration, Expanded Disability Status Scale score [EDSS]), and MRI data.Results. Out of 83 recruited people with MS, 27 had HON. The mean age of 75 patients with non-ON eyes was 42.08 ± 10.36 years, and 70.67% of the sample were females. Significant correlations were found between pRNFL and disability, along with several brain MRI-volumetry variables (Fluid-attenuated Inversion Recovery lesions volume [FLAIR]; T1-hypointense lesions volume; T1-lesions volume change; T1-volume lesions enlarging; whole brain volume; whole brain volume normative percentile; and volume of periventricular lesions). Multivariable linear regression analysis showed that age, pRNFL and GCC were significantly associated with T1-hypointense lesions volume change (the model explained 24% of the overall variance of the dependent variable).Conclusions. The pRFNL value correlates with disability and brain MRI-volumetric parameters in MS patients, serving as a useful neurodegeneration and inflammation surrogate marker

Bladder cancer therapy using a conformationally fluid tumoricidal peptide complex

Partially unfolded alpha-lactalbumin forms an oleic acid complex with antitumorigenic properties. Here, the authors define a structurally flexible, peptide-based oleate complex and report a phase I/II clinical trial where this complex is used to treat patients with bladder cancer