106819 - DATABASES

Subject type: Optional

Coordinator: Juan José Pons López

Trimester: Third term

Credits: 6

Academic year: 2025

Teaching course: 4

• Catalan

The course offers official ORACLE material in English and Spanish.

Introduction to databases focuses, in its first part, on the relational data model and the mechanisms that allow access and manipulation of relational databases (SQL) and in the second part, on the conceptual modeling of data The objective of the subject is to offer students a first view of what a database is.

This subject is the first subject included in the database area. 

The classroom (physical or virtual) is a safe space, free of sexist, racist, homophobic, transphobic and discriminatory attitudes, either towards students or teachers. We trust that together we can create a safe space where we can make mistakes and learn without having to suffer the prejudices of others. 

Block 1. Introduction to databases

Database basics. File Systems. Database Systems. Concept of database management system (SDBD). Advantages and disadvantages of comics

Block 2. The relational model

Basic concepts of the relational model. Model structure. Integrity restrictions. Exercises.

Block 3. The data definition language (DDL)

Data types. Creating tables and integrity constraints. Creating views. Exercise resolution.

Block 4. The data manipulation language (DML)

Queries on a single table. Queries on various tables. Summary queries. Groupings. Use of subqueries. Functions. Database modifications. Exercise resolution.

Block 5. Introduction to the conceptual model of data and logical design

Database design process. Data models. Basic concepts of the conceptual model. Business rules. Entities and associations. Weak entities. Reflective entities. Associative entities. Generalizations. Creation of conceptual models. Transformation of the conceptual model: Transformation of the associations one_to_many, many_to_many, one_to_one and reflective, transformation of the associative entities, of the weak entities and transformation of the generalizations. Improvements to the initial logical model.

Ordinary Call

The subject is evaluated based on the grades of the following activities:

THEORY: WRITTEN TEST OF ALL BLOCKS

PRACTICES: PRACTICE 1, PRACTICE 2, PRACTICE 3, PRACTICE 4

The calculation of the part of theory and practices of the asignatura calculates taking into account these formulas:

THEORY = 0.60 WRITTEN TEST OF ALL BLOCKS

PRACTICE = 0,1 PRACTICE1 + 0,1 PRACTICE2 + 0,1 PRACTICE3 + 0,1 PRACTICE4

And the final grade is obtained:

• If THEORY <5 the final grade of the subject is the THEORY grade
• Otherwise, the final grade of the subject is THEORY + PRACTICE

Recovery Call

The theoretical part of the subject (THEORY) can always be recovered when the final mark of the subject is lower than 5 (excluding those not presented). Internships cannot be recovered, under any circumstances.

For students who attend the make-up exam the grade for the THEORY part will be the one obtained in this test and the final grade will be calculated with the weightings detailed above and in no case will it be higher than 5.

Considerations
Any form of academic fraud will be sanctioned in accordance with the center's assessment regulations. If signs of fraud are detected, including the improper use of generative artificial intelligence tools, the subject's teaching staff may call the student for an individual interview with the aim of verifying their authorship.
Given the fundamental nature of this subject, the student is required not only to provide solutions to certain problems, but also to be able to generate them autonomously, without any external help. For this reason, the use of generative artificial intelligences (IAG) to resolve the problems posed in the subject —whether in exercises, practices or tests— is counterproductive, is strictly prohibited and will be considered a case of plagiarism fraud. In this sense, the use of IAGs to generate programming code is not allowed, not even in the form of fragments, even if this code is later modified or personalized. The critical use of IAGs as a vehicle to resolve doubts about the subject is not considered a misuse of these mechanisms as long as this does not contradict what has been indicated previously and the student does not lose sight of the fact that he may obtain incorrect answers and/or not adjusted to the contents of the subject.

The use of generative artificial intelligence (AI) tools in the assessment activities of the subject is not permitted. The student is responsible for the content of the activities he/she presents.

Abraham Silberschatz; Henry Korth; Sundarararajarao Sudarshan. "Fundamentals of Databases". Sixth edition. Madrid-McGraw-Hill-Education, 2014. ISBN 978-84-481-9033-0.

Ramez Elmasri, Shamkant B. Navathe. Fundamentals of Database Systems, Global Edition, Seventh Edition. Pearson

Jason Price. Oracle database 12c SQL. Publishing Oracle Press McGraw-Hill Osborne Media, 2013.

Thomas M. Connolly; Carolyn E. Begg. Database systems. Pearson Addison-Wesley, 2005.