knowledge organization and representation

This course aim is to understand the databases roll in an Information System, to know the features which define a Databases System, and to acquire skills to implement a Databases Systems through different data models. - Analysis and synthesis abilities - Organize and plan abilities - Troubleshooting - Teamwork - Ability to apply knowledge in practice Cognitive (Knowledge) - Fundamentals of Databases - Databases development methodology - Relational data model Procedural/Instrumental (Know how) - Database Design to different abstraction levels - Implementing Database Systems using a DBMS Attitudinal (To be) - Ability to create designs (creativity) - Discuss and clarify the diverse solutions for a problem

K1: Know the principles and values of democracy and sustainable development, in particular, respect for human rights and fundamental rights, gender equality and non-discrimination, the principles of universal accessibility and climate change. K3: Identify and analyze research methodologies and sources to develop academic work in the field of digital information management K4: Understand and apply the fundamental theories, instruments and techniques to manage information in digital media, covering its organization, control, communication and preservation K6: Know models of information retrieval and visualization using database systems and visual representation methods. S1: Plan and organize teamwork by making correct decisions based on available information and gathering data in digital environments. S3: Apply digital information management principles in different organizational environments, ensuring effective communication of processes and results to stakeholders. S5: Be able to design, manage, and operate with information through database systems, demonstrating skill in information retrieval and the use of query languages to meet complex information needs. S6: Be able to collect, process, cleanse and aggregate data by understanding the needs of users and organizations and how they need them. C1: Know and be able to manage interpersonal skills on initiative, responsibility, conflict resolution, negotiation, among others, which are required in the professional field. C2: Be able to apply knowledge in a professional way in solving specific digital information management problems using the tools and techniques learned in the academic field C3: Demonstrate ability in the development and execution of digital content projects autonomously working in multidisciplinary teams. C4: Capacity for continuous autonomous learning that facilitates adaptation to new situations and the updating of knowledge in the field of digital information.

The descriptors associated with the subject are: Basic concepts of databases. The role of database managment system. Application of a methodology for the development of databases. Data models in methodologies. The Relational model. SQL, Case studies to develop a database. CONTENTS Issue 1. Introduction to databases 1.1 The Databases role in Information Systems 1.2. Foundations of Databases 1.3 Databases Management System (DBMS) 1.4 Database modesl and development methodologies Issue 2. Relational model 2.1. Basis elements 2.2. Constraints Issue 3. Relational databases Design Issue 4: SQL lenguage -Definition, Updating and Querying 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.)