Please use this identifier to cite or link to this item:
Title: Disseny i implementació de la base de dades per a una aplicació de control de pràctiques en empreses dels estudiants universitaris
Author: Angrill Navarro, Eduard
Tutor: Ferrer Durán, Jordi
Others: Jiménez Pelayo, Javier
Abstract: Consell Interuniversitari de Catalunya (CIC) wants to implement an application to monitor the internships that the students from different universities do at the companies. So, the main goal of this project, is to design and provide a Data Base that can fully support this application. The development of the app it’s out of the scope of this project. The design of the DB will be generated into an UML diagram. That will contain all the entities, relations and restrictions that will be needed to grant that all the information will be properly stored. As requested, the interface user won’t be able to modify the data directly from the Data Base. Therefore, he will have to use Stored Procedures to access the data. So, all the operations will be encapsulated into SPs, improving the maintenance and track of the executions into a Logfile. As known, the Data Base in the future will store a lot of data, so DWH techniques will be implemented to provide data optimization and to avoid performance issues. Also, this project will provide and Statistic Data Warehouse that will execute queries with constant time 1. During the development of this project, it was possible to put into practice all the knowledge acquired during all these years on the different subjects of this Degree. Also, it was very interesting and challenging to use it to implement the DB using a different technology. So, it has been a must to do external searches to increase the current knowledge.
Keywords: internships
Document type: info:eu-repo/semantics/bachelorThesis
Issue Date: 20-Jan-2023
Publication license:  
Appears in Collections:Treballs finals de carrera, treballs de recerca, etc.

Files in This Item:
File Description SizeFormat 
eangrillTFG0123producte.rarProducte resultant19,24 kBRARView/Open
eangrillTFG0123presentacio.pdfPresentació del TFG1,63 MBAdobe PDFThumbnail
eangrillTFG0123memoria.pdfMemòria del TFG2,65 MBAdobe PDFThumbnail
View statistics

This item is licensed under aCreative Commons License Creative Commons