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

K2: Know basic humanistic contents, oral and written expression, following ethical principles and completing a multidisciplinary training profile. K4: Know the models and methods of statistical analysis for both static and dynamic data K7: Know the methods and tools to design and manage relational and non-relational databases K12: now how to identify or be able to create the statistical or probabilistic model appropriate to the specific problem arising in each business activity (finance, marketing, production planning and control, etc.). C1: Develop and master interpersonal skills on initiative, responsibility, conflict resolution and negotiation, which are essential in the professional environment. C2: Ability to efficiently manage the information contained in a company's databases for statistical use, as well as to know how to design the process of acquiring new information (data) useful for the company. C6: Ability to interpret the results of quantitative analysis, prepare clear reports and communicate conclusions effectively, using advanced data analysis tools. S5: Manipulate computationally and analytically the established models, taking advantage of the power of statistical methods, optimization, etc., and perform the analysis of the results obtained. S7: Describe, synthesize and graphically represent the information contained in a data set

The descriptors associated with the subject are presented : Relational Data Model. Relational Databases Management Systems. SQL language: definition and manipulation. Data Warehouse: ROLAP. 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

- 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.)