The effects of normalisation on the ability of business end-users to detect data anomalies: An experimental evaluation

With the proliferation of relational database programs for PC's and other platforms, many business end-users are creating, maintaining, and querying their own databases. More importantly, business end-users use the output of these queries as the basis for operational, tactical, and strategic decisions. Inaccurate data reduce the expected quality of these decisions. Implementing various input validation controls, including higher levels of normalisation, can reduce the number of data anomalies entering the databases. Even in well-maintained databases, however, data anomalies will still accumulate. To improve the quality of data, databases can be queried periodically to locate and correct anomalies. This paper reports the results of two experiments that investigated the effects of different data structures on business end-users' abilities to detect data anomalies in a relational database. The results demonstrate that both unnormalised and higher levels of normalisation lower the effectiveness and efficiency of queries relative to the first normal form. First normal form databases appear to provide the most effective and efficient data structure for business end-users formulating queries to detect data anomalies.

The validity of self-reported energy intake as determined using the doubly labelled water technique

In the 1980s the development of the doubly labelled water (DLW) technique made it possible to determine the validity of dietary assessment methods using external, independent markers of intake in free-living populations. Since then, the accuracy of self-reported energy intake (EI) has been questioned on a number of occasions as under-reporting has been found to be prevalent in many different populations. This paper is a review of investigations using the DLW technique in conjunction with self-reported EI measures in groups including adults, children and adolescents, obese persons, athletes, military personnel and trekking explorers. In studies where a person other than the subject is responsible for recording dietary intake, such as parents of young children, EI generally corresponds to DLW determined energy expenditure. However, in instances where the subjects themselves report their intake, EI is generally under-reported when compared with energy expenditure. It was originally believed that this phenomenon of under-reporting was linked to increased adiposity and body size, however, it is now apparent that other factors, such as dietary restraint and socio-economic status, are also involved. This paper therefore aims to present a more comprehensive picture of under-reporting by tying in the findings of many DLW studies with other studies focusing particularly on the characteristics and mechanisms for under-reporting. Awareness of these characteristics and mechanisms will enable researchers to obtain more accurate self-reports of EI using all dietary recording techniques.

Development of the pulmonary surfactant system in the green sea turtle, Chelonia mydas

This study describes the developmental changes in pulmonary surfactant (PS) lipids throughout incubation in the sea turtle, Chelonia mydas. Total phospholipid (PL), disaturated phospholipid (DSP) and cholesterol (Chol) harvested from lung washings increased with advancing incubation, where secretion was maximal at pipping, coincident with the onset of pulmonary ventilation. The DSP/PL ratio increased, whereas the Chol/PL and the Chol/DSP ratio declined throughout development. The phospholipids, therefore, are independently regulated from Chol and their development matches that of mammals. To explore whether hypoxia could elicit an effect on the development of the PS system, embryos were exposed to a chronic dose of 17% O-2 for the final similar to 40% of incubation. Hypoxia did not affect incubation time, absolute, nor relative abundance of the surfactant lipids, demonstrating that the development of the system is robust and that embryonic development continues unabated under mild hypoxia. Hypoxia-incubated hatchlings had lighter wet lung weights than those from normoxia, inferring that mild hypoxia facilitates lung clearance in this species. (C) 2001 Elsevier Science B.V. All rights reserved.