This document is part of the final project of the Computer Engineering degree in the area of databases. The project is motivated by the need of the company RecruitCAT to have a database and a data warehouse that works as a statistical repository with queries at cost 1.For the development of the project, it was used the waterfall method. As a first step the analysis of requirements, continuing with the design of the database and the warehouse and as a final step the implementation. A set of test data was designed in order to assure the correct operation of the whole system.For the analysis of requirements, the customer provided the initial specifications that were refined during the project. For the design, they were used, specifically, the database design techniques in their different stages: conceptual, logical and physical design. For the implementation, sequences were used to create the primary keys, triggers were used to keep the data repository updated and procedures were defined to insert, modify, view and delete the data, controlling the possible exceptions.For the set of tests, the initial data was entered and a series of inserts, updates and deletes were done, verifying at every moment that the data warehouse keeps the correct data.The products obtained in the development of this project have been: the initial work plan, the project´s memory, the programming code, the report of transversal competences and the virtual presentation. |