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 gestió de processos informàtics
Author: Garcia Sirera, Enric
Tutor: Ferrer Durán, Jordi
Others: Baró, Xavier  
Keywords: database
data warehouse
Issue Date: 7-Jan-2022
Publisher: Universitat Oberta de Catalunya (UOC)
Abstract: The company Next World SA, has decided to implement an ITSM (IT Service Management) tool with the specific intention of managing incidents related to the computer system (Incident Management) and also the management of equipment (Assets Management). The Incident Management system must be able to record user problems or complaints, store the most important details and assign a technician to solve the problem. As for asset management, the objective is to control the material assigned to each user, the purchase and maintenance cost, incidents and cancellations. In addition, the management of equipment must include the necessary financial information to know whether it is an expense or an investment, in the case of an investment, to which project it is associated and what level of depreciation it accumulates. It is also necessary to record the incidents associated with each equipment and user. Finally, Asset Management must allow two types of audit, the financial audit (legal requirement) and the process audit. The financial audit must validate the investment in equipment on a periodic basis, making a physical inventory to ensure that what is detailed in the system actually exists. For each asset it will be necessary to keep the date on which the last check was made. The process audit must sample incidents and equipment on a regular basis to ensure that the company's guidelines are being followed. The system must store information on the incidents or assets that have been The system has to store the information of the incidents or assets that have been reviewed and the conclusions. The scope of this work will be to analyze the described problem and define the database structure needed to support the ITSM tool. The development of the tool itself is out of scope.
Language: Catalan
Appears in Collections:Treballs finals de carrera, treballs de recerca, etc.

Files in This Item:
File Description SizeFormat 
Enricgs_presentacio.zip521,12 kBZIPView/Open
Enricgs_producte.zip882,44 kBZIPView/Open
Enricgs_annexes.zip113,4 kBZIPView/Open
enricgsTFG0122memòria.pdfMemòria del TFG2,24 MBAdobe PDFThumbnail
enricgsTFG0122presentació.pdfPresentació del TFG588,07 kBAdobe PDFThumbnail