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.

Effect of gender on ownership and income in veterinary practice

Objective To estimate the effect of gender on ownership and income in veterinary practice in Australia. Methods Questionnaire completed by private veterinary practitioners, and analysed using the SAS System for Windows 7.0. Results More than three-quarters (78%) of male but 36% of female private practitioners were partial or sole owners of practices. The median annual income for all male practitioners working more than 40 hours/week was $70K, but that for females was $43K. These disparities existed in both city and country practices, and in the case of income it increased with increasing time in the workforce. Male practice owners also reported higher incomes than female owners. Conclusions Female veterinary practitioners are less likely to own practices, and more likely to earn low incomes than males. These differentials do not appear to be due to location, hours worked or years since graduation or, in the case of income, to whether they are owners or employees. The evidence points to a lower interest by women than men in the business aspects of veterinary practice.

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.

The nexus of value chain integration and e-business applications on public sector agriculture R&D management

We examine the potential impact of interconnectivity of value chain partnerships through electronic means (e-business practices) on the management of Public Sector Agriculture R&D in Australia. We review the changing forms of managing research and development, the forces driving these changes, and R&D processes that are theoretically consistent with the move towards value chain involvement and the increase in active constituents in Public Sector Agriculture R&D. We then explore the potential of emerging e-business models to change the patterns of inter-connectivity, speed and omnipresence of partners in the value chain. Three e-business R&D management practices are identified that provide the prerequisite flexibility necessary to take advantage of opportunistic markets. These R&D business practices are: compressing R&D to reduce time to market, fostering co-development to enter a market at the last moment and building flexible products that allow adjustment at the last possible moment. Some fundamental reallocation of existing resources will be required to meet these markets. Implications of these e-business practices for R&D management are discussed.