Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Base de dades realitzada en Oracle per controlar i ajustar les ofertes de de treball que es reben de les empreses i les demandes de feina i currículums que presenten els treballadors. Tot l'accés a les dades es realitza mitjançant procediments emmagatzemats.

Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Una empresa de selecció de personal vol incorporar un sistema per controlar i ajustar les ofertes de feina que rep de les empreses i les demandes de feina i currículums que presenten els treballadors.

La valoració del coneixement de la llengua pròpia i del dret propi de Catalunya en la provisió de places del personal al servei de l’administració de justícia

La recerca proposa l’estudi del contingut i abast de les principals disposicions normatives que ordenen la valoració del coneixement de la llengua i el dret propis de Catalunya en la provisió de les places judicials. L’anàlisi de la tramitació parlamentària de les disposicions ha permès posar en context decisions del legislador, oferint instruments d’hermenèutica útils per resoldre debats interpretatius que avui es plantegen en seu doctrinal. La recerca inclou l’estudi dels efectes d’aquests textos normatius, en tant que permeten mesurar-ne la seva eficàcia i s’han de tenir en compte en el debat de les reformes que, eventualment, puguin desplegar-se. Des de la perspectiva d’anàlisi de les polítiques públiques, la recerca descriu les principals mesures formulades i implementades per les diferents Administracions Públiques, i molt especialment per la Generalitat de Catalunya, amb l’objectiu de corregir disfuncions que presenta aquest marc legal i reglamentari. La recerca ha posat en evidència que el règim jurídic que ordena l’aptitud lingüística i el coneixement del dret propi de Catalunya per part del personal judicial es caracteritza per la seva complexitat i falta de coherència. La valoració del coneixement de la llengua i el dret propis de la Comunitat Autònoma s’ha regulat molt tardament. Com a regla general, es valora com un mèrit en la provisió de la plaça, sotmès a més a intenses controvèrsies pel que fa a la determinació dels barems de puntuació concedits. En certs casos, com és el cos de Fiscals substituts, la valoració de la llengua i el dret propis de la Comunitat Autònoma ni tan sols es valora com un mèrit. Simplement no es té en compte. Pel que fa referència als secretaris judicials, la darrera reforma de la L.O. 6/1985 d’1 de juliol, del Poder Judicial, aprovada per L.O. 19/2003 de 23 de desembre, ha introduït el requisit de la capacitació lingüística per cobrir determinades places, per bé que el criteri general és el de la meritació puntuable. Altrament, en el cas del personal judicial depenent de la Generalitat s’ha garantit el requisit d’aptitud lingüística. D’aquesta manera, s’ha optat per assegurar un coneixement adequat i suficient de les dues llengües oficials, tant en l’expressió oral com en l’escrita, per a desenvolupar eficaçment les funcions pròpies del seu lloc de treball.

Integració i gestió dels marcatges laborals del personal d'empresa al sistema SAP R/3

L'objectiu d'aquest projecte és realitzar l'estudi i el disseny per a la corresponent implantació d'un sistema de control dels marcatges per fer el traspàs i poder-los gestionar amb SAP R/3 en un grup d'empreses.

Hierarchic species-area relationships and the management of forest habitat islands in intensive farmland

Habitat loss and fragmentation due to land use changes are major threats to biodiversity in forest ecosystems, and they are expected to have important impacts on many taxa and at various spatial scales. Species richness and area relationships (SARs) have been used to assess species diversity patterns and drivers, and thereby in the establishment of conservation and management strategies. Here we propose a hierarchical approach to achieve deeper insights on SARs in small forest islets in intensive farmland and to address the impacts of decreasing naturalness on such relationships. In the intensive dairy landscapes of Northwest Portugal, where small forest stands (dominated by pines, eucalypts or both) represent semi-natural habitat islands, 50 small forest stands were selected and surveyed for vascular plant diversity. A hierarchical analytical framework was devised to determine species richness and inter- and intra-patch SARs for the whole set of forest patches (general patterns) and for each type of forest (specific patterns). Differences in SARs for distinct groups were also tested by considering subsets of species (native, alien, woody, and herbaceous). Overall, values for species richness were confirmed to be different between forest patches exhibiting different levels of naturalness. Whereas higher values of plant diversity were found in pine stands, higher values for alien species were observed in eucalypt stands. Total area of forest (inter-patch SAR) was found not to have a significant impact on species richness for any of the targeted groups of species. However, significant intra-patch SARs were obtained for all groups of species and forest types. A hierarchical approach was successfully applied to scrutinise SARs along a gradient of forest naturalness in intensively managed landscapes. Dominant canopy tree and management intensity were found to reflect differently on distinct species groups as well as to compensate for increasing stand area, buffering SARs among patches, but not within patches. Thus, the maintenance of small semi-natural patches dominated by pines, under extensive practices of forest management, will promote native plant diversity while at the same time contributing to limit the expansion of problematic alien invasive species.

