The effects of information request ambiguity and construct incongruence on query development

This paper examines the effects of information request ambiguity and construct incongruence on end user's ability to develop SQL queries with an interactive relational database query language. In this experiment, ambiguity in information requests adversely affected accuracy and efficiency. Incongruities among the information request, the query syntax, and the data representation adversely affected accuracy, efficiency, and confidence. The results for ambiguity suggest that organizations might elicit better query development if end users were sensitized to the nature of ambiguities that could arise in their business contexts. End users could translate natural language queries into pseudo-SQL that could be examined for precision before the queries were developed. The results for incongruence suggest that better query development might ensue if semantic distances could be reduced by giving users data representations and database views that maximize construct congruence for the kinds of queries in typical domains. (C) 2001 Elsevier Science B.V. All rights reserved.

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.

Deletion of 8p: a report of a child with normal intelligence

The case is presented of a female infant with a distal deletion of 8p (8p23.1 --> pter) whose development was monitored over a 5-year period from 12 months of age. Although previous literature has suggested that 8p deletion is associated with mild to moderate intellectual disability, the child reported here has normal intelligence. Despite initial delays in gross motor and language skills, cognitive development (assessed with the Bayley Scales of Infant Development) and intellectual ability (measured on the Stanford-Binet Intelligence Scale) were within average range. It is argued that the small number of previous case reports may have created a misleading impression of intellectual development in individuals with distal deletions of 8p.

Television and cultural studies: Unfinished business

This introductory article argues that the current state of debate on television within cultural studies is marked by considerable areas of theoretical and political uncertainty. The spread of deregulatory and privatizing public policies in relation to television, and the disarticulation of television from the idea of the national community and from the role of the citizen, have posed new problems for theorizing the relation between television and its audiences. In this article I survey a number of key areas of debate: the relation between television, the nation and the state; television and the citizen/consumer, television content and performance, and the likely future(s) of television.

Effect of fruit maturity on the response of 'Kensington' mango fruit to heat treatment

The effects of conditioning and hot water treatments on immature and mature 'Kensington' mangoes were examined. A hot water treatment of 47 degreesC fruit core temperature held for 15 min increased weight loss (50%), fruit softness (15%), disrupted starch hydrolysis and interacted with maturity to reduce the skin yellowness (40-51%) of early harvested fruit. Immature fruit were more susceptible to hot water treatment-induced skin scalding, starch layer and starch spot injuries and disease. Conditioning fruit at 40 degreesC for up to 16 h before hot water treatment accelerated fruit ripening, as reflected in higher total soluble solids and lower titratable acidity levels. As fruit maturity increased, the tolerance to hot water treatment-induced skin scalding and the retention of starch layers and starch spots increased and susceptibility to lenticel spotting decreased. A conditioning treatment of either 22 degrees or 40 degreesC before hot water treatment could prevent the appearance of cavities at all maturity levels. The 40 degreesC conditioning temperature was found to be more effective in increasing fruit heat tolerance than the 22 degreesC treatment; the longer the time of conditioning at 40 degreesC, the more effective the treatment (16 v. 4 h). For maximum fruit quality, particularly for export markets, it is recommended that mature fruit are selected and conditioned before hot water treatment to reduce the risk of heat damage.