Academic year 2015-16
Databases
| Degree: | Code: | Type: |
| Bachelor's Degree in Computer Science | 21412 | Compulsory subject, 1st year |
| Bachelor's Degree in Telematics Engineering | 21301 | Compulsory subject, 1st year |
| Bachelor's Degree in Audiovisual Systems Engineering | 21601 | Compulsory subject, 1st year |
| ECTS credits: | 4 | Workload: | 100 hours | Trimester: | 3rd |
| Department: | Dept. of Information and Communication Technologies |
| Coordinator: | Horacio Saggion |
| Teaching staff: | |
| Language: | |
| Timetable: | |
| Building: | Communication campus - Poblenou |
Databases which is part of the Engineering degree is the last in a series of the first year’ course.
The goal of the course is to analyze and solve problems related to relational databases.
The course introduces the following key concepts: conceptual modeling, relational algebra, relational model and SQL query language.
The course consists of three main activities: lectures, seminars and laboratories. The lectures introduce the basic concepts of databases showing its application in exercises done by the theory teacher.
In the seminars, students solve problems that are proposed in advance.
In the labs assignments of low and medium complexity are proposed that require the application of the knowledge acquired in theory and seminars .
The course assumes that the student has knowledge of programming, linear algebra, logic and discrete mathematics. The previously acquired mathematical knowledge are fundamental to the understanding of relational algebra.
None
According to the lines of the school the following competencies will be worked and acquired.
|
Transferable Skills |
Specific Knowledge |
|
Instrumental Analysis and synthesis Organization and planning Application of acquired knowledge to problem solving Information search and management Interpersonal Ability to work in a group Systemic Autonomy Motivation
|
Learn and apply techniques and methods studied. Design databases using models and techniques of the course. Write appropriate SQL queries. Solve relational algebra problems. |
The evaluation takes into account theory, seminars, and labs. The final mark (NF) is computed using the following formula:
NF= 0,5 x T + 0,35 x L + 0,15 x S
Where T is the mark obtained in theory, L is the mark from laboratory assignments, and S is the note obtained in the seminars.
In order to pass the course, it is mandatory to have at least 40% of the theory, 40% of the laboratory, and 40% of the seminars. In case the student obtains less than these thresholds the student will not pass the course and the mark obtained will be that of the minimum note among T, L, and S.
Theory is evaluated with a multiple choice exam (each question has 4 possible answers from which only one is true). Each correct answer adds one point. Each wrong answer substracts 0,25 points. No answers add zero points.
Laboratory assignments are solved in a group of 2 or 3 students. The first assignment accounts for 40% of the total mark L and the second assignment for 60% of the total mark.
Seminar assignments are a series of exercises that the students have to submit at the end of the seminar or the day following the seminar.
Students who fail the theory examination in June are allowed to take a second examination in July.
The course is a cycle of theory followed by seminars and labs. The theory introduces the concepts which are then applied in seminars (exercises) and labs (long assignments requiring much dedication). It is highly recommended that the student dedicates at least 2 hours to review the theory.
|
|
Hours in class |
Outside |
|
||
|
Content |
Teory |
Lab |
Seminar |
|
|
|
(I) |
6 |
|
2 |
16 |
|
|
(II) |
8 |
6 |
4 |
36 |
|
|
(III) |
4 |
4 |
2 |
20 |
|
|
Examen |
1 1/2 |
|
|
|
|
|
Total: |
19 1/2 |
10 |
8 |
72 |
Total: |
Software
SQL command line & SQL WorkBench
Bibliography
H. Garcia-Molina, J.D. Ullman, J. Widom: Database Systems – The Complete Book.
Harington, Jan L. SQL clearly explained. Morgan Kaufmann Publishers/Elsevier 2010. 3rd Ed.
R. Tamakrishnan and J. Gehrke. Database Management Systems. 3rd Edition McGraw-Hill 2003.
Takahashi, Mana. The Manga guide to databases. NoStarch Press, Inc. 2009.
J. Sistac. Bases de Dades. EdiUOC. 2000. (Segona edició 2005).
C.J. Date. An Introduction to Data Base Systems. 6th Edition. Addison-Wesley. 1995.
Ullman J.D. Widom, J. A First course in database systems. Prentice Hall. 2002.
Elmasri, R., Navathe, S.B. Fundamentos de Sistemas de Bases de Datos. Addison Wesley. 2004.