Disseny i implementació d'una base de dades relacional per a la gestió d'apostes de futbol

Memòria del projecte final de carrera on es desenvolupen la planificació de les tasques, la definició i anàlisi dels requeriments, l'enumeració dels casos d'ús, el disseny de la base de dades operacional i de data warehouse, implementació dels esquemes, realització de proves unitàries i procedimentació i tasques d'extracció, transformació i càrrega. L'usuari s'haurà de validar usant la funció login i per poder accedir a la informació haurà d'usar els paquets de la base de dades sense poder accedir directament a les dades de les taules.

Historia, patrimonio y territorio: políticas públicas de memoria en el frente del Segre y la frontera pirenaica catalana

La relación entre historia, patrimonio y territorio, en unos espacios culturales de clara relevancia durante la Guerra Civil y la Segunda Guerra Mundial, permite reflexionar sobre algunas políticas públicas de memoria desarrolladas a raíz de la confluencia que se ha dado entre el Programa Memorial Democràtic impulsado por la Generalitat de Catalunya, la acción decidida de algunos ayuntamientos comprometidos en preservar la memoria histórica, el mundo académico representado por la Universidad y el asociacionismo civil.

The Francoist repression in the Catalan Countries

This article offers an overview of Francoist repression in the Catalan Countries from the outbreak of the Civil War to the first decade after the establishment of the dictatorship. It covers both physical violence and measures such as economic repression, imprisonment, professional purges and the social and moral control to which the population as a whole was subjected. First the type of violence and domination exercised by the insurgents in the territories occupied is briefly examined. Then the author offers an account of the events: she commences in the summer of 1936 in Majorca, the only Catalan-speaking territory to remain in rebel hands, then proceeds to the Lleida region, which was occupied in the spring of 1938, and concludes with the final offensive against Catalonia and Valencia, launched in the winter of that same year. Special stress is laid on the repercussions of the 1939 Law of Political Responsibilities and the meaning attached by the occupiers to the pacification and reconstruction of the conquered territories.

Response of wheat to additional nitrogen fertilizer application after pig slurry on over-fertilized soils

Pig slurry is a valuable nutrient resource but constitutes a waste disposal problem in areas of high animal density. In the semiarid area of Pla d’Urgell, in the Ebro Valley, North-East Spain, irrigated crops receive large amounts of nutrients in the form of manure and mineral fertilizers. We studied the effect of pig slurry and additional side-dress mineral fertilizers on irrigated wheat, Triticum aestivum L., on a coarse loam soil, with high soil P and K levels. Yields increased by 62.3% when using pig slurry. The application of ammonium sulfate nitrate sidedress did not significantly increase wheat production. The average apparent recoveries were higher for potassium (88.7%) than for nitrogen (51.3%) and phosphorus (36.3%). Greater amounts of soil NO3-N were measured over the four growing seasons, which was consistent with the amount of N applied. Macronutrient and micronutrient uptake was significant higher for pig slurry treatments, but only small differences were found between the pig slurry and pig slurry plus ammonium sulfate nitrate treatments. The unfertilized treatment showed significantly lower soil P, K, Cu and Zn content than pig slurry treatments; 34%, 21%, 34%, and 26% respectively. These findings could be used to develop a nutrient management plan based on knowledge of soil test results and crop nutrient removal. This could help to improve the use of pig slurry and mineral fertilizers on limited available land areas and prevent the accumulation of potentially toxic elements in soils and the export of nutrients through agricultural drainage.

Use of a pre-sidedress soil nitrate test (PSNT) to determine nitrogen fertilizer requirements for irrigated corn

In the present study, a 2-year N rate response experiment was conducted in different fields to monitor NO3-N soil profiles, N accumulation by the crop and final crop performance, in order to assess if soil NO3-N at pre-sidedressing (Pre-Sidedress Soil Nitrate Test, PSNT) is a reliable indicator for soil N availability for corn in the irrigated area served by canal d’Urgell (Lleida, Spain), and if the test can be used to separate responsive fields from non-responsive fields to sidedress N fertilizer applications. Preliminary soil N availability (N sidedress fertilizer rate + PSNT) critical levels to identify fields that need supplementary N fertilizer applications were established at ca. 300 and 210 kg NO3-N·ha–1, for PSNTrooting–zone and PSNT0–30 cm, respectively (for a yield goal of 14 t grain·ha–1).

Effects of DMPP on the growth and chemical composition of ryegrass (Lolium perenne L.) raised on calcareous soil

Se llevó a cabo un experimento de 406 días en macetas para evaluar el nuevo inhibidor de la nitrificación, 3,4-dimetilpirazol fosfato (DMPP), añadido a purines de cerdo. Se utilizaron macetas que contenían tierra franca calcárea que fueron sujetas a los siguientes tratamientos: sin purín, 73,7; 147,3 y 221 cm3 de purín por maceta, todas con o sin tratamiento de DMPP. A los 18 días las macetas fueron sembradas con Lolium perenne L. El mayor rendimiento (36,3 g maceta-1) se obtuvo para el tratamiento con la dosis superior de purín y DMPP, siendo un 7,4% superior al mismo tratamiento sin inhibidor y un 46,1% superior al tratamiento control. Las plantas tratadas con dosis alta y mediana, más el DMPP, absorbieron el 70% del total del N durante la primera fase del experimento (104 días) mientras que sin inhibidor absorbieron el 55,3 y el 62% respectivamente. Se observó una reducción significativa del 17% en el N lixiviado en los tratamientos sin cultivo al aplicar DMPP. El inhibidor aumentó significativamente la eficiencia agronómica del purín (g materia seca g-1 N aplicado).

Use of nitrification inhibitor DMPP to improve nitrogen recovery in irrigated wheat on a calcareous soil

The 3,4-dimethyilpyirazole phosphate (DMPP), commercialized as Entec, is a nitrification inhibitor developed by BASF (Germany) that may help to minimize N losses and to obtain a higher profit from N fertilizers. A two-year field trial was established in 2001 in the Northeast of Spain to assess the effects of DMPP on N use efficiency (NUE) and to determine the economic returns. Seven treatments have been carried out comparing the effect of DMPP on pig slurry and on mineral fertilizers. The application of DMPP resulted in better efficiency indexes on mineral fertilizers. An apparent nitrogen recovery of 0.465 kg kg-1, on average, was obtained for the Entec treatment. A net benefit of € 809 ha-1, on average, was obtained for the Entec treatment compared with € 607 ha-1 for the control treatment. The results of this study suggest that the nitrification inhibitor could improve farmer profit in irrigated wheat on a calcareous soil.

Influencia de la variabilidad del suelo en la agricultura de precisión

El objetivo principal de la cartografía de suelos es la caracterización de las propiedades del suelo y la estimación de su representación territorial. La memoria y el mapa de suelos constituyen el resultado final de la prospección de suelos, que puede ir acompañada de una evaluación de las unidades de suelos definidas, considerando diversas alternativas de uso.