TecnoCampus Foundation
eCampus
University Business
eCampus

What are you looking for?

General information

Subject type: Optional

Coordinator: Juan José Pons López

Trimester: Third term

Credits: 6

Teaching staff: 

Montserrat Rabassa Jou
Laura Beltran Perez 

Academic year: 2024

Teaching course: 4

Languages ​​of instruction

  • Catalan

The subject offers official ORACLE material in English.

Competencies / Learning Outcomes

Specific skills

  • E6. Develop video games in high-level programming languages ​​in graphics engines based on specifications.

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

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

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 the grade for the THEORY part 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.