Degree | Type | Year | Semester |
---|---|---|---|
2502441 Computer Engineering | OB | 3 | 1 |
2502441 Computer Engineering | OT | 4 | 1 |
It is recommended that the student have the knowledge and skills of:
These concepts correspond to contents of the Database course.
In this course we introduce the advanced concepts of Databases (DB) necessary both at the designer level of BD and user.
KNOWLEDGE: At the end of the course the student must be able to:
SKILLS: It is intended that students acquire the following abilities:
To work with the previous skills with relational DBMS, such as ORACLE, which is widely used in the professional field, both at user level and administrator level and non-relational DBMS, such as MongoDB.
* The hours in parentheses are estimates of the hours that the students will dedicate to each subject, counting the classroom hours in class and the hours outside the classroom.
In this course we will follow a flipped class methodology. In this methodology, the study of the theoretical contents must be carried out before face-to-face sessions, as autonomous activities of the students, based on the material and documentation that students will have access through the virtual campus. In class, lectures become practice sessions for solving exercises and carrying out the project, aimed at solving all the doubts and problems that have been encountered throughout the week.
There will be two types of activities: theory and project activities. The theory activities will be aimed at consolidating the most theoretical aspects of the course. A part of them will be individual while others will be done in work groups. The project will be an essentially practical group activity that will be carried out throughout the course and will help to consolidate the theoretical aspects worked in class.
The work groups will be groups of 4 students, will be formed on the first day of class and will remain stable throughout the course. They will be the same for group theory activities and the project.
Not counting the hours that have to be devoted to prepare the partial exams. An average load of 9 hours per week and student distributed in the following activities has been calculated:
Cross-disciplinarycompetences: In this course the competence T01.02 must be worked out - Develop the capacity for analysis, synthesis and prospecting. This will be done throughout the course in all the activities that must be done but with more intensity in the resolution of problems and project.
Title | Hours | ECTS | Learning Outcomes |
---|---|---|---|
Type: Directed | |||
Inclass sessions | 26 | 1.04 | 7, 3 |
Type: Supervised | |||
Problem solving and project | 24 | 0.96 | 2, 1, 7, 3 |
Type: Autonomous | |||
Previuos work | 26 | 1.04 | 2, 1, 6, 7, 8, 5, 4, 3 |
Study and preparation of partial tests | 20 | 0.8 | 6, 7, 8, 5, 3 |
project developement | 39 | 1.56 | 2, 1, 7, 4, 3 |
The evaluation will be carried out continuously. There will be two individual theoretical-practical tests in writing, with a weight of 50% each on the final grade. The first test (Par1) will be done approximately in the middle of the semester and will evaluate the theoretical concepts and management skills and administration of databases treated in the 1st part of the course. The second test (Par2) will be done at the end of the semester and will evaluate the theoretical concepts and management skills and database administration discussed in the 2nd part of the course.
Second chance exam: In case that the mean of both theoretical-practical exams does not reach the minimal mark to pass, students will have a second-chance exam on all the contents explained during the course.
Most of the weeks there will be the possibility to submit activities done during the week. The submission is optional and can be done up to fixed deadline set in advance in the Virtual Campus. With 50% of the maximum possible score students will be able to achieve the maximum score (1 point) of this activity (NPrb). The score will be obtained from cross-correction activities between students.
Cross-correction problems (CorPr) are also optional and will be made by students who already have submitted the exercises. Students will be able to obtain a maximum of one point in this activity that will be added to the theory score whenever the minimum score has been obtained in all the partial ones.
The score of the project will be obtained from the average of the obtained score in each part. There will be 3 parts: Prj1, Prj2 and Prj3. The score of each part will be computed from a group score and an individual score. Each project part must be passed separately. In the case of failing any of the them, the student will have a second-chance to pass that part. In that case, a 5 will be the maximum possible score for the failed part.
QUALIFICATION INDICATORS:
The final grade ofthe subject is calculated as follows:
EVALUATION CRITERIA
EVALUATION CALENDAR:
The delivery dates will be published in Caronte (http://caronte.uab.cat) and may change due to be adapted to any unexpected incidents. Any change will also be announced through Caronte since it is the usual communication channel between teachers and students.
For each assessment activity, a place, date and time of revision will be indicated in which the student will be able to review the activity with the teacher. In this context, claims can be made about the activity score, which will be evaluated by the teachers responsible for the subject. If the student does not submit to this review, this activity will not be reviewed later.
Note about plagiarism:
Without prejudice to other disciplinary measures deemed appropriate, and in accordance with the current academic regulations, irregularities committed by a student who may lead to a variation of the qualification in an assessable activity will be graded with zero (0). Assessment activities qualified in this way and by this procedure will not be recoverable. If it is necessary to pass any of these assessment activities to pass the subject, this subject will be suspended directly, without opportunity to recover it in the same course. These irregularities include, among others:
the numerical official grade will be the lowest value between 3.5 and the average weighted grades in case the student has committed irregularities in an evaluation act (and therefore the subject cannot be passed by compensation). In future editions of this subject, the student who has committed irregularities in an evaluation act will not be validated any of the assessment activities carried out.
In summary: copy, let copy or plagiarize (or attempt) in any of the assessment activities will lead to a FAIL, not compensable and without validations of parts of the subject in subsequent courses.
Title | Weighting | Hours | ECTS | Learning Outcomes |
---|---|---|---|---|
1st Theory exam | 0.25 | 2 | 0.08 | 6, 7, 8, 5, 3 |
2nd Theory exam | 0.25 | 2 | 0.08 | 2, 1, 7, 8, 3 |
Problem delivery (NPrb) | 0.1 | 2 | 0.08 | 2, 1, 6, 7, 8, 5, 4, 3 |
Project delivery | 0.4 | 6 | 0.24 | 2, 1, 7, 4, 3 |
peer correction exercises (CorPr) | 0.05 | 3 | 0.12 | 2, 1, 8, 3 |
COURS MATERIAL: http://caronte.uab.cat.
BASIC BIBLIOGRAFY:
COMPLEMENTARY BIBLIOGRAFY:
WEB LINKS:
RELATIONAL & NO RELATIONAL DATABASES: