- Programming (1st year, 1st term) - Discrete Mathematics (1st year, 2nd term) - Algorithms and Data Structures (2st year, 2nd term) - Computer Structure (2nd year, 1st term)

K09: Know the principles of the relational model and database design, as well as software verification strategies, including the definition of tests in different development processes C03: Design data structures, determining their computational and storage complexity. C04: Evaluate database storage and management systems, designing efficient storage and access structures.

The descriptors associated with the subject are: File structures serial, sequential, hashed and indexed. Multidimensional access. Relational Data Model. Database Management Systems for Relational Databases. SQL database language: definition and manipulation. The program features the following agenda: ITEM 1. Introduction to Data Bases. Storage and Files: Physical vs. Logical focuses. Definition of Database. ITEM 2. The Relational Statics. Elements of the Relational Model. Description and notation. Inherent vs. Semantic Constraints. Implementation with SQL (DDL). ITEM 3. The Relational Dynamics. Relational Algebra. Data Manipulation through SQL. ITEM 4. Relational Model Extensions. Views and External Design. Procedural SQL: Blocks and Packages. Active Behavior: Triggers. ITEM 5. Basic Concepts on File Structures. File Design. Goals of Physical Design. File Processing: Selection vs. Location. ITEM 6. Base Structures. Basic structures: Serial and Sequential. Direct Access and Hashing. Clustering. ITEM 7. Auxiliary Structures Indexed Organization. B Tree-structured indexes. Special Indexes: bitmap. Index based Processes. ITEM 8. Data Base Management Systems Architecture and Fundamentals of the RDBMS Oracle. Internal Schema in the RDBMS Oracle. Processes, Execution Plans and Performance Measures. ITEM 8. Data Base Management Systems Architecture and Internal Schema in the RDBMS Oracle Processes and Execution Plans the RDBMS Oracle DBMS Connectivity. Security issues. Concurrency in RDBMS data operation. ITEM 9. DB Paradigms & Analytic DB Storage characterization: OLTP vs. OLAP Introducing OLAP technologies: types, uses and tools.

THEORETICAL-PRACTICAL CLASSES. [42 hours with 100% classroom instruction, 1.67 ECTS] Knowledge and concepts students must acquire. Student receive course notes and will have basic reference texts to facilitate following the classes and carrying out follow up work. Students partake in exercises to resolve practical problems and participate in workshops and evaluation tests, all geared towards acquiring the necessary capabilities. TUTORING SESSIONS. [4 hours of tutoring with 100% on-site attendance, 0.15 ECTS] Individualized attendance (individual tutoring) or in-group (group tutoring) for students with a teacher. STUDENT INDIVIDUAL WORK OR GROUP WORK [98 hours with 0 % on-site, 3.72 ECTS] WORKSHOPS AND LABORATORY SESSIONS [8 hours with 100% on site, 0.3 ECTS] FINAL EXAM. [4 hours with 100% on site, 0.15 ECTS] Global assessment of knowledge, skills and capacities acquired throughout the course. METHODOLOGIES THEORY CLASS. Classroom presentations by the teacher with IT and audiovisual support in which the subject's main concepts are developed, while providing material and bibliography to complement student learning. PRACTICAL CLASS. Resolution of practical cases and problem, posed by the teacher, and carried out individually or in a group. TUTORING SESSIONS. Individualized attendance (individual tutoring sessions) or in-group (group tutoring sessions) for students with a teacher as tutor. LABORATORY PRACTICAL SESSIONS. Applied/experimental learning/teaching in workshops and laboratories under the tutor's supervision.