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.

A randomized controlled trial assessing the health economics of realtime teledermatology compared with conventional care: an urban versus rural perspective

A randomized controlled trial was carried out to measure the cost-effectiveness of realtime teledermatology compared with conventional outpatient dermatology care for patients from urban and rural areas. One urban and one rural health centre were linked to a regional hospital in Northern Ireland by ISDN at 128 kbit/s. Over two years, 274 patients required a hospital outpatient dermatology referral -126 patients (46%) were randomized to a telemedicine consultation and 148 (54%) to a conventional hospital outpatient consultation. Of those seen by telemedicine, 61% were registered with an urban practice, compared with 71% of those seen conventionally. The clinical outcomes of the two types of consultation were similar - almost half the patients were managed after a single consultation with the dermatologist. The observed marginal cost per patient of the initial realtime teledermatology consultation was f52.85 for those in urban areas and f59.93 per patient for those from rural areas. The observed marginal cost of the initial conventional consultation was f47.13 for urban patients and f48.77 for rural patients. The total observed costs of teledermatology were higher than the costs of conventional care in both urban and rural areas, mainly because of the fixed equipment costs. Sensitivity analysis using a real-world scenario showed that in urban areas the average costs of the telemedicine and conventional consultations were about equal, while in rural areas the average cost of the telemedicine consultation was less than that of the conventional consultation.

Steepness and deepness in the Australian macroeconomy

This study uses nonparametric tests - the triples test and the BDS test, to examine whether key Australian macroeconomic aggregates exhibit nonlinearities and important 'steepness' and 'deepness' asymmetries at the business cycle frequency. Evidence is found of nonlinearities but there is little evidence of deepness in the Australian macroeconomy. However, there is evidence of steepness, especially concerning labour market variables, as well as both the CPI and M3. The evidence suggests that unemployment (employment) rises (falls) rapidly in recessions and only recovers slowly over time. Also, positive asymmetries in M3 are reflected in similar asymmetries in the CPI but not in output, consumption or investment.

The Anatomy of an International Cartel: Cyanide 1897-1927

The development of a new product or a new process, if adopted by the market, may generate a number of economic processes including secondary innovations to promote the exploitation of the new discovery. Such technological advances may also promote new industrial ventures which may exist over many decades, enhancing economic development. The history of the adoption of the cyanide process for the extraction of gold from its ores exemplifies such developments. One outcome was the formation of an international cyanide cartel.

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.

Auditor independence and fee dependence

This study investigates whether fee dependence within the audit firms' offices jeopardises auditor independence. Fee dependence is examined at both the national audit firm level as well as the local office level and in a setting where public disclosure of fees is mandatory. We focus our tests on audit fee dependence and at the same time we control for the effects of non-audit service fee dependence post the 1989 mergers. We operationalise the exercise of independent judgement in auditing by the propensity to issue qualified audit opinions. If fee dependence affects auditors' independent judgement, then auditors are less likely to qualify the accounts. The study's results show that the level of auditor fee dependence does not affect auditor propensity to issue unqualified audit opinions. The findings remain robust to a number of sensitivity tests including the analyses controlling for the effects of non-audit service fee dependence and other settings in which there is heightened pressure on auditors to confront the effects of fee dependence on exercising independent audit judgement. (C) 2002 Elsevier Science B.V. All rights reserved.

Age-related lifecycles - Purpose variations

By describing and discussing Australian data on outbound tourism, this paper investigates the bimodal (double peaked) lifecycle pattern predicted and observed in the literature. These theories are primarily based on demand for holiday tourism, but tourists do not just go overseas for this purpose, with visiting friends and relatives, business, convention and conference, employment and educational tourism relevant purposes also. Trips overseas by Australians are split into these groups, enabling the age-related lifecycles of each to be examined separately. Unlike holiday tourism, all other purposes are unimodal, although they vary with respect to the age groups at which they peak and their relative positions.