DATABASE MANAGEMENT SYSTEMS TecnoCampus | Centers attached to Pompeu Fabra University and Business Park

General information

Subject type: Mandatory

Coordinator: Ana Beatriz Pérez Zapata

Trimester: First term

Credits: 4

Teaching staff:

Alfonso Palacios González
Laura Rivera Sanchez

Teaching languages

Spanish

This subject is part of the offer for international students. The teaching of this subject is in Spanish. Some sessions, bibliography, part of the contents and tools may be in English. However, Catalan, the language of our country, can be used freely by its students.

Skills

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
EIS3_Ability to solve integration problems based on available strategies, standards and technology
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

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

Description

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.

Evaluation system

Qualification system (evaluation)

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

For each topic there is a practice laboratory and an individual assessment test that represent 5% and 15% of the final grade.

Topics 1 and 2 are assessed together.

Lab notes are not recoverable.

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

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

Rules for carrying out the activities

All activities are required to attend to be evaluated.

Activities are mandatory. Activities not performed - or those not attended - are rated as 0.

REFERENCES

Basic

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

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

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

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

107312 - DATABASE MANAGEMENT SYSTEMS

Double Degree in Computer Engineering for Management and Information Systems / Degree in Video Game Design and Production

Polytechnic School

General information

Teaching languages

Skills

Basic skills

Specific skills

Transversal competences

Description

Contents

Evaluation system

REFERENCES

Institution

Study

Become an entrepreneur

Community