Files and Data bases (Year 2; Term 2)

Learning outcomes: R1. Knowledge and understanding: Have basic knowledge and understanding of the scientific and technological foundations of Computer Engineering, as well as a specific knowledge of computer science, computer engineering and information systems. R2. Engineering Analysis: To be able to identify Computer Engineering problems, recognise their specifications, establish different resolution methods and select the most appropriate one for their solution, taking into account the social, human health, environmental, and commercial constraints applicable in each case. R4. Research and Innovation: Be able to use appropriate methods to carry out research and make innovative contributions in the field of Computer Engineering. R5. Engineering Applications: Graduates will be able to apply their knowledge and understanding to solve problems, conduct research and design devices or processes in the field of Computer Engineering in accordance with criteria of cost, quality, safety, efficiency, respect for the environment and ethical implications. These skills include knowledge, use and limitations of computer systems, process engineering, computer architectures, computational models, equipment, practical work, technical bibliography and information sources. R6. Transversal Competences: To have the necessary skills for the practice of engineering in today's society. The graduate will have the abilities to work effectively both individually and in teams, showing communication and team coordination skills. Furthermore, they will demonstrate an awareness of the responsibility of engineering practice, social and environmental impact, and a commitment to professional ethics, and standards of engineering practice. Finally, they will demonstrate skills and competencies related to best practices in project management, their tools and risk analysis. Basic and General Competences: CGB4 - Basic knowledge on the use and programming of computers, operating systems, databases and software with application in engineering. software with application in engineering. CG5 - Use computer tools, general purpose, collaborative and work optimization tools for the effective planning and implementation of projects. implementation of projects. GC7 - Be able to present and discuss proposals in teamwork, demonstrating personal and social skills that allow them to assume different responsibilities within the same team. GC9 - Efficiently use ICT means to write technical reports and project and work reports on Computer Science, as well as quality presentations. CGO9 - Ability to solve problems with initiative, decision-making, autonomy and creativity. Ability to know how to communicate and transmit the knowledge, skills and abilities of the profession of Technical Engineer in Computer Science. Specific competences: CECRI5 - Knowledge, administration and maintenance of computer systems, services and applications.

1. Database Design Methodologies 2. Fundamentals of Database Administration 3. Physical design of databases 4. Database Settings 5. Paradigms and Database Architectures.

* Lectures: 0.9 ECTS. They aim to achieve the specific cognitive competences of the subject, as well as the transversal competences of analysis and abstraction. * Practical classes: 0.9 ECTS. They aim to initiate the development of the specific instrumental competences, as well as the transversal competences problem solving and application of knowledge. * Continuous assessment exercises: 1 ECTS. Initiated during practical classes and completed outside of them, they aim to complete the development of the specific instrumental competences and initiate the development of the specific attitudinal competences, as well as the transversal competences problem solving and application of knowledge. * Practical work: 1.7 ECTS. Developed without the presence of the teacher, they aim to complete and integrate the development of all the specific and transversal competences, in the resolution of two practical cases where the approach to the problem, the choice of the method of resolution, the results obtained and their interpretation are well documented. * Tutoring classes: 1 ECTS. Individual (individual tutorials) or group (group tutorials) assistance to students by the lecturer. * Final exam: 0.5 ECTS. Its aim is to influence and complement the development of specific cognitive and procedural skills. It especially reflects the use made of the master classes.