Person in charge: | (-) |
Others: | (-) |
Credits | Dept. |
---|---|
7.5 (6.0 ECTS) | ESSI |
Person in charge: | (-) |
Others: | (-) |
Students will be introduced to Database Management Systems, and Object Management Systems, their architectures and the techniques they use to solve the problems involved in database management. Thus, students will focus on advanced topics in RDBMS (Relational Database Management Systems), and new, post-relational DBMS.
Estimated time (hours):
T | P | L | Alt | Ext. L | Stu | A. time |
Theory | Problems | Laboratory | Other activities | External Laboratory | Study | Additional time |
|
T | P | L | Alt | Ext. L | Stu | A. time | Total | ||
---|---|---|---|---|---|---|---|---|---|---|
4,0 | 0 | 0 | 0 | 0 | 4,0 | 0 | 8,0 |
|
T | P | L | Alt | Ext. L | Stu | A. time | Total | ||
---|---|---|---|---|---|---|---|---|---|---|
6,0 | 3,0 | 0 | 0 | 0 | 9,0 | 0 | 18,0 |
|
T | P | L | Alt | Ext. L | Stu | A. time | Total | ||
---|---|---|---|---|---|---|---|---|---|---|
11,0 | 5,0 | 0 | 0 | 0 | 16,0 | 0 | 32,0 |
|
T | P | L | Alt | Ext. L | Stu | A. time | Total | ||
---|---|---|---|---|---|---|---|---|---|---|
8,0 | 3,0 | 0 | 0 | 0 | 6,0 | 0 | 17,0 |
|
T | P | L | Alt | Ext. L | Stu | A. time | Total | ||
---|---|---|---|---|---|---|---|---|---|---|
3,0 | 0 | 0 | 0 | 2,0 | 5,0 | 0 | 10,0 |
Total per kind | T | P | L | Alt | Ext. L | Stu | A. time | Total |
32,0 | 11,0 | 0 | 30,0 | 2,0 | 40,0 | 30,0 | 145,0 | |
Avaluation additional hours | 5,0 | |||||||
Total work hours for student | 150,0 |
The courses comprise two parts: Theory and problems: (making up a little over half the course) and seminars.
SEMINARS
15 sessions of two hours each.
Each seminar theme will be prepared by two groups of paired students:
1st group: this will present the theme (1 hour).
2nd group: this will have the task of responding on the theme (1/2 hour).
The rest of the students will submit a report and solve a short exercise or complete a questionnaire on the theme.
During the course there will be some sessions dedicated to solve exercises. In addition, students will solve exercises at home and will prepare a presentation to be exposed in class. All of them are taken into account in the final grade as follows:
Final = 55% P + 35% S + 10% C
P = weighted average of the grades of the class exercises (5% correspond to the grade of teamwork that will put the teacher from scores awarded by the different peers everyone has had throughout the course)
S = Presentation (5% will be decided by the teacher according to scores awarded by the peers group that attends presentations)
C = weighted average of the grades of the exercises done at home
Obtaining P and C:
1) Multiply the grade earned in each exercise to a weight equal to 1, 2 or 4 (depending on the content of the problem). There will more than 6 exercises during the course.
2) Divide the sum of these values by the sum of the assigned weights
Learn the relational model, including relational algebra and SQL:1999.
Learn the fundamental aspects affecting DB design and management.
Suggested prerequisites: DABD.