What are you looking for?
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
EFB4_Basic knowledge of the use and programming of computers, operating systems, databases and computer programs with application in engineering
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
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.
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.
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:
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.
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
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.