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.

The global sports-media nexus: Reflections on the 'Super League Saga' in Australia

Despite the social and (increasingly) commercial significance of sport and sporting bodies worldwide, they remain under-represented in the mainstream management literature. One of the more recent and dramatic examples of the global sports-media nexus is the 'Super League saga' in Australia. This paper recounts the tale of the Super League saga, providing a holistic analysis of the events and competitive issues arising by drawing on literatures concerning the economic nature and value of sports leagues, the resource-based view of the firm and the nature of psychological contracts in changing environments. The analysis confirms the general monopolistic tendencies of professional sports leagues in an increasingly global industry driven by the sports-media nexus, in accord with a number of comparable cases internationally. The particular conditions of the Australian marketplace that exacerbate this tendency beyond, for example, that found in the USA, and differences in the outcomes of battles between rival leagues are also considered. The Super League saga portrays the importance of effective management of resources key to the production of the 'rugby league product' including, among others, the often over-looked importance of careful management of local resources for the success of global strategies, and, where human resources are key, the importance of psychological contracting. The holistic analysis of the Super League saga in Australia affords lessons that extend well beyond the realm of sports.

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.