TecnoCampus Foundation
eCampus
University Business
eCampus

What are you looking for?

General information

Subject type: Mandatory

Coordinator: Vladimir Bellavista Parent

Trimester: First term

Credits: 4

Teaching staff: 

Alfonso Palacios González
Laura Rivera Sanchez 

Academic year: 2025

Teaching course: 3

Languages ​​of instruction

  • Spanish

This subject is taught in Catalan. Some sessions, the bibliography, part of the content and tools may be in English or 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

  • B5_That students have developed those learning skills necessary to undertake further studies with a high degree of autonomy

Specific skills

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

  • EIS1_Ability to develop, maintain and evaluate software services and systems that meet all user requirements and that behave reliably and efficiently, are affordable to develop and maintain and comply with quality standards, applying theories, principles, methods and software engineering practices

  • EIS2_Ability to assess customer needs and specify software requirements to meet those needs, reconciling conflicting goals, by seeking acceptable compromises, within the limitations of cost, time, the existence of already developed systems and of the organizations themselves

  • EIS4_Ability to identify and analyze problems and design, develop, implement, verify and document software solutions based on adequate knowledge of current theories, models and techniques

  • EIS5_Ability to identify, assess and manage potential associated risks that may arise

  • EIS6_Ability to design appropriate solutions in one or more application domains, using software engineering methods that integrate ethical, social, legal and economic aspects

  • ESI3_Ability to actively participate in the specification, design, implementation and maintenance of information and communication systems

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

The general objective of the subject is the deepening in the knowledge of the databases and of the systems managers of databases, discovering the procedural extension of the language SQL for the implementation of the external designs of the databases, knowing the architecture of DBMSs to be able to manage data access methods, optimize SQL queries, define physical design and manage concurrency.  

The classroom (physical or virtual) is a safe space, free from sexist, racist, homophobic, transphobic and discriminatory attitudes, whether 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

Topic 1

Content title 1 Programming with procedural languages ​​of
database definition

Dedication: GG:4h GP:2h Seminars: 2h AA:12h

 

 

 

Description

Introduction to the procedural languages ​​of databases, which allow the enrichment of the logical design and the definition of advanced business rules of databases. 

Subject matter

1.1 Transactional or procedural languages ​​of DBMS

1.2 Procedures and functions

1.3 Abstract Data Types: Packages and Types.

1.4 Triggers

Topic 2

Content title 2:  External database design

Dedication: GG:4h GP:2h Seminars: 2h AA:12h

 

 

 

Description

Use of procedural languages ​​and SQL to implement external database design and distributed design.  

Subject matter

2.1 Synonyms, views, materialized views

2.2 Implementation of external schemes

2.3 Implementation of distributed databases

Topic 3

Content title 3:  Architecture, structure, access methods and DBMS optimization

Dedication: GG: 4h GP: 2h Seminar: 2h AA: 12h

 

 

 

Description

Deepening knowledge of databases and database management systems, the architecture of DBMSs to be able to manage data access methods, optimize the execution of SQL queries and define the physical design.

Subject matter

2.1 DBMS architecture

2.2 Internal database structure

2.3 Methods of access

2.4 Query processing and execution plans

2.5 Optimization of SQL statements

Topic 4

Content title 4:  Concurrency control

Dedication: GG:4h GP:2h Seminars: 2h AA:12h

 

 

 

Description

Introduction to concurrency control in databases, learning the tools to manage transactions, concurrency and ACID systems. Management of consistency in reading and updating.

Subject matter

4.1 Transaction management and concurrency control.

4.2 Consistency in reading. Multi-version models.

4.3 ACID systems. Isolation levels. 

4.4 Management of serialization, blockages and deadlocks.

Topic 5

Content title 5: NoSQL data systems

Dedication: GG:4h GP:2h Seminars: 2h AA:12h

 

 

 

Description

Introduction to NoSQL systems and non-relational data models. 

Subject matter

5.1 Introduction to "Not Only SQL" data systems

5.2 Non-relational data models

5.3 Architecture and programming with NoSQL

Activities and evaluation system

Qualification system (evaluation)

 

Each of the five subjects accounts for 20% of the subject grade. 

For each subject there is an individual assessment test that represents 20% of the final grade. 

You need a grade above 5 in each subject to pass the subject and be able to pass the average.

 

Failed subjects can be made up in the January make-up exam. The grade for each recovery subject is only PASS(5) or NOT PASS. 

 

Following the general regulations, the copy in the evaluation activities leads to the evaluation with a SUSPENSED note (0) of the whole subject.

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.

 

Rules for carrying out the activities

Attendance and active participation in the five seminars and five practical laboratories is mandatory so that each topic can be evaluated.

 

 

Bibliography

Basic

Elmasri, R .; Navathe, SB "Fundamentals of Database Systems, Global Edition". Seventh Edition. Harlow, Essex: Pearson, 2017. ISBN 978-1-292-09761-9.

Silberschatz, Abraham; Korth, Henry; Sudarshan, S. Database Systems Concepts. Seventh Edition. McGraw-Hill-Education, 2019. ISBN 978-1260084504.

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

Complementary

Date, CJ “An Introduction to Database Systems”. Seventh edition. Addison Wesley Longman, 2001. ISBN 978-0201787221 / Eighth edition. Person,
2003 ISBN 978-0321197849

Date, CJ "Introduction to database systems". Seventh edition México-Pearson Education, 2001. ISBN 9684444192

McLaughlin, Michael. "Oracle Database 12c PL/SQL Programming". Oracle Press-McGraw-Hill Education, 2014. ISBN-13: 9780071812436. ISBN-10: 0071812431.