Databases26020
- Centre
- Faculty of Informatics
- Degree
- Bachelor's Degree in Informatics Engineering
- Academic course
- 2024/25
- Academic year
- 2
- No. of credits
- 6
- Languages
- Spanish
- Basque
- English
- Code
- 26020
TeachingToggle Navigation
Teaching guideToggle Navigation
Description and Contextualization of the SubjectToggle Navigation
The Databases (DB) course is the first one in a series of courses that are being taught under the specialisation in Databases and Software Engineering. Part of the contents of this course needs the
knowledge acquired in the courses Introduction to Programming, Modular Programming, Object Oriented Programming and Data Structures and Algorithms. In this course we deal with concepts that are in direct relationship with the courses Database Design and Database Administration, which are taught in the specialisation of Software Engineering.
Databases are ubiquitous across all businesses and industries, therefore the content of this course is
basic for any future professional in the field of informatics.
Skills/Learning outcomes of the subjectToggle Navigation
Knowledge about the characteristics, functionalities and structure of the database systems that allow the adequate use and implementation of solutions based on them. Ability to identify, develop,
implement and verify the most appropriate solutions to manipulate databases.
Learning outcomes include:
1. To know he structure and basic components of database systems and to understand their general
mode of operation.
2. To grasp the main theoretical concepts of the relational model.
3. To understand the schema of a relational database, how to create relational databases and to be
able to modify and manipulate the data stored in the database, using the functionalities of the
Database Management Systems.
4. To learn the standard language for the creation and manipulation of relational databases (SQL)
both at a theoretical and practical level by means of a specific Database Management System. To
use SQL to specify queries on a database at various levels from beginner to expert.
5. To learn the concept of transaction, its characteristics and to understand how to manage them
properly.
6. To know the theoretical foundations of database programming from external applications and to
be able to carry out a practical case. To use skilfully some software development tools and
environments.
Theoretical and practical contentToggle Navigation
1. Database System Concepts.
2. The relational model.
2.1. Relational model, constraints and schemas
2.2. Relational algebra
3. SQL Language: definition, queries and basic DB manipulation.
3.1. SQL Data Definition Language
3.2. Basic Retrieval Queries
4. Advanced SQL.
4.1. Complex SQL queries and operations
4.2. Exercises on SQL queries.
5. Transaction Processing. Definitions and use.
6. Database programming through applications. JDBC.
MethodologyToggle Navigation
The course will have 150 hours (60 face-to-face hours and 90 non-presential hours). In this course
we use several teaching methodologies. There are three types of classroom activities: master classes
(lectures), practice classes and laboratory sessions. The topics of the course will be presented in
classroom lectures and complementary reading material will be indicated. The description of the
topics will be followed by exercises that will consolidate the concepts explained in the lectures.
Laboratory practices will be carried out in face-to-face and non-face-to-face sessions.
The methodology assumes continuous attendance to lectures, working on the solutions to the
proposed problems and programming projects and the active participation in the class sessions.
There are practical cases using tools like Relax and other well-known DBMSs such as MySQL.
Assessment systemsToggle Navigation
- Continuous Assessment System
- Final Assessment System
- Tools and qualification percentages:
- See below weights and types of evaluation (%): 100
Ordinary Call: Orientations and DisclaimerToggle Navigation
The preferential, and default, method of assessment is the Continuous Assessment. Nevertheless, the student may renounce this option by sending a writing message to the corresponding teacher.
(1) Continuous Assessment
------------------------
The weights used in continuous assessment are as follows:
- Activities related to continuous tracking of the student performances: 70% (2-3 partial exams, see calendar).
- Assessment of the practice work 30%, could include the following activities: colaborative team-work, problem-solving workouts, and/or programming projects. You'll find more details in the Student Guide. To pass the subject, it will be a necessary condition to obtain the established minimum of 4 out of 10 in the evaluation part of the 4th learning outcome (related to SQL).
(2) In global assessment,
------------------------
100% of the grade will be assessed in the final exam. To pass the subject, it will be a necessary condition to obtain the established minimum of 4 out of 10 in the evaluation part of the 4th learning outcome (related to SQL).
Extraordinary Call: Orientations and DisclaimerToggle Navigation
In the supplemental assessment, similar criteria is used, 100% of the grade will be assessed in the final exam. To pass the subject, it will be a necessary condition to obtain the established minimum of 4 out of 10 in the evaluation part of the 4th learning outcome (related to SQL).
Compulsory materialsToggle Navigation
- eGela
- Relax tool
- MySQL
- JDBC
BibliographyToggle Navigation
Basic bibliography
[EN] Elmasri, Ramez & Shamkant B. Navathe. (2010). Database Systems. Global edition, Sixth
Ed. Pearson Education. ISBN 9780132144988.
[EN] Elmasri, Ramez & Shamkant B. Navathe. (2016). Database Systems. Global edition. 7th ed.
Pearson Education. ISBN-13: 978-0-13-397077-7
[EN] Comeau, Andrew. MySQL Explained. OSTraining, 2016.
In-depth bibliography
[EN] Thomas Connolly and Carolyn Begg. (2015) Database Systems: A Practical Approach to
Design, Implementation and Management. Global edition, 6th Ed. Pearson Education.
[EN] Silberschatz Abraham, Korth Henry y Sudarshan S. (2011). Database System Concepts. 6th
Ed. McGraw-Hill Higher Education. ISBN 978-0-07-352332-3
[EN] Edward Sciore, Database Design and Implementation, 2nd Edition, 2020,
https://doi.org/10.1007/978-3-030-33836-7
[ES] Pérez, T.A. & Irastorza, A. (2012). 26 Dominios Con Ejercicios de SQL: 270 Consultas de
SQL de nivel avanzado. Editorial Académica Española. ISBN 978-3659028137
[EU] Irastorza, A & Pérez TA. (2012). 26 Domeinu SQL Ariketekin: Maila aurreratuko 270 SQL
kontsulta. Editorial Académica Española. ISBN 978-3659018169
Web addresses
https://www.mysql.com/
http://www.mysqltutorial.org/
https://dbis-uibk.github.io/relax/landing
https://www.pearson.com/us/higher-education/program/Elmasri-Fundamentals-of-Database-
Systems-7th-Edition/PGM189052.html
GroupsToggle Navigation
16 Teórico (Spanish - Tarde)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 17:00-18:30 (1) | 15:30-17:00 (2) |
Teaching staff
16 Applied laboratory-based groups-1 (Spanish - Tarde)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 14:00-15:30 (1) |
Teaching staff
16 Applied laboratory-based groups-2 (Spanish - Tarde)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 17:00-18:30 (1) |
Teaching staff
31 Teórico (Basque - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 12:00-13:30 (1) | 10:30-12:00 (2) |
Teaching staff
31 Applied laboratory-based groups-3 (Basque - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 10:30-12:00 (1) |
Teaching staff
31 Applied laboratory-based groups-2 (Basque - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 12:00-13:30 (1) |
Teaching staff
31 Applied laboratory-based groups-1 (Basque - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
18-32 | 09:00-10:30 (1) |
Teaching staff
31 Applied laboratory-based groups-4 (Basque - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
18-32 | 14:00-15:30 (1) |
61 Teórico (English - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 12:00-13:30 (1) | 10:30-12:00 (2) |
Teaching staff
61 Applied laboratory-based groups-1 (English - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 09:00-10:30 (1) |
Teaching staff
61 Applied laboratory-based groups-2 (English - Mañana)Show/hide subpages
Weeks | Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|---|
16-30 | 12:00-13:30 (1) |