Conocimiento de la ley y preparación del personal sanitario sobre el proceso asistencial de la muerte.

The aims of this study were to ascertain the perception that health professionals (doctors, nurses and nursing assistants) have about their preparation for the care of terminally ill patients and to determine their knowledge about palliative care legislation. This cross sectional study was performed at a hospital in Granada (Spain); we administered an ad hoc questionnaire. The results indicated that although most of the staff had worked with terminally ill patients, only half believed that they have been trained to care for them. A significant proportion stated that they did not know about the current palliative care legislation. Most professionals would question the withdrawal of therapies for the maintenance of life; most of them are also unaware of the mechanism for reporting on the completion of a Living Will, as well as a Plan for Palliative Care in Andalusia (Spain).

Adaptación y validación al español del cuestionario 4CornerSAT para la medida de la satisfacción profesional del personal médico de atención especializada.

BACKGROUND Satisfaction of physicians is a concern in the healthcare sector, and it requires a multi-dimensional questionnaire in Spanish which studies their high-order needs. The objectives of this study are to adapt the 4CornerSAT Questionnaire to measure career satisfaction of physicians and to evaluate its validity in our context. METHOD The 4CornerSAT Questionnaire was adapted into Spanish, validating it among physicians of hospitals in Andalusia, Spain. A confirmatory factor analysis (CFA) was performed to corroborate the a priori model, and it was evaluated the internal consistency and the construct validity through the Cronbach's alpha and the correlation between the scale and the global item, respectively. RESULTS The adapted questionnaire was administrated to 121 specialist physicians. The CFA corroborated the four dimensions of the questionnaire (χ2=114.64, df=94, p<0.07; χ2/df=1.22; RMSEA=0.04). The internal consistency obtained an α=0.92 and the correlation between the summed scale and the global item verified the construct validity (r=0.77; p<0.001). CONCLUSIONS The 4CornerSAT questionnaire was adapted to Spanish, identifying an adequate construct validity and internal consistency.

Recurrent mutations in the CDKL5 gene: Genotype-phenotype relationships.

Mutations in the cyclin-dependent kinase-like 5 gene (CDKL5) have been described in epileptic encephalopathies in females with infantile spasms with features that overlap with Rett syndrome. With more than 80 reported patients, the phenotype of CDKL5-related encephalopathy is well-defined. The main features consist of seizures starting before 6 months of age, severe intellectual disability with absent speech and hand stereotypies and deceleration of head growth, which resembles Rett syndrome. However, some clinical discrepancies suggested the influence of genetics and/or environmental factors. No genotype-phenotype correlation has been defined and thus there is a need to examine individual mutations. In this study, we analyzed eight recurrent CDKL5 mutations to test whether the clinical phenotype of patients with the same mutation is similar and whether patients with specific CDKL5 mutations have a milder phenotype than those with other CDKL5 mutations. Patients bearing missense mutations in the ATP binding site such as the p.Ala40Val mutation typically walked unaided, had normocephaly, better hand use ability, and less frequent refractory epilepsy when compared to girls with other CDKL5 mutations. In contrast, patients with mutations in the kinase domain (such as p.Arg59X, p.Arg134X, p.Arg178Trp/Pro/Gln, or c.145 + 2T > C) and frameshift mutations in the C-terminal region (such as c.2635_2636delCT) had a more severe phenotype with infantile spasms, refractory epileptic encephalopathy, absolute microcephaly, and inability to walk. It is important for clinicians to have this information when such patients are diagnosed. © 2012 Wiley Periodicals, Inc.

New stakeholders, spaces and instruments of analysis in the context of energy relationships: Case studies from Kazakhstan and Turkmenistan

