TecnoCampus Foundation
eCampus
University Business
eCampus

What are you looking for?

General information

Subject type: Basic

Coordinator: Vladimir Bellavista Parent

Trimester: Third term

Credits: 6

Teaching staff: 

Montserrat Rabassa Jou
Laura Beltran Perez 

Academic year: 2025

Teaching course: 1

Languages ​​of instruction

  • Catalan

The course offers official ORACLE material in English and Spanish.

Competencies / Learning Outcomes

Basic skills

  • B2_That students know how to apply their knowledge to their job or vocation in a professional way and have the skills they demonstrate by developing and defending arguments and solving problems within their area of ​​study

  • B4_That students can convey information, ideas, problems and solutions to both specialized and non-specialized audiences

Specific skills

  • EFB4_Basic knowledge of the use and programming of computers, operating systems, databases and computer programs with application in engineering

Transversal competences

  • T1_That students know a third language, which will be preferably English, with an adequate level of oral and written form, according to the needs of the graduates in each degree

  • T2_That students have the ability to work as members of an interdisciplinary team either as one more member, or performing management tasks in order to contribute to developing projects with pragmatism and a sense of responsibility, making commitments taking into account the available resources

Presentation of the subject

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. 

Contents

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.

Activities and evaluation system

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 be retaken as long as the final grade for the subject is less than 5 (excluding those not presented). Internships cannot be recovered, under any circumstances.
  • For students who attend the retake exam, the grade for the THEORY part will be that obtained in this test and the final grade will be calculated with the weightings detailed above as long as the grade for the retake exam is 5 or higher.
  • The final mark of the subject in no case will it be greater 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.

Bibliography

Basic

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

Complementary

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.