TecnoCampus Foundation
eCampus
University Business
eCampus

What are you looking for?

General information

Subject type: Mandatory

Coordinator: Ana Beatriz Pérez Zapata

Trimester: Second term

Credits: 4

Teaching staff: 

Alfonso Palacios González

Teaching languages

  • Catalan
  • Spanish
  • English

The teaching of this subject is mainly in Catalan. However, some sessions, the bibliography, part of the contents and the tools can be in Spanish or English.

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

     

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 to deepen the knowledge of databases and database management systems (DBMS). The course goes through all the stages of database design - conceptual, logical, physical, external - and studies the advanced features of SQL.  

Contents

Content 1: The database design process

Dedication:

  • large group activities: 10 hours
  • seminars: 6 hours
  • small group activities: 4 hours
  • autonomous learning: 30 hours

Description: 

Introduction to the process of designing and implementing a database from the capture of requirements to the generation of the database, through the stages of conceptual design, logical design and physical design.

Conceptual data modeling and standardization tools and techniques are used for the conceptual design stage and relational data modeling for logical and physical designs. 

Topics:

1.1 Introduction to database design

1.2 Conceptual design: from the requirements to the conceptual data scheme

1.3 Logical design: from the conceptual scheme to the logical scheme

1.4 Physical design: database generation

1.5 Normalization

 

 

Content 2: Development and use of databases with advanced SQL

Dedication:

  • large group activities: 10 hours
  • seminars: 4 hours
  • small group activities: 6 hours
  • autonomous learning: 30 hours

Description: Deepening the knowledge of SQL to implement the logical and physical design of a relational database

Topics: 

2.1 Data Recovery with Advanced SQL: Functions, Operators, Table Combinations, Set Operations, and Results Sorting

2.2 Time management in advanced SQL

2.3 Advanced retrieval of grouped data

2.4 Subconsultations

2.5 Hierarchical recoveries

2.6 DML statements for large data sets

2.7 DDL statements for managing database schema objects

2.8 Access control

2.9 Views, materialized views, synonyms

2.10 Creation of access methods: indexes, clusters

 

 

 

 

Evaluation system

Qualification system (evaluation)

Activities 1 and 2 can be worked on as a team, however the evaluation of all activities is always individual.

 

Activity 1, Database troubleshooting with advanced SQL: 15% (practice sessions 1, 3 and 5 and seminars 4 and 5) IT IS NOT RECOVERABLE

Activity 2, Project of design and generation of a database from an analysis of requirements: 15% (practice sessions 2 and 3 and seminars 1,2 and 3) IT IS NOT RECOVERABLE

Activity 3, Database Design Exam (Content 1): 35% 

Activity 4, SQL Exam (Content 2): 35% 

 

All notes are mandatory. A grade equal to or higher than 5 is required in each activity to pass the subject and be able to make the average.

Only those who have taken the ordinary individual assessment can apply for recovery.

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

 

In all activities it is compulsory attendance to be evaluated. (exams, seminars and internship sessions)

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.

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

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

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