The disintegration of the USSR brought the emergence of a new geo-energy space in Central Asia. This space arose in the context of a global energy transition, which began in the late 1970s. Therefore, this new space in a changing energy world requires both new conceptual frameworks of analysis and the creation of new analytical tools. Taking into account this fact, our paper attempts to apply the theoretical framework of the Global Commodity Chain (GCC) to the case of natural resources in Central Asia. The aim of the paper is to check if there could be any Central Asia’s geo-energy space, assuming that this space would exist if natural resources were managed with regional criteria. The paper is divided into four sections. First an introduction that describes the new global energy context within natural resources of Central Asia would be integrated. Secondly, the paper justifies why the GCC methodology is suitable for the study of the value chains of energy products. Thirdly, we build up three cases studies (oil and uranium from Kazakhstan and gas from Turkmenistan) which reveal a high degree of uncertainty over the direction these chains will take. Finally, we present the conclusions of this study that state that the most plausible scenario would be the integration of energy resources of these countries in GCC where the core of the decision-making process will be far away from the region of Central Asia. Key words: Energy transition, geo-energy space, Global Commodity Chains, Central Asia

Prediction of sustained antihypertensive efficacy of chronic captopril therapy: relationships to immediate blood pressure response and control plasma renin activity

The blood pressure (BP) lowering effect of the orally active angiotensin converting enzyme inhibitor, captopril (SQ14225), was studied in 59 hypertensive patients maintained on a constant sodium intake. Within 2 hours of the first dose of captopril BP fell from 171/107 to a maximum low of 142/92 mm Hg (p less than 0.001), and after 4 to 8 days to treatment BP averaged 145/94 mm Hg (p less than 0.001). The magnitude of BP drop induced by captopril was significantly correlated to baseline plasma renin activity (PRA) both during the acute phase (r = -0.38, p less than 0.01) and after the 4 to 8-day interval (r = -0.33, p less than 0.01). Because of considerable scatter in individual data, renin profiling was not precisely predictive of the immediate or delayed BP response of separate patients. However, the BP levels achieved following the initial dose of captopril were closely correlated to BP measured after 4 to 8 days of therapy, and appeared to have greater predictive value than control PRA of the long-term efficacy of chronic captopril therapy despite marked BP changes occurring in some patients during the intermediate period. Because of these intermediate BP changes, addition of a diuretic to enhance antihypertensive effectiveness of angiotensin blockade should be restrained for several days after initiation of captopril therapy.

Evolution of Trypanosoma cruzi: clarifying hybridisations, mitochondrial introgressions and phylogenetic relationships between major lineages

Several different models of Trypanosoma cruzi evolution have been proposed. These models suggest that scarce events of genetic exchange occurred during the evolutionary history of this parasite. In addition, the debate has focused on the existence of one or two hybridisation events during the evolution of T. cruzi lineages. Here, we reviewed the literature and analysed available sequence data to clarify the phylogenetic relationships among these different lineages. We observed that TcI, TcIII and TcIV form a monophyletic group and that TcIII and TcIV are not, as previously suggested, TcI-TcII hybrids. Particularly, TcI and TcIII are sister groups that diverged around the same time that a widely distributed TcIV split into two clades (TcIVS and TcIVN). In addition, we collected evidence that TcIII received TcIVSkDNA by introgression on several occasions. Different demographic hypotheses (surfing and asymmetrical introgression) may explain the origin and expansion of the TcIII group. Considering these hypotheses, genetic exchange should have been relatively frequent between TcIII and TcIVS in the geographic area in which their distributions overlapped. In addition, our results support the hypothesis that two independent hybridisation events gave rise to TcV and TcVI. Consequently, TcIVS kDNA was first transferred to TcIII and later to TcV and TcVI in TcII/TcIII hybridisation events.

State-Society Relationships, Social Trust and the Development of Labour Market Policies in Italy and Sweden

The first decade of the twenty-first century may be remembered for the rebirth of consensus on labour market policy. After three decades of bitter political and ideological controversy between a neo-liberal and a traditional social democratic approach, a new model, often labelled flexicurity, has emerged. This model is promoted by numerous political organisations since it promises to put an end to the old trade-off between equality and efficiency. Several countries are embracing the flexicurity model as a blueprint for labour market reform, but others, mostly belonging to the 'Mediterranean Rim', are clearly lagging behind. Why is it so difficult for these countries to implement the flexicurity model? This paper argues that the application of a flexicurity strategy in these countries is complicated by the lack of social trust between social partners and the state as well as political economy traditions that highlight the role of labour market regulation as a source of social protection.

Apport de la psychanalyse en oncogénétique prédictive

