SQLator: An online SQL learning workbench

SQL (Structured Query Language) is one of the essential topics in foundation databases courses in higher education. Due to its apparent simple syntax, learning to use the full power of SQL can be a very difficult activity. In this paper, we introduce SQLator, which is a web-based interactive tool for learning SQL. SQLator's key function is the evaluate function, which allows a user to evaluate the correctness of his/her query formulation. The evaluate engine is based on complex heuristic algorithms. The tool also provides instructors the facility to create and populate database schemas with an associated pool of SQL queries. Currently it hosts two databases with a query pool of 300+ across the two databases. The pool is divided into 3 categories according to query complexity. The SQLator user can perform unlimited executions and evaluations on query formulations and/or view the solutions. The SQLator evaluate function has a high rate of success in evaluating the user's statement as correct (or incorrect) corresponding to the question. We will present in this paper, the basic architecture and functions of SQLator. We will further discuss the value of SQLator as an educational technology and report on educational outcomes based on studies conducted at the School of Information Technology and Electrical Engineering, The University of Queensland.

Restriction of intramuscular neurite branching and extension is lost in agrin and rapsyn-deficient mice

The phrenic nerve enters the diaphragm at approximately embryonic day 12.5 (E12.5) in the mouse. The secondary nerve trunk advances along the centre of the diaphragm muscle and extends tertiary branches primarily towards the lateral side during normal embryonic development. In the present study we quantified the intramuscular neurite branching in the most ventral region of the diaphragm at E15.5 and E18.5 in wild-type mice, agrin knock-out mice (KOAG) and rapsyn knock-out mice (KORAP). KOAG and KORAP have decreased muscle contraction due to their inability to maintain/form acetylcholine receptor (AChR) clusters during embryonic development. Heterozygote mothers were anaesthetised via an overdose of Nembutal (30 mg; Boeringer Ingelheim, Ridgefield, CT, USA) and killed via cervical dislocation. There were increases in the number of branches exiting the medial side of the phrenic nerve trunk in KOAG and KORAP compared to wild-type mice, but not on the lateral side at E15.5 and E18.5. However, the number of bifurcations in the periphery significantly increased on both the medial and lateral sides of the diaphragm at E15.5 and E18.5 in KOAG and KORAP compared to control mice. Furthermore, neurites extended further on both the medial and lateral sides of the diaphragm at E15.5 and E18.5 in KOAG and KORAP compared to wild-type mice. Together these results show that the restriction of neurite extension and bifurcations from the secondary nerve trunk is lost in both KOAG and KORAP allowing us the opportunity to investigate the factors that restrict motoneuron behaviour in mammalian muscles.