Disseny i implementació d'un sistema de control de projectes

L'àmbit d'aquest treball de final de carrera és el camp del disseny de les bases de dades relacionals, per la qual cosa aquest treball s'ha enfocat des de diversos punts de vista: a) Acadèmic. Es descriurà la teoria del disseny de bases de dades relacionals. b) Pràctic. Es posarà en pràctica tot el model teòric desenvolupant un cas concret (producte) que s'anirà intercalant amb el desenvolupament teòric del punt anterior. c) Tecnològic. El desplegament del producte es farà a l'SGBD Oracle 9i (s'hi porta a terme una introducció), on s'implementarà tota la interfície a la BD amb la tecnologia PL/SQL d'Oracle.

Environnement et capacités cognitives chez le rat : compétition entre les facteurs qui influencent les stratégies spatiales

RESUME Ce travail se propose de discuter des résultats comportementaux observés chez des rats obtenus dans trois paradigmes expérimentaux différents : le bassin de Morris (Morris Water Maze, Morris, 1984) ; la table à trous (Homing Board, Schenk, 1989) et le labyrinthe radial (Radial Arm Maze, Olton et Samuelson, 1976). Les deux premières tâches sont spatiales et permettent un apprentissage de place en environnements contrôlés, et la troisième est une tâche comportementale qui différencie deux habiletés particulières, celle d'élimination (basée sur la mémoire de travail) et celle de sélection (basée sur la mémoire de référence). La discussion des résultats porte sur les stratégies de navigation utilisées par les animaux pour résoudre les tâches et plus précisément sur les facteurs qui peuvent influencer le choix de ces stratégies. Le facteur environnemental (environnement contrôlé) et le facteur cognitif (vieillissement) représentent les variables étudiées ici. C'est ainsi que certaines hypothèses communément acceptées ont été malmenées par nos résultats. Or si l'espace est habituellement supposé homogène (toutes les positions spatiales présentent le même degré de difficulté lors d'un apprentissage en champ ouvert), ce travail établit qu'une position associée -sans contiguïté - à l'un des trois indices visuels situés dans la périphérie de l'environnement est plus difficile à apprendre qu'une position située entre deux des trois indices. Deuxièmement, alors qu'il est admis que l'apprentissage d'une place dans un environnement riche requiert le même type d'information. dans la bassin de Morris (tâche nagée) que sur la table à trous (tâche marchée), nous avons montré que la discrimination spatiale en bassin ne peut être assurée par les trois indices visuels périphériques et nécessite la présence d'au moins un élément supplémentaire. Enfin, l'étude du vieillissement a souvent montré que l'âge réduit les capacités cognitives nécessaires à la navigation spatiale, conduisant à un déficit général des performances d'un animal sénescent, alors que dans notre travail, nous avons trouvé les animaux âgés plus performants et plus efficaces que les adultes dans une tâche particulière de collecte de nourriture. Ces expériences s'inscrivent dans une étude générale qui met à l'épreuve le modèle théorique proposé pax Schenk et Jacobs (2003), selon lequel l'encodage de la carte cognitive (Tolman, 1948 ; O'Keefe et Nadel, 1978) se ferait dans l'hippocampe par l'activité de deux modules complémentaires :d'une part le CA3 - Gyrus Denté pour le traitement d'une trame spatiale basée sur des éléments directionnels et Jou distribués en gradient (bearing map) et d'autre part le CAl - Subiculum pour le traitement des représentations locales basées sur les positions relatives des éléments fixes de l'environnement (sketch map). SUMMARY This work proposes to talk about behavioural results observed in three different experimental paradigms with rats: the Morris Water Maze (Morris, 1984); the Homing Board (Schenk, 1989) and the Radial Arm Maze (Olton and Samuelson, 1976). The two first tasks are spatial ones and allow place learning in controlled environments. The third one is a behavioural task which contrasts two particular skills, the elimination (based on working memory) and the selection one (based on reference memory). The topic of the discussion will be the navigation strategies used by animals to solve the different tasks, and more precisely the factors which can bias this strategies' choice. The environmental (controlled) and the cognitive (aging) factors are the variables studied here. Thus, some hypotheses usually accepted were manhandled by our results. Indeed, if space is habitually homogenously considered (all spatial positions present the same degree of difficulty in an open field learning), this work establishes that an associated position -without being adjacent - to one of the three visual cues localised in the environmental periphery is more difficult to learn than a configurationnel position (situated between two of the three cues). Secondly, if it is received that place learning in a rich environment requires the same information in the Morris water maze (swimming task) that on the Homing board (walking task), we showed that spatial discrimination in the water maze can't be provided by the three peripheral cue cards and needs the presence of a supplementary cue. At last, aging studies often showed that oldness decreases cognitive skills in spatial navigation, leading to a general deficit in performances. But, in our work, we found that senescent rats were more efficient than adult ones in a special food collecting task. These experiments come within the scope of a general study which tests the theoretical model proposed by Jacobs and Schenk (2003), according to which the cognitive map's encoding (Tolman, 1948, O'Keefe and Nadel, 1978) should take place in the hippocampus by two complementary modules, first the DG-CA3 should encode directional and/or gradients references (the bearing map), and secondly the Subiculum-CAl should process locale elements (the sketch map).

