The un-structured student

SQL (Structured Query Language) is intended to liberate users from the complex syntax, complex semantics and complex memory management that would be required of a procedural approach to relational database manipulation, and so allow users to concentrate on problem-solving. However, students still have problems with language features, program concepts and the legacy of their prior learning. This paper aims to assist lecturers teaching SQL.We present typical student mistakes, attempt to explain why these mistakes arise, and propose possible remedies

Abundance of Belugas, Delphinapterus leucas, in Cook Inlet, Alaska, 1994–2000

Annual abundance estimates of belugas, Delphinapterus leucas, in Cook Inlet were calculated from counts made by aerial observers and aerial video recordings. Whale group-size estimates were corrected for subsurface whales (availability bias) and whales that were at the surface but were missed (detection bias). Logistic regression was used to estimate the probability that entire groups were missed during the systematic surveys, and the results were used to calculate a correction to account for the whales in these missed groups (1.015, CV = 0.03 in 1994–98; 1.021, CV = 0.01 in 1999– 2000). Calculated abundances were 653 (CV = 0.43) in 1994, 491 (CV = 0.44) in 1995, 594 (CV = 0.28) in 1996, 440 (CV = 0.14) in 1997, 347 (CV = 0.29) in 1998, 367 (CV = 0.14) in 1999, and 435 (CV = 0.23, 95% CI=279–679) in 2000. For management purposes the current Nbest = 435 and Nmin = 360. These estimates replace preliminary estimates of 749 for 1994 and 357 for 1999. Monte Carlo simulations indicate a 47% probability that from June 1994 to June 1998 abundance of the Cook Inlet stock of belugas was depleted by 50%. The decline appears to have stopped in 1998

Correction to the pathogenic alternative splicing, caused by the common GNB3 c.825C>T allele, using a novel, antisense morpholino

The very common GNB3 c.825C>T polymorphism (rs5443), is present in approximately half of all human chromosomes. Significantly the presence of the GNB3 825T allele has been strongly associated, with predisposition to essential hypertension. Paradoxically the presence of the GNB3 825T allele, in exon 10, introduces a pathogenic alternative RNA splice site into the middle of exon 9. To attempt to correct this pathogenic aberrant splicing, we therefore bioinformatically designed, using a Gene Tools® algorithm, a GNB3 specific, antisense morpholino. It was hoped that this morpholino would behave in vitro as either a potential “ splice blocker and/or exon skipper, to both bind and inhibit/reduce the aberrant splicing of the GNB3, 825T allele. On transfecting a human lymphoblast cell line homozygous for the 825T allele, with this antisense morpholino, we encouragingly observed both a significant reduction (from ~58% to ~5%) in the production of the aberrant smaller GNB3 transcript, and a subsequent increase in the normal GNB3 transcript (from ~42% to ~95%). Our results demonstrate the potential use of a GNB3 specific antisense morpholino, as a pharmacogenetic therapy for essential hypertension

Phototrophic Fe(II) Oxidation Promotes Organic Carbon Acquisition by Rhodobacter capsulatus SB1003

Anoxygenic phototrophic Fe(II) oxidation is usually considered to be a lithoautotrophic metabolism that contributes to primary production in Fe-based ecosystems. In this study, we employed Rhodobacter capsulatus SB1003 as a model organism to test the hypothesis that phototrophic Fe(II) oxidation can be coupled to organic carbon acquisition. R. capsulatus SB1003 oxidized Fe(II) under anoxic conditions in a light-dependent manner, but failed to grow lithoautotrophically on soluble Fe(II). When provided with Fe(II)-citrate, however, growth was observed that was dependent upon microbially catalyzed Fe(II) oxidation, resulting in the formation of Fe(III)-citrate. Subsequent photochemical breakdown of Fe(III)-citrate yielded acetoacetic acid, that supported growth in the light but not the dark. Deletion of genes (RR00247-RR00248) that encode homologs of atoA and atoD, required for acetoacetic acid utilization, severely impaired the ability of R. capsulatus SB1003 to grow on Fe(II)-citrate. The growth yield achieved by R. capsulatus SB1003 in the presence of citrate cannot be explained by lithoautotrophic growth on Fe(II) enabled by indirect effects of the ligand (such as altering the thermodynamics of Fe(II) oxidation or preventing cell encrustation). Together, these results demonstrate that R. capsulatus SB1003 grows photoheterotrophically on Fe(II)-citrate. Nitrilotriacetic acid (NTA) also supported light-dependent growth on Fe(II), suggesting that Fe(II) oxidation may be a general mechanism whereby some Fe(II)-oxidizing bacteria mine otherwise inaccessible organic carbon sources

Deep reef fish surveys by submersible on Alderdice, McGrail, and Sonnier Banks in the Northwestern Gulf of Mexico

