Academic year 2014-15
Database Design
| Degree: | Code: | Type: |
| Bachelor's Degree in Computer Science | 21427 | Compulsory subject, 3rd year |
| Bachelor's Degree in Telematics Engineering | 21776 | Optional subject |
| Bachelor's Degree in Audiovisual Systems Engineering | 21659 | Optional subject |
| ECTS credits: | 4 | Workload: | 100 hours | Trimester: | 2nd |
| Department: | Dept. of Information and Communication Technologies |
| Coordinator: | Esmeralda Ruiz |
| Teaching staff: | Esmeralda Ruiz i Bora Edizel |
| Language: | Esmeralda Ruiz (spanish) i Bora Edizel (english) |
| Timetable: | |
| Building: | Communication campus - Poblenou |
This subject is the second part of the data base subject given in the first course. The main goal is to present more advanced concepts focusing on the three main points: conceptual, logical and physical design.
Data Bases of the first academic year
| Transversal abilities | Specific Abilities |
|---|---|
|
Fundamentals G1. Analysis and Synthesis G2. Abiliity to plan and organize G3. Ability to apply knowledge to analyze situations and solve problems G4. Ability to search and manage information G5. Ability to make decisions G6. Ability to communicate, both orally and in writing, in Catalan and Spanish, to expert to amateur audiences. Interpersonal G8. Ability to work in a team Systemic G14. Ability and motivation to achieve quality |
T7: Good knowledge in the arquitecture of the DBMS including concurrency and crash recovery IN13: Ability to design data bases using ER models, normalization techniques and efficient queries solved by algebra operations in SQL IN14: Ability to increase performance in a database by understanding how the DBMS works, the evaluation query plan and then, incorporating indexes, if necessary, or rewriting queries maximizing the DBMS features |
This course is graded on the basis of three components:
T: Written exam
P: Practicum assignments
S: Seminar assignments
The overall score is calculated as follows:
Nota final = 0’4 x T + 0’4 x P + 0’2 x S
The exam covers only theory and the minimum to pass the subject is 5.
Practicum sessions can be done in pairs. The mimimum grade to pass the subject for the practicum assignaments is 5.
Before every seminar session, some exercises are proposed so that students can discuss them during the seminar session. At the end of the class, students must submit their exercises individually. Seminar assignments are mandatory and the minimum grade required to pass the course is 5.
The seminar and practicum assignments are not recoverable. Only the written exam is recoverable.
1. Review of the first course DB
2. Conceotual Design (ER Model and UML)
3. Normalization Forms
4. Persistence Dessign
5. Physical Dessign
6. Concurrency Management
The usual process starts with the theory session where the thearetical-practical concepts are presented.
Then, some seminar sessions are done, where the student practices the concepts learnt in theory sessions.
The next step is the practicum sessions, where some more complex exercises are presented. This activity is done in groups and require students to work after class.
Bibliografia bàsica
• H. García-Molina, J.D. Ullman, J. Widom: Database Systems – The Complete Book . Prentice Hall, Second Edition, 2008.
• D. Jordan, C. Russell. Java Data Objects. O’Reilly, 2003.
• I.H. Witten, E. Frank, M. Hall. Data Mining – Practical Machine Learning Tools and Techniques. Third Edition, 2011
• A. Rajaraman, J.D. Ullman. Mining of Massive Datasets. Cambridge University Press, 2011.
Bibliografia complementària
• J. Sistac, Disseny de Bases de Dades, EdiUOC, 2002
• M. Keith, M. Schincariol. Pro JPA 2 Mastering the Java Persistence API. Apress, 2009.