Calidad de vida relacionada con la salud y consumo de tabaco

La calidad de vida relacionada con la salud se ha descrito como un concepto multidimensional que incluye la identificación de síntomas, el estado funcional, la percepción de bienestar psicológico y la percepción general de salud. En el caso de la adicción al consumo de tabaco, la preocupación por la salud actual o futura es uno de los motivos más informados para dejar de fumar. En el presente estudio se analiza la relación entre la percepción de la calidad de vida relacionada con la salud y la etapa de cambio en el abandono del consumo de tabaco propuesta desde el modelo transteórico a fin de mejorar las estrategias de intervención comunitaria y clínica para la cesación tabáquica. Se ha administrado el cuestionario SF-36 a una muestra formada por 201 fumadores y exfumadores. Los datos obtenidos indican peor salud física percibida en las etapas de cambio más próximas al abandono de tabaco y una peor salud mental percibida en las etapas con tabaquismo activo. Se comparan los resultados con los observados en otras poblaciones y se discuten las implicaciones a nivel de tratamiento y prevención del tabaquismo

Extended family structure in the ant Formica paralugubris: the role of the breeding system

In populations of various ant species, many queens reproduce in the same nest (polygyny), and colony boundaries appear to be absent with individuals able to move fi eely between nests (unicoloniality). Such societies depart strongly from a simple family structure and pose a potential challenge to kin selection theory, because high queen number coupled with unrestricted gene flow among nests should result in levels of relatedness among nestmates close to zero. This study investigated the breeding system and genetic structure of a highly polygynous and largely unicolonial population of the wood ant Formica paralugubris. A microsatellite analysis revealed that nestmate workers, reproductive queens and reproductive males (the queens' mates) are all equally related to each other, with relatedness estimates centring around 0.14. This suggests that most of the queens and males reproducing in the study population had mated within or close to their natal nest, and that the queens did not disperse far after mating. We developed a theoretical model to investigate how the breeding system affects the relatedness structure of polygynous colonies. By combining the model and our empirical data, it was estimated that about 99.8% of the reproducing queens and males originated from within the nest, or from a nearby nest. This high rate of local mating and the rarity of long-distance dispersal maintain significant relatedness among nestmates, and contrast with the common view that unicoloniality is coupled with unrestricted gene flow among nests.

Dominant PRPF31 Mutations Are Hypostatic to a Recessive CNOT3 Polymorphism in Retinitis Pigmentosa: A Novel Phenomenon of "Linked Trans-Acting Epistasis".

Mutations in PRPF31 are responsible for autosomal dominant retinitis pigmentosa (adRP, RP11 form) and affected families show nonpenetrance. Differential expression of the wildtype PRPF31 allele is responsible for this phenomenon: coinheritance of a mutation and a higher expressing wildtype allele provide protection against development of disease. It has been suggested that a major modulating factor lies in close proximity to the wildtype PRPF31 gene on Chromosome 19, implying that a cis-acting factor directly alters PRPF31 expression. Variable expression of CNOT3 is one determinant of PRPF31 expression. This study explored the relationship between CNOT3 (a trans-acting factor) and its paradoxical cis-acting nature in relation to RP11. Linkage analysis on Chromosome 19 was performed in mutation-carrying families, and the inheritance of the wildtype PRPF31 allele in symptomatic-asymptomatic sibships was assessed-confirming that differential inheritance of wildtype chromosome 19q13 determines the clinical phenotype (P < 2.6 × 10(-7) ). A theoretical model was constructed that explains the apparent conflict between the linkage data and the recent demonstration that a trans-acting factor (CNOT3) is a major nonpenetrance factor: we propose that this apparently cis-acting effect arises due to the intimate linkage of CNOT3 and PRPF31 on Chromosome 19q13-a novel mechanism that we have termed "linked trans-acting epistasis."

Perceptions of unfairness in price increases: an experimental study

This experimental study investigates antecedents and consequences of perceptions of price unfairness in a price increase situation. The proposed theoretical model states that consumer dependence on the service provider as well as the relevance the consumer attributes to the service (for the consumer's life) will affect his/her degree of (a) unfairness price perception, (b) anger, and (c) intention to complain and retaliate. The results support all the hypotheses specified in the model. The findings not only indicate that some situations of unfairness price perception lead to stronger emotions and more dramatic reactions from consumers, but also allow us to predict which situations of perceived unfairness offer greater risks and have greater potential for conflict.

Portraying innovation in the public service of Brazil: Frameworks, systematization and characterization

ABSTRACT Innovation is essential for improving organizational performance in both the private and public sectors. This article describes and analyzes the 323 innovation experiences of the Brazilian federal public service that received prizes during the 16 annual competitions (from 1995 to 2012) of the Award for Innovation in Federal Public Management held by the Brazilian National School of Public Administration (ENAP). It is a qualitative and quantitative study in which were employed as categories for analysis the four types of innovation defined in the Copenhagen Manual: product, process, organizational and communication. The survey results allow us to affirm that there is innovation in the public sector, in spite of the skepticism of some researchers and the incipient state of theoretical research on the subject. It was possible to observe that organizational innovation was the one with the highest number of award- -winning experience, followed respectively by process, communication and product innovation, with citizen services and improvement of work processes being the main highlights. The results showed that, although the high incidence of innovation occurs at the national level, a significant number of innovations also occur at the local level, probably because many organizations of the federal government have their actions spread only at this level of government. Concerning the innovative area, health and education predominate, with almost 33% of initiatives, which can be explained by capillarity of these areas and the fact that both maintain a strong interaction with the user. The contributions of this work include the use of theoretical model of innovation analysis in the public sector in Brazil still upcoming, and the systematization of knowledge in empirical basis for this innovation. In this sense, it also contributes to the development of the theory with the presentation of evidence that the characteristics, determinants and consequences of innovation in the public sector differ not only from innovation in the industry, but also from innovation in services in the private sector.

Motivating Employees of the Public Sector: Does Public Service Motivation Matter?

This article analyzes if, and to what extent, the public service motivation (PSM) construct has an added value to explain work motivation in the public sector. In order to address the specificity of PSM when studying work motivation, the theoretical model underlying this empirical study compares PSM with two other explanatory factors: material incentives, such as performance-related pay, and team relations and support, such as recognition by superiors. This theoretical model is then tested with data collected in a national survey of 3,754 civil servants at the Swiss municipal level. Results of a structural equations model clearly show the relevance of PSM. They also provide evidence for the importance of socio-relational motivating factors, whereas material incentives play an anecdotal role.

Clinical Learning Environment and Supervision. Development and Validation of the CLES Evaluation Scale

The purpose of the study is: (1) to describe how nursing students' experienced their clinical learning environment and the supervision given by staff nurses working in hospital settings; and (2) to develop and test an evaluation scale of Clinical Learning Environment and Supervision (CLES). The study has been carried out in different phases. The pilot study (n=163) explored the association between the characteristics of a ward and its evaluation as a learning environment by students. The second version of research instrument (which was developed by the results of this pilot study) were tested by an expert panel (n=9 nurse teachers) and test-retest group formed by student nurses (n=38). After this evaluative phase, the CLES was formed as the basic research instrument for this study and it was tested with the Finnish main sample (n=416). In this phase, a concurrent validity instrument (Dunn & Burnett 1995) was used to confirm the validation process of CLES. The international comparative study was made by comparing the Finnish main sample with a British sample (n=142). The international comparative study was necessary for two reasons. In the instrument developing process, there is a need to test the new instrument in some other nursing culture. Other reason for comparative international study is the reflecting the impact of open employment markets in the European Union (EU) on the need to evaluate and to integrate EU health care educational systems. The results showed that the individualised supervision system is the most used supervision model and the supervisory relationship with personal mentor is the most meaningful single element of supervision evaluated by nursing students. The ward atmosphere and the management style of ward manager are the most important environmental factors of the clinical ward. The study integrates two theoretical elements - learning environment and supervision - in developing a preliminary theoretical model. The comparative international study showed that, Finnish students were more satisfied and evaluated their clinical placements and supervision with higher scores than students in the United Kingdom (UK). The difference between groups was statistical highly significant (p= 0.000). In the UK, clinical placements were longer but students met their nurse teachers less frequently than students in Finland. Arrangements for supervision were similar. This research process has produced the evaluation scale (CLES), which can be used in research and quality assessments of clinical learning environment and supervision in Finland and in the UK. CLES consists of 27 items and it is sub-divided into five sub-dimensions. Cronbach's alpha coefficient varied from high 0.94 to marginal 0.73. CLES is a compact evaluation scale and user-friendliness makes it suitable for continuing evaluation.

The impact of information on decision-making in palliative care

Résumé Ce travail vise à clarifier les résultats contradictoires de la littérature concernant les besoins des patients d'être informés et de participer à la prise de décision. La littérature insiste sur le contenu de l'information comme base de la prise de décision, bien qu'il existe des preuves que d'autres contenus sont importants pour les patients. La thèse essaie en outre d'identifier des possibilités de mieux répondre aux préférences d'information et de participation des patients. Les travaux ont porté en particulier sur les soins palliatifs. Une analyse de la littérature donne un aperçu sur les soins palliatifs, sur l'information des patients et sur leur participation à la prise de décisions thérapeutiques. Cette analyse résume les résultats d'études précédentes et propose un: modèle théorique d'information, de prise de décision et de relation entre ces deux domaines. Dans le cadre de ce travail, deux études empiriques ont utilisé des questionnaires écrits adressés à des personnes privées et à des professionnels de la santé, couvrant la Suisse et le Royaume Uni, pour identifier d'éventuelles différences entre ces deux pays. Les enquêtes ont été focalisées sur des patients souffrant de cancer du poumon. Les instruments utilisés pour ces études proviennent de la littérature afin de les rendre comparables. Le taux de réponse aux questionnaires était de 30-40%. La majorité des participants aux enquêtes estime que les patients devraient: - collaborer à la prise de décision quant à leur traitement - recevoir autant d'information que possible, positive aussi bien que négative - recevoir toutes les informations mentionnées dans le questionnaire (concernant la maladie, le diagnostic et les traitements), tenant compte de la diversité des priorités des patients - être soutenus par des professionnels de la santé, leur famille, leurs amis et/ou les personnes souffrant de la même maladie En plus, les participants aux enquêtes ont identifié divers contenus de l'information aux patients souffrant d'une maladie grave. Ces contenus comprennent entre autres: - L'aide à la prise de décision concernant le traitement - la possibilité de maintenir le contrôle de la situation - la construction d'une relation entre le patient et le soignant - l'encouragement à faire des projets d'avenir - l'influence de l'état émotionnel - l'aide à la compréhension de la maladie et de son impact - les sources potentielles d'états confusionnels et d'états anxieux La plupart des contenus proposés sont positifs. Les résultats suggèrent la coexistence possible de différents contenus à un moment donné ainsi que leur changement au cours du temps. Un modèle est ensuite développé et commenté pour présenter le diagnostic d'une maladie grave. Ce modèle est basé sur la littérature et intègre les résultats des études empiriques réalisées dans le cadre de ce travail. Ce travail analyse également les sources préférées d'information et de soutien, facteurs qui peuvent influencer ou faire obstacle aux préférences d'information et de participation. Les deux groupes de participants considèrent les médecins spécialistes comme la meilleure source d'information. En ce qui concerne le soutien, les points de vue divergent entre les personnes privées et les professionnels de la santé: généralement, les rôles de soutien semblent peu définis parmi les professionnels. Les barrières à l'information adéquate du patient apparaissent fréquemment liées aux caractéristiques des professionnels et aux problèmes d'organisation. Des progrès dans ce domaine contribueraient à améliorer les soins fournis aux patients. Finalement, les limites des études empiriques sont discutées. Celles-ci comprennent, entre autres, la représentativité restreinte des participants et les objections de certains groupes de participants à quelques détails des questionnaires. Summary The present thesis follows a call from the current body of literature to better understand patient needs for information and for participation in decision-making, as previous research findings had been contradictory. Information so far seems to have been considered essentially as a means to making treatment decisions, despite certain evidence that it may have a number of other values to patients. Furthermore, the thesis aims to identify ways to optimise meeting patient preferences for information and participation in treatment decisions. The current field of interest is palliative care. An extensive literature review depicts the background of current concepts of palliative care, patient information and patient involvement into treatment decisions. It also draws together results from previous studies and develops a theoretical model of information, decision-making, and the relationship between them. This is followed by two empirical studies collecting data from members of the general public and health care professionals by means of postal questionnaires. The professional study covers both Switzerland and the United Kingdom in order to identify possible differences between countries. Both studies focus on newly diagnosed lung cancer patients. The instruments used were taken from the literature to make them comparable. The response rate in both surveys was 30-40%, as expected -sufficient to allow stastical tests to be performed. A third study, addressed to lung cancer patients themselves, turned out to require too much time within the frame available. A majority of both study populations thought that patients should: - have a collaborative role in treatment-related decision-making -receive as much information as possible, good or bad - receive all types of information mentioned in the questionnaire (about illness, tests, and treatment), although priorities varied across the study populations - be supported by health professionals, family members, friends and/or others with the same illness Furthermore they identified various 'meanings' information may have to patients with a serious illness. These included: - being an aid in treatment-related decision-making - allowing control to be maintained over the situation - helping the patient-professional relationship to be constructed - allowing plans to be made - being positive for the patient's emotional state - helping the illness and its impact to be understood - being a source of anxiety - being a potential source of confusion to the patient Meanings were mostly positive. It was suggested that different meanings could co-exist at a given time and that they might change over time. A model of coping with the disclosure of a serious diagnosis is then developped. This model is based on existing models of coping with threatening events, as takeñ from the literature [ref. 77, 78], and integrates findings from the empirical studies. The thesis then analyses the remaining aspects apparent from the two surveys. These range from the identification of preferred information and support providers to factors influencing or impeding information and participation preferences. Specialist doctors were identified by both study populations as the best information providers whilst with regard to support provision views differed between the general public and health professionals. A need for better definition of supportive roles among health care workers seemed apparent. Barriers to information provision often seem related to health professional characteristics or organisational difficulties, and improvements in the latter field could well help optimising patient care. Finally, limitations of the studies are discussed, including questions of representativness of certain results and difficulties with or objections against questionnaire details by some groups of respondents.

Process and results of the development of an ICNP® Catalogue for Cancer Pain

This was a methodological study conducted to describe the process and results of the development of an International Classification for Nursing Practice (ICNP®) Catalogue for Cancer Pain. According to the International Council of Nurses (ICN), this catalogue contains a subset of nursing diagnoses, outcomes, and interventions to document the implementation of the nursing process in cancer patients. This catalogue was developed in several steps according to the guidelines recommended by the ICN. As a result, 68 statements on nursing diagnoses/outcomes were obtained, which were classified according to the theoretical model for nursing care related to cancer pain into physical (28), psychological (29), and sociocultural and spiritual (11) aspects. A total of 116 corresponding nursing interventions were obtained. The proposed ICNP® Catalogue for Cancer Pain aims to provide safe and systematic orientation to nurses who work in this field, thus improving the quality of patient care and facilitating the performance of the nursing process.

The network social support experience of people involved in home care

Objective: To build a theoretical model to configure the network social support experience of people involved in home care. Method: A quantitative approach research, utilizing the Grounded Theory method. The simultaneous data collection and analysis allowed the interpretation of the phenomenon meaning The network social support of people involved in home care. Results: The population passive posture in building their well-being was highlighted. The need of a shared responsibility between the involved parts, population and State is recognized. Conclusion: It is suggested for nurses to be stimulated to amplify home care to attend the demands of caregivers; and to elaborate new studies with different populations, to validate or complement the proposed theoretical model.


Constitutively active mutants of the alpha 1B-adrenergic receptor: role of highly conserved polar amino acids in receptor activation.

Site-directed mutagenesis and molecular dynamics simulations of the alpha 1B-adrenergic receptor (AR) were combined to explore the potential molecular changes correlated with the transition from R (inactive state) to R (active state). Using molecular dynamics analysis we compared the structural/dynamic features of constitutively active mutants with those of the wild type and of an inactive alpha 1B-AR to build a theoretical model which defines the essential features of R and R. The results of site-directed mutagenesis were in striking agreement with the predictions of the model supporting the following hypothesis. (i) The equilibrium between R and R depends on the equilibrium between the deprotonated and protonated forms, respectively, of D142 of the DRY motif. In fact, replacement of D142 with alanine confers high constitutive activity to the alpha 1B-AR. (ii) The shift of R143 of the DRY sequence out of a conserved 'polar pocket' formed by N63, D91, N344 and Y348 is a feature common to all the active structures, suggesting that the role of R143 is fundamental for mediating receptor activation. Disruption of these intramolecular interactions by replacing N63 with alanine constitutively activates the alpha 1B-AR. Our findings might provide interesting generalities about the activation process of G protein-coupled receptors.

Development of the short version of the informal caregiver burden assessment questionnaire

OBJETIVE to create a reduced version of the QASCI, which is structurally equivalent to the long one and meets the criteria of reliability and validity. METHOD Through secondary data from previous studies, the participants were divided into two samples, one for the development of reduced version and the second for study of the factorial validity. Participants responded to QASCI, the SF 36, the ADHS and demographic questions. RESULTS A reduced version of 14 items showed adequate psychometric properties of validity and internal consistency, adapted to a heptadimensional structure that assesses positive and negative aspects of care. CONCLUSION Confirmatory factor analysis revealed a good fit with the advocated theoretical model.

Turnout, political preferences and information: Experimental evidence from Perú

Electoral institutions that encourage citizens to vote are widely used around the world. Yet littleis known about the effects of such institutions on voter participation and the composition of the electorate.In this paper, I combine a field experiment with a change in Peruvian voting laws to identify theeffect of monetary (dis-)incentives on voting. Using the random variation in the fine for abstention andan objective measure of turnout at the individual level, I estimate the elasticity of voting with respectto cost to be -0.21. Consistent with the theoretical model presented, the reduction in turnout inducedby the reduction in the fine is driven by voters who (i) are in the center of the political spectrum, (ii)are less interested in politics, and (iii) hold less political information. However, voters who respondto changes in the cost of abstention do not have different preferences for policies than those who voteregardless of the cost. Further, involvement in politics, as measured by the decision to acquire politicalinformation, seems to be independent of the level of the fine. Additional results indicate that thereduction in the fine does not affect the incidence of vote buying, but increases the price paid for avote.