Degree | Type | Year |
---|---|---|
Computational Mathematics and Data Analytics | OB | 2 |
You can view this information at the end of this document.
It is recommended that the student has knowledge and skills of:
These concepts correspond to content of the subjects:
In this course we will introduce basic concepts of relational databases (DB), which are necessary both for users and designers.
Knowledge:
At the end of the course the student will be capable of:
Abilities:
At the end of the course the student will develop the following abilities:
Introduction and basic concepts
2. Architecture
3. Design. The entity-relationship model
4. The relational model of databases
5. The design of a database
6. Internal level
Title | Hours | ECTS | Learning Outcomes |
---|---|---|---|
Type: Directed | |||
Practical Sessions | 10 | 0.4 | KM15, SM16, KM15 |
Theory and Problems Sessions | 36 | 1.44 | CM17, CM18, SM17, CM17 |
Type: Supervised | |||
Tutorials | 15 | 0.6 | CM17, CM18, KM15, SM16, SM17, CM17 |
Type: Autonomous | |||
Database creation and writing of its corresponding technical report | 25 | 1 | CM17, CM18, KM15, SM16, SM17, CM17 |
Exercise preparation and theoretical quizzes resolution | 15 | 0.6 | CM17, CM18, SM16, SM17, CM17 |
Practical sessions' preparation | 5 | 0.2 | CM17, CM18, KM15, SM16, SM17, CM17 |
Study | 36 | 1.44 | CM17, CM18, KM15, SM16, SM17, CM17 |
The learning process will be based on three types of activities: theory and problem-solving classes, practical sessions, and the writing of a technical report on a database. All documentation and materials needed to follow the course will be available through the Caronte platform (http://caronte.uab.cat).
GUIDED LEARNING ACTIVITIES
Theory and Problem-Solving:
Theory sessions are delivered through lectures supported by documentation and presentations. Theoretical concepts necessary to solve the problems presented throughout the course will be introduced. During problem-solving hours, exercises will be proposed to be solved in class, and independent work will be encouraged so that each participant can complete the remaining exercises, with access to the database and solutions.
Problem-solving sessions are structured into two blocks:
In the first block, participants will practice designing using the E/R model based on specific requirements.
In the second block, the SQL language (Structured Query Language) will be introduced, with supporting materials, and queries will be performed using relational algebra and SQL on a sample database with specific content.
Practical Sessions:
The aim of the practical sessions is to introduce participants to SQL, the standard language for querying databases. Each session will consist of a series of exercises on a database, helping to reinforce theoretical concepts and become familiar with the design, creation, and manipulation of relational databases, both as users and developers.
Participants are expected to prepare the practical work in advance, based on the provided instructions. The work will be completed during the supervised sessions.
Instructions, submission guidelines, and evaluationcriteria for the practicals can be found in the corresponding documents on Cerbero.
AUTONOMOUS LEARNING ACTIVITIES
Technical Report on Database Creation:
In parallel with theory, problem-solving, and practical sessions, each participant will take part in the creation of a database. This project will result in a technical report and the necessary scripts for creating and validating the database. The work will be carried out in groups of 4 or 5 and will be mostly autonomous, under the supervision of the teaching staff during scheduled tutorials.
Self-Managed SQL Practice:
Participants will also engage in self-managed SQL problem-solving activities. These will be completed individually, at times chosen by each person within the limits set by the course schedule.
Instructions, submission guidelines, and evaluation criteria for these activities are available on the Caronte platform.
SUPERVISED LEARNING ACTIVITIES
Tutorials:
Tutorials aim to resolve doubts and consolidate the knowledge acquired during the week. They may be individual or in groups, depending on the topic. Tutorial schedules will be set at the beginning of the course. Participants should notify the instructor in advance (preferably by email) before attending.
All necessary materials (instructions, database scripts, problem results) will be available on the Caronte platform (http://caronte.uab.cat).
Annotation: Within the schedule set by the centre or degree programme, 15 minutes of one class will be reserved for students to evaluate their lecturers and their courses or modules through questionnaires.
Title | Weighting | Hours | ECTS | Learning Outcomes |
---|---|---|---|---|
Autonomous SQL Query Resolution | 10 | 2 | 0.08 | KM15 |
Practical Assessment | 20 | 2 | 0.08 | KM15 |
Technical Report | 20 | 0.5 | 0.02 | CM17, CM18, KM15, SM16, SM17 |
1st Partial Exam | 20 | 1.5 | 0.06 | CM17, CM18, SM17 |
2nd Partial Exam | 30 | 2 | 0.08 | CM17, KM15, SM16, SM17 |
EVALUATION CRITERIA
The course evaluation consists of five parts: Partial Evaluation 1, Partial Evaluation 2, a technical report, practical assessment, and independent resolution of SQL queries.
Nota_Final = 0,2 * Nota_Parcial1 + 0,3 * Nota_Parcial2 + 0,2 * Nota_Pract + 0,2 * Nota_InfTec + 0,1 * Nota_AutoAval
To calculate this final grade, each component must be greater than zero, and the average score of the written tests (Nota_PEI) must be ≥ 4.5.
To pass the course, the final grade (Nota_Final) must be ≥ 5. Students who do not complete any evaluation activity will be marked as “not assessable.”
RE-EVALUATION CRITERIA
Students who did not pass may be eligible for re-evaluation if:
The re-evaluation test (Nota_reeval), written and held in the final week, covers the entire course. The new final grade is the average of Nota_reeval and Nota_PEI. If this average is ≥ 5, the student passes.
The re-evaluation date is set in the Faculty’s exam calendar.
To participate in re-evaluation, students must have completed at least two-thirds of the total course assessments.
If not eligible, the final grade will be the lower of Nota_PEI or 4.5.
SINGLE ASSESSMENT MODALITY
Students opting for single evaluation will take a test with three parts:
Final grade weighting:
If the final grade is below 5, a recovery exam (Parts A and B only) may be taken. Part C is not recoverable. If the recovery grade is ≥ 5, the final grade will be 5 (pass).
OTHER IMPORTANT INFORMATION
Evaluation Calendar
Dates for assessments (exams, exercises, submissions, etc.) will be announced in advance during the semester. The final exam date is set in the Faculty’s exam calendar.
Assessment dates cannot be changed unless there is a justified exceptional reason. In such cases, a new date will be proposed in consultation with faculty and affected students.
Grade Review Procedure
The date and method for publishing final grades will be announced with the final exam. Information on how to request a review, including time and place, will also be provided according to university regulations.
Irregularities in evaluation activities
In spite of other disciplinary measures deemed appropriate, and in accordance with current academic regulations, "in the case that the student makes any irregularity that could lead to a significant variation in the grade of an evaluation activity, it will be graded with a 0, regardless of the disciplinary process that can be instructed. In case of various irregularities occur in the evaluation of the same subject, the final grade of this subject will be 0". Section 10 of Article 116. Results of the evaluation. (UAB Academic Regulations).
Basic Bibliography
Complementary Bibliography
Web links
Please note that this information is provisional until 30 November 2025. You can check it through this link. To consult the language you will need to enter the CODE of the subject.
Name | Group | Language | Semester | Turn |
---|---|---|---|---|
(PLAB) Practical laboratories | 1 | Catalan/Spanish | first semester | morning-mixed |
(TE) Theory | 1 | Catalan/Spanish | first semester | morning-mixed |