General information


Subject type: Basic

Coordinator: Ana Beatriz Pérez Zapata

Trimester: Third term

Credits: 6

Teaching staff: 

Montserrat Rabassa Jou
Laura Beltran Perez 

Teaching languages


  • Catalan

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

     

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

     

Description


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. 

 

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.

Evaluation system


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.65 WRITTEN TEST OF ALL BLOCKS

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

And the final grade is obtained:

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

Recovery

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 their THEORY grade 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.

REFERENCES


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.