Mapping Relational Algebra Operators into SQL Queries: A Database Case Study

Relational algebra operators and mapping to resulting structured query language (SQL) queries are among the most important concepts and skills for students taking a course in database design and implementation, especially those majoring in IS/IT. The most typical relational algebra operators mapped to foundational SQL include unions and intersections, as well as other relational operators applied to these operators, including differences and various joins. Unfortunately, few textbooks or external resources provide ample opportunity for students to apply the full set of most common relational algebra operators mapped to resulting SQL over a single unified case. Most database textbooks exemplify each separate relational algebra construct to a single, sparse (although visually-stimulating) example, wherein the full set of operators is not near fully exemplified. This paper presents an overview of a case example that exemplifies and maps a more complete set of relational algebra operators in related SQL operations across a unified case. The case replicates the author’s real experience in building a database solution for an online retailer of sporting goods products. It is hoped that this case example will help database teachers more effectively teach relational algebra concepts, the subsequent mapping to SQL, and resulting queries, as well as provide students a greater understanding of relational algebra and mapping to SQL. Although the case example is exemplified in Microsoft Access 2010/2013, the case can be modified and presented using any relational database management system (RDBMS)

Access flight hardware design and development

Several items were found to be of immense value in the design and development of the Assembly Concept for Construction of Erectable Space Structures (ACCESS) hardware. The early availability of mock-up and engineering test hardware helped to develop the concept and prove the feasibility of the experiment. The extensive neutral buoyancy testing was invaluable in developing the procedures and timelines, proving that the hardware functioned as intended, and effectively trained the astronauts. The early involvement of the crew systems/astronaut personnel was extremely beneficial in shaping the design to meet the EVA compatibility requirements. Also, the early definition of coupled loads and on-orbit dynamic responses can not be overemphasized due to the relative uncertainty in the magnitude of these loads and their impact on the design

Canaryseed (Phalaris canariensis L.) accessions from nineteen countries show useful genetic variation for agronomic traits

Fifty-seven accessions of canaryseed (47 populations and 10 cultivars) from 19 countries were evaluated for agronomic traits in four field trials sown over 3 yr in the province of Buenos Aires, Argentina. Genetic variation was found for all traits scored: grain yield and its components (grain weight, grain number per square meter, grain number per head and head number per square meter), harvest index, percent lodging, and phenological characters (emergence to heading, emergence to harvest maturity and heading to harvest maturity). Although genotype×environment interaction was observed for all traits, the additive differences between accessions were sufficient to enable promising breeding materials to be identified. Accessions superior in performance to the local Argentinean population, which in general gave values close to the overall mean of the accessions evaluated, were identified. For example, a population of Moroccan origin gave good yield associated with elevated values of the highly heritable character grain weight, rather than with the more commonly observed grain number per square meter. This population was also of relatively short stature and resistant to lodging, and, although it performed best when sown within the normal sowing date, tolerated late sowing fairly well. Other accessions were also observed with high grain weight, a useful characteristic in itself, since large grains are desirable from a quality point of view. Regarding phenology, the accessions showed a range of 160 degree days (8 calendar days in our conditions) in maturity, which, while not large in magnitude, may be of some utility in crop rotation management. Some accessions were well adapted to late sowing. Grain yield in general was strongly correlated with grain number per square meter. Principal components analysis (PCA) carried out for all characteristics provided indications of accessions combining useful characteristics and identified three components that explained approximately 70% of the phenotypic variation. Furthermore, a second PCA plus regression showed that approximately 60% of the variation in grain yield could be explained by a component associated with harvest index and grain number per square meter. Pointers were provided to possible future breeding targets

Staphylococcus aureus Colonization: Modulation of Host Immune Response and Impact on Human Vaccine Design

In apparent contrast to its invasive potential Staphylococcus aureus colonizes the anterior nares of 20–80% of the human population. The relationship between host and microbe appears particularly individualized and colonization status seems somehow predetermined. After decolonization, persistent carriers often become re-colonized with their prior S. aureus strain, whereas non-carriers resist experimental colonization. Efforts to identify factors facilitating colonization have thus far largely focused on the microorganism rather than on the human host. The host responds to S. aureus nasal colonization via local expression of anti-microbial peptides, lipids, and cytokines. Interplay with the co-existing microbiota also influences colonization and immune regulation. Transient or persistent S. aureus colonization induces specific systemic immune responses. Humoral responses are the most studied of these and little is known of cellular responses induced by colonization. Intriguingly, colonized patients who develop bacteremia may have a lower S. aureus-attributable mortality than their non-colonized counterparts. This could imply a staphylococcal-specific immune “priming” or immunomodulation occurring as a consequence of colonization and impacting on the outcome of infection. This has yet to be fully explored. An effective vaccine remains elusive. Anti-S. aureus vaccine strategies may need to drive both humoral and cellular immune responses to confer efficient protection. Understanding the influence of colonization on adaptive response is essential to intelligent vaccine design, and may determine the efficacy of vaccine-mediated immunity. Clinical trials should consider colonization status and the resulting impact of this on individual patient responses. We urgently need an increased appreciation of colonization and its modulation of host immunity

General Public Space Travel and Tourism