La médecine prédictive évalue la probabilité que des personnes portant des mutations génétiques constitutionnelles puissent développer une maladie donnée, comme par exemple une tumeur maligne (oncogénétique). Dans le cas des prédispositions génétiques au cancer, des mesures particulières de surveillance et de prévention sont discutées en fonction de l'évaluation des risques et des résultats de l'analyse génétique, y compris certains traitements préventifs allant, à l'extrême, jusqu'à l'intervention chirurgicale prophylactique (ex : mastectomie et/ou ovariectomie). Cette étude est basée sur une interprétation psychanalytique du récit de sujets ayant entrepris une démarche en oncogénétique et vise à analyser l'impact psychique : a) du résultat de l'analyse génétique et b) de la construction de l'arbre généalogique. Elle a été conduite dans l'Unité d'oncogénétique et de prévention des cancers (UOPC) du Service d'oncologie des Hôpitaux Universitaires de Genève (HUG). L'UOPC assure des consultations de conseil génétique spécialisé pour les personnes ayant des antécédents personnels et/ou familiaux de maladies tumorales suggestifs de l'existence de prédispositions génétiques au cancer. La population de cette étude comprend 125 sujets suivis lors des différentes étapes du dépistage, pour un total de 289 consultations et 50 entretiens individuels. Cette recherche montre que les sujets asymptomatiques réélaborent de façon personnelle, soit le résultat génétique (négatif ou positif), soit l'acte de prédiction. En revanche, ceux qui ont développé un cancer expriment des sentiments d'angoisse, comme s'ils subissaient les effets d'un destin inéluctable qui s'est effectivement réalisé. Par ailleurs, l'arbre généalogique est réinterprété de façon personnelle, laissant apparaître des aspects refoulés ou niés qui peuvent resurgir. Lorsque d'autres membres de la famille sont sollicités pour préciser les liens génétiques et/ou être soumis en première intention à l'analyse génétique, le sujet exprime sa difficulté de dépendre d'autres personnes pour connaître son propre statut biologique. D'une façon générale, on constate que là où la médecine prédictive réalise son acte de prévision, le sujet répond de façon imprévisible. Dans l'optique de la psychanalyse, cette imprévisibilité est liée aux aspects du « désir inconscient ». Cette étude montre aussi qu'on ne peut pas considérer le dépistage génétique comme étant la cause directe du traumatisme. L'effort doit porter sur le fait que le sujet puisse se réapproprier ce qui lui arrive, et exprimer progressivement sa souffrance spécifique en jeu dans le processus de prédiction pour créer un écart entre la vérité médicale et la sienne. L'espace de la parole devient ainsi le lieu d'un travail privilégié. La psychanalyse opère donc pour que le résultat génétique se détache de l'acte de prédiction, c'est-à-dire qu'il redevienne un moment de la vie du sujet qui puisse s'articuler comme sa propre histoire personnelle. The aim of predictive medicine is to assess the probability that individuals carrying germ-line mutations will develop certain diseases, for instance cancer (oncogenetics). In predictive oncology, particular surveillance and prevention measures are discussed with these patients in relation to risk assessment and results of genetic testing, including preventive care which can, in extremes cases, lead to prophylactic surgery (i.e. mastectomy and/or ovariectomy). This study is based on a psychoanalytic interpretation of subjects' narration of the oncogenetic process and aims at analyzing the psychological impact of a) genetic testing and b) the construction of the family tree. It was carried out at the Oncogenetics and cancer prevention unit (Unité d'oncogénétique et de prévention des cancers) from the Geneva University Hospitals (Hôpitaux Universitaires de Genève, HUG) which organizes genetic counselling for individuals having personal and/or family history suggestive of genetic predisposition to cancer. The study population comprises 125 patients followed during the successive steps of genetic counselling, for a total of 289 consultations and 50 personal interviews. This research shows that asymptomatic subjects re-elaborate in a personal way either the results of genetic testing (negative or positive) or the act of prediction. Conversely, those having developed cancer express feelings of anguish, as if they were undergoing the effects of a destiny which effectively happened. Its sight remains a difficult step of the oncogenetic process, as psychological aspects which were repressed or denied can re-appear. When some family members are solicited to help reconstructing the genetic relationships, sometimes being themselves submitted first to genetic testing, the study subject expresses the difficulty to depend on other persons to learn more about his own biological status. In this study, we observe that, in parallel to predictions delivered by the process of predictive medicine, the subject actually answers unpredictably. With a psychoanalytic perspective, this unpredictability is related to an "unconscious desire". We also find that we cannot consider that genetic screening is a direct cause of psychological trauma. Our efforts must rely on allowing the subject to re-appropriate himself what is happening, to let him progressively express his own suffering of the prediction in order to create a gap between the medical reality and his own. In this process, "speech" is needed to let this happening. Psychoanalysis works in such a way that the genetic testing's result becomes distinct from the act of prediction, a moment of the subject's life expressed as his own personal history.