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.

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.

A simple rule of thumb for elegant prehension

Reaching out to grasp an object (prehension) is a deceptively elegant and skilled behavior. The movement prior to object contact can be described as having two components [1], the movement of the hand to an appropriate location for gripping the object, the transport component, and the opening and closing of the aperture between the fingers as they prepare to grip the target, the grasp component. The grasp component is sensitive to the size of the object, so that a larger grasp aperture is formed for wider objects [1]; the maximum grasp aperture (MGA) is a little wider than the width of the target object and occurs later in the movement for larger objects [1, 2]. We present a simple model that can account for the temporal relationship between the transport and grasp components, We report the results of an experiment providing empirical support for our rule of thumb. The model provides a simple, but plausible, account of a neural control strategy that has been the center of debate over the last two decades.

Reliability factors in business software: volatility, requirements and end-users

Many business-oriented software applications are subject to frequent changes in requirements. This paper shows that, ceteris paribus, increases in the volatility of system requirements decrease the reliability of software. Further, systems that exhibit high volatility during the development phase are likely to have lower reliability during their operational phase. In addition to the typically higher volatility of requirements, end-users who specify the requirements of business-oriented systems are usually less technically oriented than people who specify the requirements of compilers, radar tracking systems or medical equipment. Hence, the characteristics of software reliability problems for business-oriented systems are likely to differ significantly from those of more technically oriented systems.