Travel and tourism is one of the world's largest businesses. Its gross revenues exceed $400 billion per year in the U.S. alone, and it is our second largest employer. U.S. private sector business revenues in the space information area now approximate$10 billion per year, and are increasing rapidly. Not so in the human spaceflight area. After spending $100s of billions (1998 dollars) in public funds thereon, and continuing to spend over$5 billion per year, the government is still the only customer for human spaceflight goods and services. Serious and detailed consideration was first given to the possibility of space being opened up to trips by the general public three decades ago, and some initial attempts to do so were made a dozen years ago. But the difficulties were great and the Challenger disaster put an end to them. In recent years professional space tourism studies have been conducted in the United Kingdom, Germany and, especially, Japan. In the U.S., technological progress has been pronounced; we have had nearly a decade's experience in seeing our astronauts travel to-from low Earth orbit (LEO) safely, and we expect to commence assembly of a LEO space station housing a half-dozen people this year. Too, NASA and our space industry now have new and promising space transportation development programs underway, especially the X-33 and X-34 programs, and some related, further generation, basic technology development programs. And five private companies are also working on the design of new surface - LEO vehicles. The first professional space tourism market studies have been conducted in several countries in the past few years, especially in Japan and here. The U.S. study makes it clear that, conceptually, tens of millions of us would like to take a trip to space if we could do so with reasonable safety, comfort and reliability, and at an acceptable price. Initial businesses will address the desires of those willing to pay a greater price and accept a greater risk. A two-year cooperative Space Act agreement study has been conducted by our National Aeronautics and Space Administration and the Space Transportation Association. It was conducted by NASA and STA study leaders drawing upon the competence, experience and hard-nosed imagination of a national Steering Group and scores of attendees at a multi-day Workshop. The study has involved scores of professionals and business people from various areas: astronauts; space booster technology and operations professionals; a hotel architect and a hotel operator; an airline planner; insurance underwriters; space sickness experts; space theme park designers; space and travel and tourism association and business executives; a space-related financier; university tourism and space policy experts; present and former space-responsible government officials; space entrepreneurs; space writers; This study concludes that serious national attention should now be given to activities that would enable the expansion of today's terrestrial space tourism businesses, and the creation of in-space travel and tourism businesses. Indeed, it concludes that, in time, it should become a very important part of our Country's overall commercial and civil space business-program structure

Biogeochemical processes at hydrothermal vents : microbes and minerals, bioenergetics, and carbon fluxes

Author Posting. © The Oceanography Society, 2012. This article is posted here by permission of The Oceanography Society for personal use, not for redistribution. The definitive version was published in Oceanography 25, no. 1 (2012): 196–208, doi:10.5670/oceanog.2012.18.Hydrothermal vents are among the most biologically active regions of the deep ocean. However, our understanding of the limits of life in this extreme environment, the extent of biogeochemical transformation that occurs in the crust and overlying ocean, and the impact of vent life on regional and global ocean chemistry is in its infancy. Recently, scientific studies have expanded our view of how vent microbes gain metabolic energy at vents through their use of dissolved chemicals and minerals contained in ocean basalts, seafloor sulfide deposits, and hydrothermal plumes and, in turn, how they catalyze chemical and mineral transformations. The scale of vent environments and the difficulties inherent in the study of life above, on, and below the deep seafloor have led to the development of geochemical and bioenergetic models. These models predict habitability and biological activity based on the chemical composition of hydrothermal fluids, seawater, and the surrounding rock, balanced by the physiological energy demand of cells. This modeling, coupled with field sampling for ground truth and discovery, has led to a better understanding of how hydrothermal vents affect the ocean and global geochemical cycles, and how they influence our views of life on the early Earth and the search for life beyond our own planet.Research for this paper was supported by the National Science Foundation (NSF) Division of Ocean Sciences grants 0732611 for JFH, 0926805 and 1038055 for JAB, and 1038055 for BMT; and by the University of Missouri Research Board for KLR

Pharmacological characterization of the αvβ6 integrin binding and internalization kinetics of the foot-and-mouth disease virus derived peptide A20FMDV2

A20FMDV2 is a peptide derived from the foot-and-mouth disease virus with a high affinity and selectivity for the alphav beta-6 (αvβ6) arginyl-glycinyl-aspartic acid (RGD)-binding integrin. It has been shown to be an informative tool ligand in pre-clinical imaging studies for selective labelling of the αvβ6 integrin in a number of disease models. In a radioligand- binding assay using a radiolabelled form of the peptide ([3H]A20FMDV2), its high affinity (KD:0.22nmol/l) and selectivity (at least 85-fold) for αvβ6 over the other members of the RGD integrin family was confirmed. [3H]A20FMDV2 αvβ6 binding could be fully reversed only in the presence of EDTA, whereas a partial reversal was observed in the presence of excess concentrations of an RGD-mimetic small molecule (SC-68448) or unlabelled A20FMDV2. Using flow cytometry on bronchial epithelial cells, the ligand-induced internalization of αvβ6 by A20FMDV2 and LAP1 was shown to be fast (t1/2:1.5and 3.1 min, respectively), concentration-dependent (EC50:values 1.1 and 3.6nmol/l, respectively) and was followed by a moderately slow return of integrin to the surface. The results of the radioligand-binding studies suggest that the binding of A20FMDV2 to the RGD-binding site on αvβ6 is required to maintain its engagement with the hypothesised A20FMDV2 synergy site on the integrin. In addition, there is evidence from flow cytometric studies that the RGD-ligand engagement of αvβ6 post-internalization plays a role in delaying recycling of the integrin to the cell surface. This mechanism may act as a homeostatic control of membrane αvβ6 following RGD ligand engagement

Conceptual learning : the priority for higher education

The common sense notion of learning as the all-pervasive acquisition of new behaviour and knowledge, made vivid by experience, is an incomplete characterisation, because it assumes that the learning of behaviour and the learning of knowledge are indistinguishable, and that acquisition constitutes learning without reference to transfer. A psychological level of analysis is used to argue that conceptual learning should have priority in higher education