An automatic correction tool for relational database schemas

A Web-based tool developed to automatically correct relational database schemas is presented. This tool has been integrated into a more general e-learning platform and is used to reinforce teaching and learning on database courses. This platform assigns to each student a set of database problems selected from a common repository. The student has to design a relational database schema and enter it into the system through a user friendly interface specifically designed for it. The correction tool corrects the design and shows detected errors. The student has the chance to correct them and send a new solution. These steps can be repeated as many times as required until a correct solution is obtained. Currently, this system is being used in different introductory database courses at the University of Girona with very promising results

Building wood debris piles benefits avian seed dispersers in burned and logged Mediterranean pine forests

Salvage logging is a common practice carried out in burned forests worldwide, and intended to mitigate the economic losses caused by wildfires. Logging implies an additional disturbance occurring shortly after fire, although its ecological effects can be somewhat mitigated by leaving wood debris on site. The composition of the bird community and its capacity to provide ecosystem services such as seed dispersal of fleshy-fruited plants have been shown to be affected by postfire logging. We assessed the effects of the habitat structure resulting from different postfire management practices on the bird community, in three burned pine forests in Catalonia (western Mediterranean). For this purpose, we focused on the group of species that is responsible for seed dispersal, a process which takes place primarily during the winter in the Mediterranean basin. In addition, we assessed microhabitat selection by seed disperser birds in such environments in relation to management practices. Our results showed a significant, positive relationship between the density of wood debris piles and the abundance of seed disperser birds. Furthermore, such piles were the preferred microhabitat of these species. This reveals an important effect of forest management on seed disperser birds, which is likely to affect the dynamics of bird-dependent seed dispersal. Thus, building wood debris piles can be a useful practice for the conservation of both the species and their ecosystem services, while also being compatible with timber harvesting

Can salvage logging affect seed dispersal by birds into burned forests?

The recovery of vegetation in Mediterranean ecosystems after wildfire is mostly a result of direct regeneration, since the same species existing before the fire regenerate on-site by seeding or resprouting. However, the possibility of plant colonization by dispersal of seeds from unburned areas remains poorly studied. We addressed the role of the frugivorous, bird-dependent seed dispersal (seed rain) of fleshy-fruited plants in a burned and managed forest in the second winter after a fire, before on-site fruit production had begun. We also assessed the effect on seed rain of different microhabitats resulting from salvage logging (erosion barriers, standing snags, open areas), as well as the microhabitats of unlogged patches and an unburned control forest, taking account of the importance of perches as seed rain sites. We found considerable seed rain by birds in the burned area. Seeds, mostly from Olive trees Olea europaea and Evergreen pistaches Pistacia lentiscus, belonged to plants fruiting only in surrounding unburned areas. Seed rain was heterogeneous, and depended on microhabitat, with the highest seed density in the unburned control forest but closely followed by the wood piles of erosion barriers. In contrast, very low densities were found under perches of standing snags. Furthermore, frugivorous bird richness seemed to be higher in the erosion barriers than elsewhere. Our results highlight the importance of this specific post-fire management in bird-dependent seed rain and also may suggest a consequent heterogeneous distribution of fleshy-fruited plants in burned and managed areas. However, there needs to be more study of the establishment success of dispersed seeds before an accurate assessment can be made of the role of bird-mediated seed dispersal in post-fire regeneration

The Syntactic Information in the 'Diccionario Crítico Etimológico Castellano e Hispánico' by J. Corominas and J.A. Pascual as Expressed in the Database 'Syntax.Dbf'

L'objectiu d'aquest article és presentar l'estructura de la base de dades relacional que inclou tota la informació sintictica continguda en el Diccionario Critico Etimológico Castellano e Hispánico de J. Corominas i J. A. Pascual. Tot i que aquest diccionari conté un ampli ventall d'informacions històriques de cadascun dels temes, aquestes no es mostren de forma estructurada, per la qual cosa ha estat necessari estudiar i classificar tots aquells elements relacionats amb aspectes sintàctics. És a partir d'aquest estudi previ que s'han elaborat els diferents camps de la base de dades, els quals s'agrupen en cinc blocs temàtics: informació lemàtica; gramatical; sintàctica; altres aspectes relacionats; i observacions o comentaris rellevants fets per l'investigador. Aquesta base de dades no només reprodueix els continguts del diccionari, sinó que inclou diferents camps interpretatius. Per aquesta raó, Syntax. dbf representa una eina de treball fonamental per a tots aquells investigadors interessats en la sintaxi diacrònica de l'espanyol