The aim of this course is that the student understands the role of databases within an information system, know the most important properties that define it, and acquire a methodology for their development and management. 1. Cross/Generic Capabilities 1.a) Analysis and synthesis abilities 1.b) Organize and plan abilities 1.c) Troubleshooting 1.d) Teamwork 1.e) Ability to apply knowledge in practice 2. Specific Capabilities 2.a) Cognitive (Knowledge) 2.a.1) Fundamentals of Databases 2.a.2) Relational data model 2.a.3) SQL Language 2.a.4) Datawarehouses 2.b) Procedural/Instrumental (Know how) 2.b.1) Database Design using conceptual and logical models 2.b.2) Adquiring practical experience in the use of SQL lenguage 2.b.3) Implementing Database Systems using a DBMS 2.b.4) Querying and developing reports 2.c) Attitudinal (To be) 2.c.1) Ability to create designs (creativity) 2.c.2) To discuss and clarify the diverse solutions to a problem

The descriptors associated with the subject are presented : Relational Data Model. Relational Databases Management Systems. SQL language: definition and manipulation. Data Warehouse: ROLAP, NoSQL. Syllabus: 1. Introduction to Databases 1.1. The role of Databases in Information Systems 1.2. Concepts and objectives of Databases (DB) 1.3. Types of Databases 1.4. Database Management Systems (DBMS) 1.5. Methodology for Databases Development 2. Relational Model This topic explains the Relational Model for Database Design. The model is explained by introducing the basic elements and the inherent and semantics constraints. It also explains the SQL query language by which relational databases can be implemented. 2.1. Introduction and objectives 2.2. Relational Data model structure 2.3. Relational Data model constraints 2.4 Design of relational databases 3. SQL Language 3.1. Static model. Definition Language 3.2. Dynamic model. Manipulation Language 4. Datawarehouses 4.1. Concept and architecture 4.2. Development methodology 4.3. Multidimensional model. Design 4.4. ETL process(Extract, Transform and Load) 4.5. Implementation: ROLAP (Relational Online Analytical Proccessing) 4.6. Queries 5. Introduction to NoSQL Databases 5.1. History 5.2. Definition 5.3. Characteristics 5.5. Types of NoSQL Databases.

- Theory: 1.5 ECTS. The aim is to achieve the specific cognitive skills of the subject - Problem-based learning: 0.75 ECTS. Specific works under the supervision of the teacher about real problems. - Practical: 1 ECTS. To develop specific skills instrumentals and traversals, such as teamwork, analysis and synthesis. We also aim to develop specific skills attitude. - Tutoring: 0.5 ECTS. With the presence of teacher to review and discuss the materials and topics presented in class. - Review: 0.25 ECTS. Set of written tests, oral, practical projects, works, etc.. used in the assessment of student progress. They aim to influence and complement in the development of specific cognitive and procedural skills. - Practical Self-work : 0.5 ECTS. Lab works studied under a didactical guide provided by teacher. - Self-Theoretical study: 1.5 ECTS. Study of content related to "classroom" (test study, library work, reading, doing problems and exercises, etc.)