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

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