Disseny i implementació d'una base de dades relacional per a un concessionari de vehicles

Aquest treball de final de carrera consisteix en la implementació d'una base de dades relacional per a la gestió d'un concessionari de vehicles. En aquest cas, el nostre client disposa d'una xarxa de concessionaris distribuïda per tota Catalunya. La base de dades haurà de permetre la gestió de les vendes de vehicles als diferents concessionaris, i la gestió de revisions i reparacions que es realitzen als tallers.

Disseny i implementació àgil d'una base de dades relacional per a un concessionari de vehicles

Desenvolupament d'un projecte de base de dades sobre Oracle, utilitzant TDD, iteracions, versionat del codi i refactorització.

Disseny i implementació d'una base de dades relacional per a un concessionari de vehicles

Disseny i implementació d'una base de dades relacional per a un concessionari de vehicles i un magatzem de dades per obtenir estadístiques.

Diseño e implementación de una base de datos relacional para la gestión de la red de bibliotecas

Implementar una base de datos para que pueda ser integrada en un aplicativo de gestión de una red de bibliotecas y que permita obtener de forma eficiente aquellos elementos valiosos para la toma de decisiones.

Quantitative sequence analysis of FBN1 premature termination codons provides evidence for incomplete NMD in leukocytes.

We improved, evaluated, and used Sanger sequencing for quantification of single nucleotide polymorphism (SNP) variants in transcripts and gDNA samples. This improved assay resulted in highly reproducible relative allele frequencies (e.g., for a heterozygous gDNA 50.0+/-1.4%, and for a missense mutation-bearing transcript 46.9+/-3.7%) with a lower detection limit of 3-9%. It provided excellent accuracy and linear correlation between expected and observed relative allele frequencies. This sequencing assay, which can also be used for the quantification of copy number variations (CNVs), methylations, mosaicisms, and DNA pools, enabled us to analyze transcripts of the FBN1 gene in fibroblasts and blood samples of patients with suspected Marfan syndrome not only qualitatively but also quantitatively. We report a total of 18 novel and 19 known FBN1 sequence variants leading to a premature termination codon (PTC), 26 of which we analyzed by quantitative sequencing both at gDNA and cDNA levels. The relative amounts of PTC-containing FBN1 transcripts in fresh and PAXgene-stabilized blood samples were significantly higher (33.0+/-3.9% to 80.0+/-7.2%) than those detected in affected fibroblasts with inhibition of nonsense-mediated mRNA decay (NMD) (11.0+/-2.1% to 25.0+/-1.8%), whereas in fibroblasts without NMD inhibition no mutant alleles could be detected. These results provide evidence for incomplete NMD in leukocytes and have particular importance for RNA-based analyses not only in FBN1 but also in other genes.

Diseño e implementación de la base de datos de un sistema de descarga de aplicaciones para móviles inteligentes

Este proyecto consiste en el diseño de una base de datos para una aplicación de gestión de la asociación mundial de programadores de aplicaciones móviles. El sistema de base de datos de dicha aplicación deberá guardar información principalmente de clientes o usuarios finales, programadores, aplicaciones y descargas, así como de toda la información relacionada y necesaria para la gestión.

Disseny i implementació de la base de dades d'un sistema de descàrrega d'aplicacions per a mòbils intel·ligents

El propòsit d'aquest treball de fi de carrera és la planificació, l'anàlisi, el disseny i la implementació d'una base de dades d'un sistema de descàrrega d'aplicacions per a mòbils intel·ligents.

Determinants of acquisition completion: a relational perspective

The strategic literature on relatedness in the context of mergers and acquisitions (M&As) is extensive, yet we know little about whether or how relatedness has an influence on the announcement to completion stage of the M&A process. Drawing on research on intra-industry competition and relational capabilities, we seek to shed light on the relatedness debate by examining the strategic forces that affect the completion of an announced related M&A, accounting for financial and organizational factors. We also explore additional strategic forces that might amplify or attenuate the negative effect of relatedness on deal completion. We test and find support for our hypotheses using longitudinal data from a sample of the largest M&A announcements in the world from 1991 to 2001.

Debt enforcement and relational contracting

We examine how third-party debt enforcement affects the emergence and performance ofrelational contracts in credit markets. We implement an experiment with finitely repeatedcredit relationships in which borrowers can default. In the weak enforcement treatmentdefaulting borrowers can keep their funds invested. In the strong enforcement treatmentdefaulting borrowers have to liquidate their investment. Under weak enforcement fewerrelationships emerge in which loans are extended and repaid. When such relationships doemerge they exhibit a lower credit volume than under strong enforcement. These findingssuggest that relational contracting in credit markets requires a minimum standard of thirdpartydebt enforcement.