Submersible surveys at numerous reefs and banks in the northwestern Gulf of Mexico (NWGOM) were conducted as part of the Sustainable Seas Expedition (SSE) during July/August 2002 to identify reef fish communities, characterize benthic habitats, and identify deep coral reef ecosystems. To identify the spatial extent of hard bottom reef communities, the Flower Garden Banks National Marine Sanctuary (FGBNMS) and the U.S. Geological Survey (USGS) mapped approximately 2000 km2 of the Northwestern Gulf of Mexico (NWGOM) continental shelf during June 2002 with high-resolution multibeam bathymetry. Previous investigations conducted on the features of interest (with the exceptions of East and West Flower Garden and Sonnier Banks, accessible by SCUBA) had not been conducted since the 1970s and 1980s, and did not have the use of high-resolution maps to target survey sites. The base maps were instrumental in navigating submersibles to specific features at each study site during the Sustainable Seas Expedition (SSE)—a submersible effort culminating from a partnership between the National Atmospheric and Oceanic Administration (NOAA) and the National Geographic Society (NGS). We report the initial findings of our submersible surveys, including habitat and reef fish diversity at McGrail, Alderdice, and Sonnier Banks. A total of 120 species and 40,724 individuals were identified from video surveys at the three banks. Planktivorous fishes constituted over 87% by number for the three banks, ranging from 81.4% at Sonnier Banks to 94.3% at Alderdice Bank, indicating a direct link to pelagic prey communities, particularly in the deep reef zones. High numbers of groupers, snappers, jacks, and other fishery species were observed on all three features. These sites were nominated as Habitat Areas of Particular Concern (HAPC) by the Gulf of Mexico Fishery Council in March 2004. Data obtained during this project will contribute to benthic habitat characterization and assessment of the associated fish communities through future SCUBA, ROV, and submersible missions, and allow comparisons to other deep reef ecosystems found throughout the Gulf of Mexico and western Atlantic Ocean

Growth of Intermediate-Mass Black Holes in Globular Clusters

We present results of numerical simulations of sequences of binary-single scattering events of black holes in dense stellar environments. The simulations cover a wide range of mass ratios from equal mass objects to 1000:10:10 solar masses and compare purely Newtonian simulations to simulations in which Newtonian encounters are interspersed with gravitational wave emission from the binary. In both cases, the sequence is terminated when the binary's merger time due to gravitational radiation is less than the arrival time of the next interloper. We find that black hole binaries typically merge with a very high eccentricity (0.93 < e < 0.95 pure Newtonian; 0.85 < e < 0.90 with gravitational wave emission) and that adding gravitational wave emission decreases the time to harden a binary until merger by ~ 30% to 40%. We discuss the implications of this work for the formation of intermediate-mass black holes and gravitational wave detection.Comment: 28 pages including 9 figures, submitted to Ap

Exploring taboo issues in professional sport through a fictional approach

While the need to consider life course issues in elite sport research and practice is increasingly recognised, some experiences still seem to be considered too dangerous to explore. Consequently, stories of these experiences are silenced and the ethical and moral questions they pose fail to be acknowledged, understood or debated. This paper presents an ethnographic fiction through which we explore a sensitive set of experiences that were uncovered during our research with professional sportspeople. Through a multi‐layered reconstruction, the story reveals the complex, but significant, relationships that exist between identity, cultural narratives and embodied experiences. After the telling we consider how the story has stimulated reflective practice among students, researchers and practitioners. While there are risks involved in writing and sharing taboo stories, the feedback we have received suggests that storytelling can be an effective pedagogical tool in education and professional development

Microwave ISM Emission Observed by WMAP

We investigate the nature of the diffuse Galactic emission in the Wilkinson Microwave Anisotropy Probe (WMAP) temperature anisotropy data. Substantial dust-correlated emission is observed at all WMAP frequencies, far exceeding the expected thermal dust emission in the lowest frequency channels (23, 33, 41 GHz). The WMAP team (Bennett et al.) interpret this emission as dust-correlated synchrotron radiation, attributing the correlation to the natural association of relativistic electrons produced by SNae with massive star formation in dusty clouds, and deriving an upper limit of 5% on the contribution of Draine & Lazarian spinning dust at K-band (23 GHz). We pursue an alternative interpretation that much, perhaps most, of the dust-correlated emission at these frequencies is indeed spinning dust, and explore the spectral dependence on environment by considering a few specific objects as well as the full sky average. Models similar to Draine & Lazarian spinning dust provide a good fit to the full-sky data. The full-sky fit also requires a significant component with free-free spectrum uncorrelated with \Halpha, possibly hot (~million K) gas within 30 degrees of the Galactic center.Comment: ApJ in press (accepted 5 Dec 2003), version 2: corrected typos and added references. 23 pages, 5 figures, 2 tables. Free-free haze map is available at http://skymaps.inf