Disseny i implementació de la base de dades d'un sistema de descàrrega d'aplicacions per a mòbils intel·ligents

En aquest projecte es recullen totes les fases necessàries per dissenyar i implementar una base de dades relacional que asseguri la persistència de les dades relatives a les entitats implicades.

Cross-species and cross-platform gene expression studies with the Bioconductor-compliant R package 'annotationTools'.

Background: The variety of DNA microarray formats and datasets presently available offers an unprecedented opportunity to perform insightful comparisons of heterogeneous data. Cross-species studies, in particular, have the power of identifying conserved, functionally important molecular processes. Validation of discoveries can now often be performed in readily available public data which frequently requires cross-platform studies.Cross-platform and cross-species analyses require matching probes on different microarray formats. This can be achieved using the information in microarray annotations and additional molecular biology databases, such as orthology databases. Although annotations and other biological information are stored using modern database models ( e. g. relational), they are very often distributed and shared as tables in text files, i.e. flat file databases. This common flat database format thus provides a simple and robust solution to flexibly integrate various sources of information and a basis for the combined analysis of heterogeneous gene expression profiles.Results: We provide annotationTools, a Bioconductor-compliant R package to annotate microarray experiments and integrate heterogeneous gene expression profiles using annotation and other molecular biology information available as flat file databases. First, annotationTools contains a specialized set of functions for mining this widely used database format in a systematic manner. It thus offers a straightforward solution for annotating microarray experiments. Second, building on these basic functions and relying on the combination of information from several databases, it provides tools to easily perform cross-species analyses of gene expression data.Here, we present two example applications of annotationTools that are of direct relevance for the analysis of heterogeneous gene expression profiles, namely a cross-platform mapping of probes and a cross-species mapping of orthologous probes using different orthology databases. We also show how to perform an explorative comparison of disease-related transcriptional changes in human patients and in a genetic mouse model.Conclusion: The R package annotationTools provides a simple solution to handle microarray annotation and orthology tables, as well as other flat molecular biology databases. Thereby, it allows easy integration and analysis of heterogeneous microarray experiments across different technological platforms or species.

Iowa Soil Properties and Interpretation Database, 2002

Report produced by Iowa Departmment of Agriculture and Land Stewardship

KnotProt: a database of proteins with knots and slipknots.

The protein topology database KnotProt, http://knotprot.cent.uw.edu.pl/, collects information about protein structures with open polypeptide chains forming knots or slipknots. The knotting complexity of the cataloged proteins is presented in the form of a matrix diagram that shows users the knot type of the entire polypeptide chain and of each of its subchains. The pattern visible in the matrix gives the knotting fingerprint of a given protein and permits users to determine, for example, the minimal length of the knotted regions (knot's core size) or the depth of a knot, i.e. how many amino acids can be removed from either end of the cataloged protein structure before converting it from a knot to a different type of knot. In addition, the database presents extensive information about the biological functions, families and fold types of proteins with non-trivial knotting. As an additional feature, the KnotProt database enables users to submit protein or polymer chains and generate their knotting fingerprints.

SelenoDB 1.0 : a database of selenoprotein genes, proteins and SECIS elements

Selenoproteins are a diverse group of proteinsusually misidentified and misannotated in sequencedatabases. The presence of an in-frame UGA (stop)codon in the coding sequence of selenoproteingenes precludes their identification and correctannotation. The in-frame UGA codons are recodedto cotranslationally incorporate selenocysteine,a rare selenium-containing amino acid. The developmentof ad hoc experimental and, more recently,computational approaches have allowed the efficientidentification and characterization of theselenoproteomes of a growing number of species.Today, dozens of selenoprotein families have beendescribed and more are being discovered in recentlysequenced species, but the correct genomic annotationis not available for the majority of thesegenes. SelenoDB is a long-term project that aims toprovide, through the collaborative effort of experimentaland computational researchers, automaticand manually curated annotations of selenoproteingenes, proteins and SECIS elements. Version 1.0 ofthe database includes an initial set of eukaryoticgenomic annotations, with special emphasis on thehuman selenoproteome, for immediate inspectionby selenium researchers or incorporation into moregeneral databases. SelenoDB is freely available athttp://www.selenodb.org.